These tips, tricks, and shortcuts are for Microsoft Office 2007.
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 [...]
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 [...]
Excel PivotTable Issue: Create a Calculated Field that has a Field Title that uses Alt + Enter to Split the Field Title into Multiple Lines
One of the rules for working with an Excel database and preparing it for a PivotTable is that the raw list of worksheet data must contain a header (individual column headings) row and that row can only be one row deep. NOT this! Below is a workbook with titles on one row but that [...]