If you are like us, you may find yourself opening the same Excel file many times. Typically you may use the Recent file list to do this.
For Screenshots go to the latest post about this topic at https://www.auditexcel.co.za/blog/pin-regularly-used-excel-files/
In Excel 2007 and Excel 2010 there is a great new feature which allows you to ‘pin’ the files you regularly use. When you do this, the files will always be shown on the recent list, even if you haven’t used them recently.
To use, go to your Recent List (similar place to where you Open files). On the right of the file names you will see a ‘pin’. Click it. Excel 2007 and Excel 2010 handle it slightly differently but it is a great time saver.
See below how to perform this
Learn more at our Excel courses. Visit www.AuditExcel.co.za Live Excel Training page