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.

 

Pivot Table Dropdown Field List Missing

If you work regularly with Pivot Tables, you may have¬†times¬†when you are asked why is the Pivot Table dropdown field list missing. Has it disappeared? This can be very annoying especially when you know that there are other options you may want to choose, yet you can’t choose them, you are stuck on one option.

As per below, we know that there are other clients we want to view but for some reason there is no way to change this. The field list dropdown is missing. Similarly with the months. We can see January but how do we change it to February?

Pivot Table Dropdown Field List Missing

This is just a Pivot Table setting.

If you

  • click on the Pivot Table,
  • click on Analyse and
  • switch the Field Headers back on.

You will notice that the field list dropdown buttons reappear as shown below.

Pivot Table Dropdown Field List Missing

Now you can click on the dropdown button and choose the client you want to report on (as below). Similarly with the months, you now have the drop down list.

Pivot Table Dropdown Field List Missing

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

Change the name of items directly in the Pivot Table

Turn off automatic date and time grouping in Excel Pivot Tables

Conditional format a pivot table with the wizards