Excel Row Height Quick Tip
April 21, 2020
Formula challenge solutions, stop row height AutoFit, 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.
Quick question - Have you had any trouble following the newsletter links, or seen a Captcha on my site? Please let me know if you have!
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
Usually, if you reduce the font size in worksheet cells, Excel automatically reduces the row height, with its AutoFit feature.
If there are rows that you don't want the AutoFit feature to adjust, here's how to stop it:
Make a small change to the row height:
In this screen shot, I adjusted the height of row 3, but NOT row 4
Next, reduce the font size. In this screen shot the font in B3:C4 was changed from 20 to 12.
There are more Worksheet Tips on my Contextures website.
Thanks for sending your solutions to last week's Excel formula challenge. The goal was to create formulas to total the quantities for odd and even weeks.
To see the solutions, download my updated sample file with the challenge data and your solutions.
It's always interesting to see how many ways we can solve a problem in Excel! Here are some of the functions that were used:
A few people used helper columns, and you can see those on the Solutions04 sheet, with colour coding to match the formulas.
There are more How to Sum examples on my Contextures website.
Here are a few Excel-related articles that you might find useful or interesting.
Functions: In this video, Mynda Treacy shows clear examples for the new Excel LET function (currently in beta), with a handy troubleshooting tip at the end. Define names in a formula, assign a value to each name, then use those names in the calculation. Will this make formulas easier to understand? (Level-Int/Adv)
Speed: See what Microsoft has done to improve Excel's performance recently, and settings you can change on your computer. (Level All)
Excel Humour: See what people said about Excel recently. Is it an Excel sin to use merged cells?
Are you staying safe? We occasionally go out for essential errands, so I've sewn a few cloth face masks. The latest one is from an “origami” style pattern, modified slightly, with side tabs for the ties. Mr. Owl liked it, and my husband says it's "not as uncomfortable as other styles", which is high praise for a face mask! Now we just need a way to keep our glasses from steaming up.
NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2020/20200421ctx.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.
Last updated: April 27, 2020 12:08 PM