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

50 Things You Can Do With Excel Pivot Tables Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, "pivot"/change the report layout with the ease of dr...
Format Error Values in a Pivot Table Whenever you do a calculation in an Excel Pivot Table you may get an error value like a #DIV/0! This looks ugly when you are presenting important information.  Luckily you can override this with a custom value or text. To activate this you need to Right Click in any Value i...
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 Grand Totals to a Pivot Table When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total. How about if you want to remove this Grand Total or show it only for a row or column? Well you have that flexibility and this is how... DOWNLOAD EXCEL...