These tips, tricks, and shortcuts are for Microsoft Excel.
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 [...]
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 [...]
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 [...]
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 [...]