These tips, tricks, and shortcuts are for Microsoft Excel.

Prep a Workbook to Save as a Template

This Blog is for a favorite non-profit in Manchester, NH … You have an existing workbook that you need to replace the old data in all the cells with “constant numbers” – maybe it is daily, weekly, monthly, quarterly – frequency doesn’t matter. How did you do this in the past?  Maybe you: Opened the [...]

By | September 24th, 2016|Excel Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Prep a Workbook to Save as a Template

Excel 2013’s Start Screen

If you are like me, you will prefer that Excel 2013 opens to a blank new workbook, not the start screen: Steps to make the blank new workbook your opening screen: Double-click on Blank workbook from the start screen. Click the File Tab Select Options at the bottom of the list on the left In [...]

By | March 23rd, 2016|Excel Tips, Office 2013|2 Comments

Insert an Empty Row Between Each Row of Data in Excel

My daughter phoned one day to ask how she could add an empty row between each row of data in Excel.  This is a quick and easy solution:  Insert a column to the left of Column A In the empty column enter “1” in the row with the 1st row of data AutoFill the number [...]

By | February 14th, 2016|Excel Tips, Office 2007 Tips, Office 2010 Tips, Office 2013, Uncategorized|Comments Off on Insert an Empty Row Between Each Row of Data in Excel

Need more screen space for your Excel Dashboard?

With just a few setting changes, you can open the screen on your monitor to allow for more space for your Excel Dashboard: On the View Ribbon, in the Show section, remove the check mark from: Gridlines Formula Bar Headings Click the File tab, then Options.  On the left select Advanced.  Scroll to the section [...]

By | October 13th, 2015|Dashboard Tips, Excel Tips, Office 2010 Tips, Office 2013|Comments Off on Need more screen space for your Excel Dashboard?