Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Chapter 21

Formatting worksheets

Why format worksheets?

Using traditional formatting

Formatting with styles

Understanding themes

Other formatting techniques

Copying formats

Formatting adds interest and readability to documents. If you have taken time to create a spreadsheet, you should also take the time to make sure that it is eye catching and readable.

You can format documents in Excel with any of these three methods:

• Use table styles: You can use table styles to format a table with banded rows, accents for totals, and so on.

• Use cell styles: You can use cell styles to identify titles, headings, and accent cells. The advantage of using cell styles is that you can quickly apply new themes to change the look and feel of a document.

• Use formatting ...