Contextures

Contextures News 20200421

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.

Row Height Quick Tip

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:

  • Drag down on the row divider
  • OR, right-click the row button, click Row Height, and make a small change

In this screen shot, I adjusted the height of row 3, but NOT row 4

manually adjust row height

Next, reduce the font size. In this screen shot the font in B3:C4 was changed from 20 to 12.

  • The row height in the manually adjusted row (3) did not change
  • The height for the non-adjusted row (4) was reduced, to autofit the smaller font

manually adjusted row does not autofit

There are more Worksheet Tips on my Contextures website.

Challenge Solutions

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:

  • In the Odd/Even formulas: SUM, FILTER, MOD, SUMPRODUCT, INT, SUMIF
  • In the helper columns: IF, ISODD, ISEVEN, MOD
  • NOTE: There's one array-entered formula, on the Solutions03 sheet, but if your version of Excel has Dynamic Array formulas, you won't need to do that -- just press Enter.

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.

quantities for odd and even weeks

Excel Articles

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?

Also see: My Excel Products || Previous Issues

Face Masks

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.

weekly photo

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.

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.

contextures newsletter info

 

Related Links

Worksheet Tips

How to Sum Examples

 

 

Get weekly Excel tips from Debra

 

pivot power free

 

 

 

 

 

Last updated: April 27, 2020 12:08 PM