Excel 2016 In Depth

21. Formatting Worksheets

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 2016 with any of these three methods:

Use tables 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 ...