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

How do you change the color scheme for only one PowerPoint slide?

That question was asked by one of the students in a PowerPoint class I held in Hanover, NH.  We were using PowerPoint 2010.  The answer to the question is this: You must create a new Slide Master and then apply the color scheme you need for one slide to that Slide Master.  The good news [...]

By | March 2nd, 2014|Office 2010 Tips, PowerPoint Tips, Uncategorized|Comments Off on How do you change the color scheme for only one PowerPoint slide?

PIVOTTABLE PREP: RULES FOR ORGANIZING SOURCE DATA IN EXCEL

Before you begin creating a PivotTable you need to be certain that the data is set up so the PivotTable will give you the results you expect.  There are 4 rules for organizing the Data to create a PivotTable report: #1:   The raw list of worksheet data must contain a header (individual column headings) row [...]

By | August 26th, 2012|Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Uncategorized|Comments Off on PIVOTTABLE PREP: RULES FOR ORGANIZING SOURCE DATA IN EXCEL

Use Wildcards to Find and Replace in Word

You can use Microsoft Word to find and replace text and you can extend your search by using wildcards to find words or phrases that contain specific letters or combinations of letters. For example, use the asterisk (*) wildcard to search for a string of characters ("b*n" finds "ban" and "balloon"). On the Edit menu, [...]

By | June 29th, 2009|Uncategorized, Word Tips|1 Comment