Easy Excel Tweaks
April 9, 2019
Make easy changes to the Excel status bar, and macros too, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Do you customize the Excel status bar, or leave it with the default settings? Num Lock used to be on the Status Bar by default (2003?), but now it's not, so I customized by Status Bar, to show that setting, and a few others. This Microsoft article shows the list of options, and which ones are selected by default.
It's easy to add or remove the Status Bar optional items:
I also turned on the Numerical Count option, to see how many numbers are selected. The Count option counts all kinds of data, including text.
There are lots of sample macros on my website and blogs, and there are instructions on how to copy them into your workbook, if you aren't sure how to do that.
To help you make minor changes to those macros, I've put notes on my pivot table blog. For example, if a macro refers to the first pivot table on the active sheet:
Set pt = ActiveSheet.PivotTables(1)
You could change that to a pivot table name instead:
Set pt = ActiveSheet.PivotTables("SalesPivot")
Free Webinar: If you want to learn more about Excel macros, Jon Acampora is running free webinars this week that shows you how to get started with Excel macros, and save time on some of your tasks. There's a full course too - VBA Pro - if you decide to learn even more about Excel programming.
Here are a couple of Excel articles that you might find useful or interesting.
Filter Challenge - Bill Jelen couldn't find a quick way to filter a list of account codes (video) that start with numbers from 6 to 9. How would you solve it? Jonathan put a good solution in the video comments. (Level - Intermediate)
Humour - This comedy video is a parody of gamers, and definitely won't appeal to everyone (language warning). Instead of playing a game, the actor works in Excel, and rants about the latest updates. Too bad BallmerCon isn't a real event though - it would be awesome! (Level - All)
There's still a bit of snow in our yard, but we can make it look like spring indoors. My mom is in the hospital, and she's received several lovely flowering plants, to brighten up her windowsill. I think the pink flower is a hydrangea, and the yellow one is a Begonia - but I've been wrong before!
P. S. We're spending lots of time with Mom, so there could be delays in my email replies. Thanks for your patience!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2019/20190409ctx.html
I'll also post any article updates or corrections there.
That's it for this week! If you have any comments or questions, send me an email.
Last updated: April 8, 2019 10:01 AM