Do you ever get in a situation where your Pivot Table Field List has over 20 fields and you spend heaps of time trying to locate one within the Field List?

Well you can save time by sorting the Pivot Table Field List in alphabetical order!

To do this you need to Right Click anywhere within your Piovot Table and choose PivotTable Options > Display > Sort A to Z

See how this is done below…

DOWNLOAD WORKBOOK

Sort Field List from A to Z

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Protected: What Else Can Excel Pivot Tables Do?  The Pivot Table Webinar Replay & Xtreme Pivot Table Online Course is Closing its Doors in... Click Here To Watch The Webinar Replay BONUS VIDEO:   Consolidate Multiple Sheets & Excel Tables In this training you are going to learn the following:C...
Insert Blank Rows In a Pivot Table Pivot Table reports are shown in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month & Customer), then the Pivot Table report can look very clunky... There is a cool little trick that most Excel users do not know about th...
Add Custom Symbols With Your Numbers in Excel A cool feature within Excel is the ability to format a cell's value by pressing CTRL + 1 on any cell. This brings up the Format Cells dialogue box and under the Custom category you can customize the Type to whatever you like and even insert symbols! There are four formattin...
Pivot Table Number Formatting You can easily format your Pivot Table values simply by Right Clicking on a value and choosing Number Format.  Then you can choose from the many different formats, like Number, Currency, Percentage or Custom. DOWNLOAD EXCEL WORKBOOK   STEP 1: Right click in the Pi...