FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
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:
  • read and implement them quickly,
  • see results immediately,
  • save valuable time day after day,
  • using these small tips daily can make a big difference.
"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)
Email: 
fhayes[AT]TheExcelAddict.com



Excel in Seconds with TheExcelAddict.com

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.

Open Multiple Files From Windows Explorer In One Step
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.

Open Multiple Excel Workbooks In Bulk in Microsoft Excel 2003, 2007, 2010, 2013, 365

Open Multiple Workbooks In One Step in Microsoft Excel 2003, 2007, 2010, 2013, 365
This works using File, Open from within Excel or by selecting multiple files in Windows Explorer.




Thanks for supporting this newsletter and website


FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

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