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 - firstname.lastname@example.org
- Resize Comments With Macro
- More Excel Tips
- Excel Announcements
- Video: Get Sheet Name with CELL Function
- Weekly Photo: Strapped In
- Featured Excel Product
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:
- To help you get started with Excel on the iPad, Microsoft Press explains how to store and retrieve data. It's a free chapter from their book, Microsoft Office for iPad Step by Step.
- Ken Puls uses Power Query to combine the data from multiple workbooks, into one table. All the files have a similar structure.
- NPR's Planet Money podcast covers the history of spreadsheets, and the topic was inspired by Stephen Levy's 1984 article, A Spreadsheet Way of Knowledge. There is an explicit language warning on the podcast, so listen at your own risk! (I didn't hear anything shocking.)
- If you're using Excel on an Android tablet, you can download the free Excel keyboard, with a number pad, that was recently released by Microsoft's Garage.
- Robert Mundigl shows how to create word clouds in Excel, an update from his earlier method. Download his sample file, and try it out. And remember, don't look a gift horse (or word cloud) in the mouth!
- When you don't have fancy project management software, Sumit Bansal shows how to build a Gantt chart in Excel.
- Gašper Kamenšek uses the TEXT function, with Locale codes, to show the day and month names in a variety of languages.
- Spreadsheets are already fun, but Tableau wants to make them even more exciting, with its newest smartphone app, Elastic. A short video shows how Elastic works, but there are no details on the expected release date or pricing.
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
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
See more recommended Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.