CHAPTER 3

Formatting Excel Ranges

image

Microsoft Excel 2016 offers many commands and options for formatting ranges, including the font, text color, text alignment, background color, number format, column width, row height, and more.

Change the Font and Font Size

Apply Font Effects

Change the Font Color

Align Text Within a Cell

Center Text Across Multiple Columns

Rotate Text Within a Cell

Add a Background Color to a Range

Apply a Number Format

Change the Number of Decimal Places Displayed

Apply an AutoFormat to a Range

Apply a Conditional Format to a Range

Apply a Style to a Range

Change the Column Width

Change the Row Height

Wrap Text Within a Cell ...

Get Teach Yourself VISUALLY Excel 2016 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial