Rarely do you choose a single Slicer button. More likely you’ll want to select multiple filters or buttons, here’s the various ways to do that. You can press the filter icon next to Beverages and then select multiple items if you want to see both. Just like other parts of Windows, hold down the Ctrl […]
From Excel 2010, Microsoft added Slicers to Excel’s PivotTables. From the hype, Slicers sound like some complex Excel feature but they’re really a more useable, friendly and showy way to do something already in Excel – Filtering. For me it’s more of a visual filter and a collaborative tool that can help you figure out […]
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. […]
