Sometimes you want to sort a list or PivotTable in a special way that doesn’t fit the usual ‘A to Z’ or number order. The most common need for this are days of the week or months in a year. Neither of those orders make sense to a literal computer. Excel has a Custom sort […]
You still want to explore more Excel PivotTable sorting, there are some additional options like Click More options button on the Sort dialog box. The More Sort Options dialog box appears for your Sorting list of the Pivot Table. Let’s see what these additional features can do for you: As the name suggests ‘AutoSort’ automatically […]
Excel allows you to sort a PivotTable in alphabetical order or from largest to smallest values. They are similar to the standard Excel sorting options but worth looking at separately because there are automatic sorts, custom sortings and a manual sorting option. Quick PivotTable Sort Sort the PivotTable by right-click on any cell in a […]
Next Wednesday, Australia gets the results of their Same Sex Marriage survey with the details available to everyone with Excel. Here’s how to get the survey results, prepare for the announcement and when it’ll happen. We know most people won’t be interested in this singular Aussie exercise in democracy (don’t get us started …) It’s […]
By default, PivotTable provides custom name such as “Sum of Amounts” or Count of Numbers” etc when you add a field to the table. You may not be always happy to use these default custom names for your PivotTable, so feel free to modify the headings to something you like. Click on the column heading […]
