Formatting Cells in Excel
Learn how to format fonts, apply colors, borders, alignment, cell styles, and enhance worksheet presentation.
Video
Watch the lesson video, then complete the reading and challenge.
Lesson Notes
Read through the key concepts before you try the challenge.
Changing Font Type
You can change the font type from the Font group on the Home tab.
Changing Font Size
You can choose a font size from the dropdown or use the Increase and Decrease Font Size buttons.
Bold, Italic, and Underline
Use Bold, Italic, and Underline to emphasize important text.
Changing Font Color
Font color can be changed using Theme Colors or Standard Colors.
Applying Fill Color
Fill color changes the background color of selected cells.
Applying Borders
Borders help define data tables and improve readability.
Using Cell Styles
Excel provides built-in cell styles for quick formatting.
Horizontal Alignment
Horizontal alignment positions text left, center, or right within a cell.
Vertical Alignment
Vertical alignment positions text at the top, middle, or bottom of a cell.
Knowledge Check
Which formatting option applies color to the background of a cell?
Practice File
Download this file and follow along with the lesson.
Challenge
Apply what you've learned in this lesson.
Complete the following tasks:
- Change the font type and size of the worksheet title.
- Apply Bold formatting to the header row.
- Change the font color of the title.
- Apply fill color to the header row.
- Add borders to the entire data table.
- Center-align column headers horizontally.
- Apply Middle Align vertically.
- Apply a built-in cell style.
