Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Excel Format Cleaner

Problems are often caused by Excel users formatting more cells than they need. A useful workaround for this is the Excel format cleaner which is a free add in from Microsoft.

The typical example is highlighting the entire row to format instead of just the affected cells. Now that Excel has over a million rows and 16 000 columns, this method of formatting results in file size increases as Excel now has to remember the format of thousands, if not millions, of cells.

This is where an Excel format cleaner can assist in reducing the file size and increasing performance.