Instead of adjusting the font size manually, you can get Excel to make the adjustment for you. Shrink the FontĪnd here’s where today’s discovery of the font shrinking feature comes to the rescue. You can leave some columns wider, or adjust the heading font size, to fit more text in the cells. For single word headings like these, the Wrap Text settings isn’t any help. You can waste a lot of time, fiddling with the column widths, so the heading text appears. The columns are wide enough to fit the numbers, but some columns are wider, to fit the column heading. Picture, if you will, a report with headings of various lengths, like this example with month headings, shown below.
It could be caused by the shrinking Excel font feature Report Headings If you’ve ever had a worksheet where changing the font size had no effect, this might solve the mystery. Did you know about it? If not, keep reading to see how the shrinking Excel font feature works.
Well, maybe it’s not incredible, but after all these years of using Excel, I stumbled upon its shrinking font feature.
