Simple PivotTable filters let you limit the table display to a part of the available data. They have a place in PivotTables, especially for semi-permanent filters that you want to apply broadly. Instead of filtering the original data feed or list, the PivotTable can use a large list which is narrowed down to what you […]
There’s been a whopping big security hole in Microsoft Office for the last 17 years, via the old Equation Editor and a less than vigilant Microsoft. We have details of the problem, how to fix it and why there’s more to come …. In the November 2017 patches there are some that are innocently labelled […]
You’re not locked into the PivotTable sorting options provided by Microsoft. Excel lets you arrange a PivotTable into any order you like. Right-click on a PivotTable column and choose Sort | More Sort Options | Manual. How to Drag and Sort It’s not obvious how to select an item (row or column) to move it. […]
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 […]
