Do You Use This Excel Shortcut?
February 9, 2021
Mouse wheel shortcut, send Excel comments to Word, and more, 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.
Thank you for reading the news, and you'll get the next email on February 23rd.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
There are macros on my Contextures site that let you work with Excel's old-style comments (now called Notes). The newer versions of Excel have threaded comments, so I've been adding macros for those too.
My latest macro lets you send threaded comment details to Word. It creates a new Word document, and lists each threaded comment from the active worksheet, with all its replies.
There are more macros, and a sample file to download, on the Threaded Comment Macros page on my Contextures site.
The scroll wheel on your mouse is handy for scrolling up and down on an Excel worksheet, but did you know that you can use the scroll wheel to move left and right on a worksheet too?
You can zoom in and out on the worksheet too
My mouse also has a "Start" button on the side, which opens the Windows Start menu -- accidentally, some of the time!
Here are a couple of Excel-related articles that you might find useful or interesting.
Challenge: Excel Hash is like a TV cooking challenge, but with Excel features, instead of food. Jon Acampora explains his entry, a seating chart planner, and you can see all 17 entries in this YouTube playlist. (Level - Int/Adv)
Dashboards: Mynda Treacy has a new Personal Stock Portfolio dashboard tutorial. There's a step-by-step video, and you can download the sample workbook, to follow along. Mynda offers full courses too, and they're 20% off, until this Thursday, Feb. 11th. Check out Mynda's Excel dashboard courses, and her Power BI courses.
Scottish Summit: To learn more about Microsoft 365, sign up to attend the free online Scottish Summit 2021, with sessions running on Saturday, Feb. 27th. Topics include Office 365, PowerApps, Personal Skills, and more (Level - All)
If you're working from home, I hope things are going well for you! I finally realized that people can see my office shelves, when we're in a Zoom call. Those shelves were quite a mess, but they're tidier now.
And yes, those are cookbooks in the small bookcase. I use them on Saturdays, to make our weekly meal plan, using Excel, of course!
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2021/20210209ctx.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 4, 2021 10:01 PM