3 Amazing Tips For The Pivot Table Fields List In Excel

In this video, I share three tips to use when working with the Pivot Table Fields list. This is the task pane that appears to the right when you click into a pivot table.

0:00 Tip #1: Change the Layout of the Field List
03:21 Tip #2: Undock and Move the Fields List
04:56 Tip #3. Hide & Unhide the Fields List

Related Videos:

#MsExcel #ExcelCampus

[hc]

For every one Excel video you uploaded, you saved Excel noobs like me. Thank you for your content!

[charlessotis]

Jon, You've completely blown me away. I can hardly believe how in depth Excel is, coupled with Pivot Tables, Power Query, etc. You've made me aware of creating reports that I never thought possible. Thank you. You are a Natural Teacher.

[PaulEBrownbill]

Excellent video I have just found. I am always losing/closing my field list pane, so good tips.

[omprakashojha]

Great lesson teaching how to play with Pivot table. Thank you!

[wayneedmondson]

Hi Jon. Some great Pivot Table Fields List tips there! Thanks for sharing :)) Thumbs up!!

[pipo]

Good tutorial to start the morning. Great workout video.

[floatpilot]

Great Video as usual Jon. Thank you for sharing your expertise in this field.

[MrSantee]

Jon, you are simply great.!!!
I have simple query how to fill columns with increasing months without increasing years with drag options....exp col A Jan'21, col B

[sudhasomasundaram]

Is there a way to make the floatable field list now available dock to the right? If you could please share, I would appreciate it.

[maximumaverage]

Is there any way to customize the order of the tables? For example moving calendar on top of budget in your example. I’d like to rearrange the tables in my model to flow more logically

[defryebank]

Is there a way to change the default field list view?