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”
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”
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 their using. To help you keep track of them, AlexJ is sharing the User Defined Function (UDF) that he uses in his files. With this code in your file, … Continue reading “How to Show Excel Table Name on the Sheet”
The Internet says that 15 years ago this month, I started my Contextures Excel Tips website. And since the Internet is never wrong, it must be true! The dates are a little hazy, because that was a loooong time ago, but it was definitely 2000 that I got the website up and running. This week, … Continue reading “15 Years of Excel Tips”
In this week’s roundup, see the results from the last roundup’s pivot table survey, build a better dashboard, see some new chart types, and much more. We’re almost at the end of our summer schedule now, and the next roundup will be published on Monday, Sept 14th.
It can be a real pain to find a specific sheet, if an Excel file has lots of worksheets. If I’m making a big file for a client, I’ll often colour groups of sheet tabs, to they’re easier to find. Then, if you want the admin lists sheets, look for the red group.
This week, see how to add a table of contents in a workbook, customize the right-click menu, pick a random winner, and many more tips. If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
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”
Last week, AlexJ sent me a tip for making better worksheet buttons, and I’ll be using it from now on, instead of my old method. I’ll show you both button types, and maybe you’ll switch too. Big Bold Buttons If I’m making a workbook with several sheets, I usually add a menu sheet at the … Continue reading “Save Space With Compact Worksheet Buttons”
Did you ever print and distribute pivot table reports in Excel, only to discover – too late – that they weren’t showing the correct information? To help save you from wasted time and paper, and possible embarrassment, AlexJ is sharing his Report Diagnostic Display technique today. You might remember some of his other handy tips, … Continue reading “Excel Report Diagnostic Display”