Contextures

Contextures News 20150303

Fix Comments + more Excel tips

March 03, 2015

In this week's Excel news, you'll see how to resize comments that have grown too wide, , 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.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Resize Comments With Macro

If you add comments to a worksheet, eventually they can change size. Sometimes they become so wide that they barely fit on the screen, and other times they get smaller, so you can't read the whole comment.

If you have lots of comments to fix, you can use a macro to resize them. I've updated one of my old macros, so it does a better job of resizing the comments, and makes them easy to read again.

Read the details on my blog, and download the sample file with the macro: Resize Excel comments

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

  • Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration is now open, for this year's event.

Video: Get Sheet Name with CELL Function

To get information about cell formatting, contents and location, you can use the CELL function. For example, it can return the following details about a cell reference:

  • number format
  • Worksheet name
  • Cell alignment or column width

Click here to watch the short video that show how the CELL function works: Get Sheet Name with CELL Function

Strapped In

After I finished university, many years ago, my first job was at a driver education centre. I learned many safety lessons, and saw a few too many videos about the dangers of not using your seat belt, and having loose objects in the car, in case of a collision.

Usually, if I'm going to visit a client, I put my laptop bag in the trunk, but in this extremely cold weather I give it a treat, and let it stay inside the car. It has to be strapped in though -- for its safety, and mine. Fortunately, it's much easier to handle than a squirmy toddler!

weekly photo

Featured Excel Product

This week, I'm pleased to recommend Excel University -- an online Excel training course designed specifically for accountants. I went through several of the modules, and was very impressed by the content, delivery, and course structure.

The course focuses specifically on the Excel features, functions, and techniques that are most useful to accounting professionals. The training is practical and the concepts are easily applied to your workbooks. You'll learn how to get your Excel tasks done more quickly, how to save time, and how to automate your recurring-use workbooks.

Click the link to learn more about Excel University.

That's it for this week! If you have any comments or questions, send me an email.

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

 

Last updated: January 26, 2020 4:18 PM