Microsoft Office 2019 Inside Out, First Edition

Chapter 12Worksheet formatting and management

Formatting text entries

Formatting values

Adding comments to cells

Using themes

Formatting cells using borders and color

Using cell styles and the Format Painter

Using conditional formatting

Manipulating cells and cell content

Working with columns and rows

Working with worksheets

Naming ranges

Adding images and graphics to worksheets

Entering you data into an Excel sheet—all those labels (text), values, formulas, and functions—is only one aspect of creating a sheet. Formatting entries in cells so that certain information is highlighted or certain cells are emphasized can also be important. Creating a sheet that has visual appeal as well as a sensible layout can help to make all those columns and rows ...