The incredible shrinking font

BY J. CARLTON COLLINS

Q: In Excel 2010, the font tool allows me to select from a font size ranging from 8 points to 72 points, but I’m sure that I’ve seen others use a smaller font. Can you tell me how this is done?

A: Even though Excel’s font size tool offers font sizes ranging from 8 to 72 points, you can type in point sizes ranging from 1 to 409. For example, in the screen image below, I have entered a font size of 3.5 points, and Excel 2010, 2007, and 2003 will accept this smaller font.

 

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.