September 29, 2015
Hi fellow Excel Addict,
Thanks for being an 'Excel Addict'. This is the first of two newsletters that I will be sharing with you this week.
My 'Excel in Seconds' tips:
"Success is the sum of small efforts - repeated day in and day out." -- Robert Collier
Got an Excel tip that you use that can be carried out in less than a minute?
Please share it with me so I can use it in this newsletter to help others 'excel in seconds'. Be sure to put 'EXCEL IN SECONDS' in the subject line of your email.
Hope you enjoy this today's tip.
Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
Open Multiple Excel Files in One Step
See, I keep saying that Excel is full of surprises. Someone told me about this tip that I wasn't aware of before. I've always known that I could open multiple Excel workbooks (in fact, any almost any type of files) from Windows Explorer by selecting them all and clicking Open.
But I had never tried this from within Excel (File, Open).
Any time you need to open multiple Excel workbooks to work with at the same time, rather than opening them one by one, you can select them all (hold down the CTRL key while selecting them) and click Open.
This works using File, Open from within Excel or by selecting multiple files in Windows Explorer.
| '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