Contextures

Contextures News 20190409

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.

Status Bar Options

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:

  • Right-click on the Status Bar
  • Click on an option, to turn it on or off.

status bar options

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.

You can add your own messages to the Status Bar too, such as a progress message for macros, or a function that does subtraction for two selected ranges.

Macro Tweaks

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.

Excel Articles

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)

Also see: My Excel Products || Excel Events || Previous Issues || Weekly Humour

Spring Indoors

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!

weekly photo

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.

Debra Dalgleish
dsdalg@ gmail.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: April 8, 2019 10:01 AM