Excel: Pivot table Field List

[AnushB]

Hello All:

Our Excel field list is really complicated (confusing) and has hierarchies. And we need to define all the field names in the list, so the user knows what each fields means.

I was thinking if you can hover over the field a text comes as a comment explaining the field. Like hover over text. Is there a way to do this? Can you please state the steps and guide.

Thanks in advance!

Anush

 

[SkipVought]

Hi,

"field list"

Are you referring to what's in the PivotTable or a list that you're maintaining yourself. I never heard it referred to as a field list or heirarchal list. That word infers something else to me like multiple related tables.

You can insert Comments in your PT as Comments are native Excel features.