CHAPTER 7

Formatting Workbooks

image

Excel offers several settings that enable you to control the look of a workbook, including the workbook colors, fonts, and special effects. You can also apply a workbook theme and add a header and footer to a workbook.

Modify the Workbook Colors

Set the Workbook Fonts

Choose Workbook Effects

Apply a Workbook Theme

Add a Workbook Header

Add a Workbook Footer

Modify the Workbook Colors

You can give your workbook a new look by selecting a different color scheme. Each color scheme affects a dozen workbook elements, including the workbook’s text colors, background colors, border colors, chart colors, and more. Excel ...

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.