Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

When you click on a text-based column in a PivotTable and select Sort from the Data tab, the resulting dialog box (pictured at the top of the next column) provides additional sort options for sorting ...