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.
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
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
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:
Click here to watch the short video that show how the CELL function works: Get Sheet Name with CELL Function
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!
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.
Last updated: January 26, 2020 4:18 PM