Excel Format Fonts
Format Fonts
Fonts can be formatted using four different methods: color, font name, size, and additional properties.
Font Color
Black is the standard color for typography.
The “Font color” function is used to apply colors to typefaces.
How to give typefaces color
- Select cell
- Select font color
- Type text
Both text and numbers use the same font color.
The font color command saves the last color used.
Note: The method for applying custom colors to cells and fonts is the same. See the chapter on applying colors to cells for additional information.
Lets try an example, step by step:
- Select standard font color Red
- Type A1(Hello)
- Hit enter
- Select standard font color Green
- Type B1(World!)
- Hit enter
Font Name
Calibri is Excel’s default font.
For both text and numerals, the font name can be modified.
Why would Excel alter the font name?
- Make it simpler to read the data
- Enhance the presentation’s appeal
How to change the font name:
- Select a range
- Click the font name drop down menu
- Select a font
Let’s have a look at an example.
- Select A1:C4
- Click the font name drop down menu
- Select Arial
The example has both text (A1:B1) and numbers (A4:C4)
Well done! You have effectively switched the range A1:C4 is typefaces from Calibri to Arial.
Font Size
Simply select the font size drop-down menu to alter the font’s size:
Font Characteristics
You can apply different characteristics to fonts such as:
- Bold
- Italic
- Underlined
Strike though
The commands are located beneath the drop-down menu for the font name:
To apply bold, use the keyboard shortcuts CTRL + B or Command + B, or select the Bold (B) button in the Ribbon.
You can apply italic either using the keyboard shortcuts CTRL + I or Command + I, or by clicking the Italic (I) icon.
Applying underlining can be done with the keyboard shortcuts CTRL + U or Command + U, or by clicking the Underline (U) icon.
Applying strikethrough can be done by using the keyboard shortcuts CTRL + 5 or Command + Shift + X, or by clicking the Strikethrough (ab) symbol.
Chapter Summary
Four options are available for altering fonts: size, color, name, and other attributes. The spreadsheet is now more delicate and readable thanks to the altered typefaces.
