Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

Fix Comments + more Excel tips

Excel Weekly News from Contextures March 3, 2015

In this week's Excel news, you'll see how to resize comments that have grown too wide, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -

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!

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.

As an exclusive offer to Contextures Newsletter subscribers, you can save 20% with this discount code: contextures2015 (code expires March 31, 2015)

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. And remember, until March 31, 2015, you can save 20% with this discount code: contextures2015



Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.


Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright ©2015
All rights reserved.