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 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'

2. 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!


Cannot find CSV in PowerPivot

If you are using PowerPivot in Excel you may be trying to import a csv file and find that when you browse for it, you cannot find it. If you cannot find csv in PowerPivot the chances are you either

  • haven’t selected the correct import type, or
  • haven’t changed the file type.

To import a CSV file you need to go into PowerPivot, go to the Home Ribbon, choose ‘From Other Sources’ and choose the text option at the bottom as shown below.


The other common problem is that users forget to change the type of file you are searching for. When you are browsing to the file, by default PowerPivot is searching for Flat files (.txt). If you are rather looking for either a Tab Separated File (.tab) or Comma Separated File (.csv) you need to change the file type as shown below


For this and more tips take our online PowerPivot course