In Excel 2010, you can pin workbooks you need to access often to make finding them nearly effortless.
Within the Backstage view is the Recent Workbooks list.
To access the Recent Workbooks list:
- Click the File tab.
- Click Recent.
Here you will see a list of recently accessed workbooks. This list changes based on the different files that you open and work with, and by default, the list is generated automatically by Excel.
If you have a workbook you work with often, you can "pin" it to the list. This way, it will always appear in the Recent Workbooks list.
To pin a workbook to the Recent Workbooks list, just click the pin icon next to the workbook you wish to keep in the list.
Notice that the pin changes to a push pin.
If you decide you no longer want the workbook to appear in the Recent Workbooks list, simply click the push pin icon to remove it.