You may have a workbook you open daily that gets lost in the Recent Files list. The list shows the last few dozen files you opened, pushing older ones off the list. Excel’s pin feature lets you keep specific files at the top of this list permanently. This article explains how to pin and unpin workbooks for instant access.
Key Takeaways: Pin Workbooks in Excel
- Pin icon in Backstage view: Click the pushpin icon next to a file in the Recent list to lock it in place.
- File > Open > Recent: This is the primary menu path to view and manage your pinned and recent files.
- Unpin icon: Click the pinned pushpin icon again to remove a file from the pinned section and let it cycle off the list.
Understanding the Recent Files and Pinned Files List
When you click File > Open in Excel, the default view shows Recent workbooks. This list is generated automatically based on your file open history. A pinned file is exempt from this automatic cycling. It remains in a dedicated Pinned section at the top of the Recent list, regardless of how many other files you open. The pin is stored in your Windows user profile and syncs across devices if you use a Microsoft account with OneDrive. You need no special permissions to use this feature beyond the ability to open the file initially.
Steps to Pin and Unpin a Workbook
Use these steps to manage your pinned files directly within Excel. The process is the same for Excel on Windows 10, Windows 11, and Microsoft 365.
- Open the Backstage view
Launch Excel and click the File tab on the ribbon. This opens the Backstage view. - Go to the Open pane
In the left-hand menu, click Open. The main panel will default to showing your Recent workbooks. - Locate the pin icon
Find the workbook you want to pin in the list. To the right of the file name, you will see a pushpin icon. The icon appears gray or outlined when the file is not pinned. - Pin the workbook
Click the pushpin icon once. It will change to a filled, colored icon, indicating the file is now pinned. The file will immediately move to the Pinned section at the very top of the list. - Unpin a workbook
To remove a pin, click the filled pushpin icon next to the file in the Pinned section. The icon returns to its outlined state, and the file moves back into the standard Recent list.
Common Mistakes and Limitations to Avoid
Pinned File Shows as Grayed Out or Unavailable
A pinned file only stores a shortcut to the file’s location. If you move, rename, or delete the original workbook, the pinned entry will become grayed out. Clicking it will give a “file not found” error. You must unpin the old entry and pin the file again from its new location.
Pin Does Not Appear on Another Computer
Pins are part of your Excel application settings. They will sync if you are signed into Excel with the same Microsoft account and have roaming settings enabled. If you are using a local Windows account or work account, pins are stored only on that specific computer.
Too Many Pinned Files Clutter the List
The purpose of pinning is for quick access to a few critical files. If you pin 20 files, you defeat the benefit of a short, curated list. Regularly review your pinned section and unpin files you no longer use daily.
Cannot Pin a File From the Start Screen
The start screen that appears when launching Excel shows a separate list of recent files. You cannot pin files from this screen. You must enter the workbook, go to File > Open, and pin it from the Backstage view.
Pinned vs. Recent Files: Key Differences
| Item | Pinned Files | Recent Files (Unpinned) |
|---|---|---|
| Position in list | Always at the top, in a separate section | Below the Pinned section, ordered by open time |
| Persistence | Remains until manually unpinned | Cycles off the list as newer files are opened |
| Management | Manual control via pin/unpin icon | Automatic, based on file open history |
| Dependency | Requires the original file path to remain valid | Same dependency, but entry disappears if path breaks |
| Sync across devices | Yes, with Microsoft account and roaming settings | Yes, with Microsoft account and roaming settings |
You can now keep your most important Excel files one click away. Use the pin feature for budgets, reports, or templates you open every day. For another way to speed up access, try adding a workbook shortcut to your Windows Taskbar or Start menu. A related advanced tip is to use the Quick Access Toolbar command “Open Recent File” to create a dropdown list of recent files directly on the ribbon.