These tips, tricks, and shortcuts are for Microsoft Office 2007.

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

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

Use Voting Buttons in Outlook

It’s easy to create a poll in Outlook by including voting buttons in an email message.  The poll responses arrive in your Inbox and are tallied in a tracking view. NOTE:  Microsoft Exchange Server is required! Follow the steps below to send a message with voting buttons: First, open a new email message from within [...]

By | December 6th, 2015|Office 2007 Tips, Office 2010 Tips, Office 2013, Outlook Tips|Comments Off on Use Voting Buttons in Outlook

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 [...]

By | June 21st, 2015|Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Excel PivotTable Issue: Create a Calculated Field that has a Field Title that uses Alt + Enter to Split the Field Title into Multiple Lines