Save yourself hours with these tips for Microsoft Excel 2003, 2007, 2010, 2013, 365

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
September 22, 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



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



Excel in Seconds with TheExcelAddict.com

File, New, Blank Workbook...blah!

I can't believe Microsoft didn't include a 'new workbook' command on the Ribbon.

Most Excel users I observe start new workbooks by clicking File, New, Blank Workbook. It's only 3 clicks. But why make 3 clicks when you don't have to.

Some Excel users use the keyboard shortcut CTRL+N. Yes, nice and easy. But my preferred way is by clicking the New command on the Quick Access Toolbar (QAT). Yes, you can add a button to your QAT or Ribbon that allows you to open a new workbook with one click.

Add a New Workbook Command to your Quick Access Toolbar in Microsoft Excel 2007, 2010, 2013, 365
To add a new workbook command to your Quick Access Toolbar (QAT)

1) Right-click anywhere on Ribbon and choose 'Customize the Quick Access Toolbar';

Right Click Menu Customize Quick Access Toolbar in Microsoft Excel 2007, 2010, 2013, 365
2) From the 'Choose commands from' dropdown, select All Commands;

3) Scroll down the list of commands in the list on the left and select New (NOT New...);

4) Click the Add>> button then click OK.

Add a New Workbook Command to your Quick Access Toolbar in Microsoft Excel 2007, 2010, 2013, 365
Now you can open new workbooks with just one click or one keyboard shortcut...and save yourself some time. 


Thanks for supporting this newsletter and website


Subscription Information: Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter. If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com

 If you would like to share this newsletter with others...
1) Share a link to this page
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber.com
3)  Post a link to TheExcelAddict.com in a company newsletter or website.

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