Save Space With Excel On Demand Slicers

In one of my sample files, you can select criteria for an Advanced Filter with Slicers. There are 3 Slicers at the top of the sheet, and an output range below that.  And now, AlexJ has created a compact version of that technique, with the Slicers hidden until you need them. (He’s on a mission … Continue reading “Save Space With Excel On Demand Slicers”

Excel Pop Up Selector Tool With Slicer

Slicers make it easy to select from a list of items, but they take up valuable space on your worksheet. To get the benefits of a Slicer, without the real estate cost, AlexJ made this Excel Pop Up Selector – it’s hidden until you click the small button on the sheet, and disappears again, after … Continue reading “Excel Pop Up Selector Tool With Slicer”

How to Show Excel Table Name on the Sheet

If you have an Excel workbook with lots of tables and pivot tables, it can be hard to remember what they’re named, or what source data they’re using. To help you keep track of them, AlexJ shared the User Defined Function (UDF) that he uses in his files. With this code in your file, just … Continue reading “How to Show Excel Table Name on the Sheet”

Customize Excel Context Menus

When you right-click in Excel, a pop-up menu appears, with a list of commands that you can use. The list changes, depending on where you’ve clicked, so it’s called a “Context Menu”. But, even though those pop-up menus are helpful, they might not have all the commands that you like to use. Or, the commands … Continue reading “Customize Excel Context Menus”