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. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


Repeat Item Labels in a Pivot Table

Note: There is an updated post with detailed instructions for repeating pivot table row labels. Refer to that page

Pivot Tables for Excel 2007One of the new features in Excel 2010 relating to Pivot Tables is the ability to repeat the item labels. Why is this useful?

Pivot tables are often used as a means of extracting information from a database, and then the pivot table itself is used as a database. But previously you had to do some work to fill in the blank spaces with the label heading.

Now, you can click on the Repeat Item Labels switch and it will do it for you.


Learn more at our live advanced Excel courses in South Africa. Visit Live Excel Training page