My Excel® 2013

4. Formatting Worksheet Data

In this chapter, you explore the various types of formatting you can apply to both your cells and your data. The topics in this chapter include

→ Changing the font, font size, and font style

→ Changing column width and row height

→ Changing the background and text color

→ Modifying data alignment and cell orientation

→ Changing borders

→ Clearing and copying formatting

→ Hiding rows, columns, and worksheets

→ Using Format as Table

→ Creating and applying a formatting style

→ Using conditional formatting

The primary purpose of Excel’s formatting tools is to make your worksheet more readable. For example, you can change ...