July 12, 2016
Hi fellow Excel Addict,
Today's quick tip is one that I have been using regularly for years but apparently, I'm the only one (in my circle of friends) who knows about it. It has worked for me as far back as I can remember.
If you find it helpful, please feel free to share it with your friends—chances are they don't know about it.
If you missed last Thursday's Excel in Minutes' tip, 'AutoFormat Your Subtotal Rows Using Conditional Formatting', you can read it here now.
Wishing you a great week end keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
How to Delete A Workbook Without Leaving Excel
Do you know that you can delete files from within Excel?
There can be any number of reasons why you'd want to do this. For example, say you are opening an Excel workbook and, as you are browsing the folder, you see a file that you would like to delete. Rather than opening File Explorer (or Windows Explorer), you can quickly delete the file right from within Excel's Open dialog box.
Simply, right click the file you want to delete and click Delete from the pop-up menu.
You can also delete files the exact same way from the Save As dialog.
| '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