Module 2
4 min
Format Colors & Fonts
Make your spreadsheets look professional with colors and fonts
Format Colors & Fonts
Make your spreadsheet look good and easy to read.
Where Are the Tools?
Everything is in the Home tab.
Change Font
Step 1: Select cells
Step 2: Use these options:
| What | Where | Shortcut |
|---|---|---|
| Font type | Dropdown (Calibri) | - |
| Font size | Number (11) | - |
| Bold | B button | Ctrl + B |
| Italic | I button | Ctrl + I |
| Underline | U button | Ctrl + U |
5 rows
Change Colors
Text Color
- Select cells
- Click A with colored line
- Pick color
Background Color
- Select cells
- Click paint bucket icon
- Pick color
Make a Nice Header
- Select header row
- Bold it (Ctrl + B)
- Add background color (dark blue)
- Change text color (white)
Quick Tips
| Use This Color | For This |
|---|---|
| Dark blue/gray | Headers |
| Yellow | Important data |
| Light green | Good/positive |
| Light red | Bad/negative |
4 rows
Summary
- Home tab has all formatting tools
- Bold: Ctrl + B
- Text color: A with colored line
- Background: Paint bucket icon
- Keep it simple - don't use too many colors!