March 14, 2017
Hi fellow Excel Addict,
In today's 'Excel in Seconds' tip, I'm going to show you how to 'Remove Workbooks From Your Recently-Used Workbooks List'.
In my last 'Excel in Minutes' tip from Thursday, I showed you a trick you can use to 'Print Grouped Data on Separate Pages'. This one is pretty cool, so if you missed it you can read it here.
Almost 'blown away'. Not by Excel this time.
Last Saturday a massive windstorm blew through eastern Newfoundland. The winds were the highest that have been recorded here in over 40 years. The top gusts were recorded at 180 kmh (112 mph). They may not have been quite that high in the area where I live but they were high enough to destroy my back fence that came through Hurricane Igor 6 years ago unscathed. Thankfully there was no snow or rain accompanying the wind this time. That would have been REALLY bad.
Please feel free to share my newsletter with your Excel friends — they will thank you for it.
Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Remove Workbooks From Your Recently-Used Workbooks List
As you have probably noticed, Excel displays a list of workbooks you have recently worked on when you click File, Open, Recent Workbooks.
This makes it easy to open workbooks you have recently worked on so you don't have to browse all the way through the folder hierarchy to get to the file. However, sometimes your list may contain a certain recent workbook that you don't want to have listed, either for confidential or other reasons.
To remove a workbook from this list, you can simply right click it and choose 'Remove from List'.
You can also clear all workbooks except the ones that are pinned by right clicking and choosing 'Clear unpinned Workbooks'.
As you open more workbooks, the one at the bottom of the list drops off. If you like this Recent Workbooks feature and would like to increase the number of workbooks shown in the list, you can easily change the number or workbooks listed. From the File tab click, Options, Advanced and in the Display section, choose the number of files you want to display in the 'Show this number of Recent Documents'
You probably have also figured out that you can click the little thumb tack icon to the right of a recent workbook in the list to 'pin it' so it doesn't drop off. This is great for workbooks you use 'kind of frequently' but sometimes they drop off the list.
If you've found this tip helpful, please click here to share it.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630