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. It would be even better to switch to a slightly different font that would support setting fontWeight below 400 e.g.Well, maybe it’s not incredible, but after all these years of using Excel, I stumbled upon its shrinking font feature. That's why I believe that, in conjunction with the above two suggested changes, With my suggested settings, 13pt Consolas I think it is appears a bit boldish.Ĭhanging the value "editor.fontWeight": "normal" to anything below 400 doesn't make a difference. Then the visible lines area becomes on par with the other editors: 71 lines.Īlso, (while using the default Dark+ themeĪnd the default setting "editor.fontFamily": "Consolas, 'Courier New', monospace")
Use 0 to compute the lineHeight from the fontSize. "editor.lineHeight": 0 // Controls the line height. "editor.fontSize": 14, // Controls the font size in pixels.
0 kommentar(er)
