Contextures

Contextures News 2021-02-09

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.

Comments Macro

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.

threaded comment in Excel

Mouse Wheel

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?

  • If your mouse has a "tiltable" scroll wheel, push it to the left or right, to scroll in that direction
  • Or, press Ctrl + Shift, then scroll the wheel up or down, to move left or right on the worksheet

You can zoom in and out on the worksheet too

  • Press Ctrl while you scroll the mouse wheel.

My mouse also has a "Start" button on the side, which opens the Windows Start menu -- accidentally, some of the time!

mouse with scroll wheel

Excel Articles

Here are a couple of Excel-related articles that you might find useful or interesting.

Functions - Tom, at The Analyst Cave, is excited about Excel's new LAMBDA function. But Mike James, at I Programmer blog, disagrees, saying "Spreadsheets are dangerous enough" (Level - Int/Adv)

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)

Also see: My Excel Products || Previous Issues

Office Shelves

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!

weekly photo

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.

Debra Dalgleish
dsd @contextures.com
ctxdebra @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.

contextures newsletter info

 

Last updated: April 4, 2021 10:01 PM