Blog ~ Site Name

Blog Home

Excel Video 282 Sorting Pivot Table Data

posted by Nate Moore on August 8th, 2012 at 9:43 PM

0 Comments added to this post

Sorting Pivot Table data, as we’ll do in Excel Video 282, is much easier than sorting regular data in Excel. You’re probably aware that if you sort regular data in Excel you have to be very careful to select the entire range of data to sort in order to avoid scrambling your data. Pivot Tables are easier. Excel recognizes Pivot Tables as one unit and you only have to click on one cell to sort data.

Notice that Excel sorts based on the cell I choose. I can sort row labels, column labels, grand totals, and individual columns either in ascending (A-Z) or descending (Z-A) order. It’s very easy to get to the largest and smallest amounts in any column you’d like. While sorting A-Z and Z-A is fast and easy, there are times when you may want to sort in a different order, like physician seniority or the chronological order in which locations were opened. You can manually sort data in Pivot Tables and I’ll show you how in the next Excel Video. Thanks for watching.



No Comments Here. Add yours below!

Add a comment

Email: (Will not be displayed)
  Verify the contents of this image in the box provided above to successfully submit this form
Verify Post:
Input the text from the image above to verify this post

Blog Home

Buy the Book

Get Your Data

Invite Nate to Speak