Excel FormattingLesson 21Free preview

Excel Formatting

This lesson is part of Excel · All levels

Summary

Formatting changes the data's appearance to be easy to read without changing the value stored within the cell. The basic command group is in the Home tab: font, alignment, and cell style. Features like Merge & Cells combine cells into one, while Wrap Text makes long text appear neatly in several rows.

Key points

The formatting just changes the look, the value and the formula stay the same
The basic format command is in the Home tab: Font, Alignment, Number
Merge & Cells merges the cells and stores the contents in the left-upper cell
Wrap Text wrapped long text into multiple rows in one cell

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.