JD's Tools & Techniques MS Excel 2010 Tip of the Day

JD's Tools & Techniques MS Excel 2010 Tip of the Day This one is an easy one that many forget. "set to print before you send"

Today's Tip Excel 2010: Remove the Pivot and leave the formatting. 

1. Select the entire table (Pivot Table Tools => Actions => Select =>Entire Pivot Table
2. Copy
3. Paste into a new empty cell using a the clipboard by clicking on the item.  This will paste without the pivot attached.  See attached picture. 

I use to use the copy => paste special => values.  MS Excel 2010 does not keep the formatting in this method.

My tip for today is remove all gridlines in a spreadsheet before sending out a report.  If the report was designed right there would not be a need for gridlines.