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

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?