Microsoft Office Inside Out (Office 2021 and Microsoft 365)

Chapter 12

Worksheet formatting and management

Formatting text entries

Formatting values

Adding comments to notes and 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 the data into an Excel sheet is only the first step, and you will certainly need to include labels (text), values, formulas, and functions in your worksheet. Formatting entries in cells so that certain information is highlighted or certain cells are emphasized can also be important. Creating a sheet with visual appeal and a sensible layout can ...