
Tips.Net > ExcelTips Home > Formatting > Cell Formatting > Changing Font Sizes
Summary: Did you know that Excel can display any font size from 1 to 409 points in size? What’s a point, you ask? This tip covers all the details so you can make your data just the size you need. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
Excel specifies the size of fonts in points, a unit of measurement typically used in typesetting. A point is equal to approximately 1/72 of an inch. To change the size of a font used in a selected cell or for information selected within a cell, you use the toolbar. Just to the left of the text-attribute tools (and to the right of the font tool) is the point size tool. If you click on the arrow to the right of this field, you are presented with a drop-down list of point sizes you can specify for the current font.
To pick a point size, simply scroll through the list and choose the one you want. Click your mouse on the point size, and your text is updated. You are not limited to choosing a point size from those in the list, however. Excel allows you to specify any font size between 1 and 409 points. (This depends, of course, on the capabilities of your printer.) You can use the keyboard to enter any point size (or fractional point size) desired.
Tip #2128 applies to Microsoft Excel versions: 97 2000 2002 2003
Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.
Check out ExcelTips: Times and Dates today!
PivotTables don't need to be scary or mysterious. Use this powerful tool to analyze your data in ways you didn't know were possible. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site