Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

March 14, 2017

Greetings from The Excel Addict

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.

Francis Hayes, Conception Bay South, Newfoundland, Canada (TheExcelAddict.com)

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)

TheExcelAddict.com Quote of the Day

"Failure will never overtake me
if my determination to succeed is strong enough."

-- Og Mandino ---

If you missed my last newsletter, you can click here to view it online.

Excel in Seconds with TheExcelAddict.com

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'.

Clear or Remove Recent Workbooks List in Microsoft Excel 2007 2010 2013 2016 365

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.

Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630