Microsoft Office Professional 2010 Step by Step eBook

You can have the Error Checking tool ignore formulas that don’t use every cell in a region (such as a row or column). Tip If you ...

304 Chapter 10 Perform Calculations on Data In this exercise, you’ll use the formula-auditing capabilities in Excel to identify ...

The auditing arrow indicates that the cells in the range C3:C7 provide the value for the formula in cell D8. In the Formula Aud ...

306 Chapter 10 Perform Calculations on Data Click Next. Excel displays a message box indicating that there are no more errors ...

In the Watch Window, click the watch in the list. Click Delete Watch. The watch disappears. On the Formulas tab, in the Formu ...

Chapter at a Glance Format cells, page 310 Define styles, page 316 Apply workbook themes and Excel table styles, page 320 Make n ...

309 11 Change Workbook Appearance In this chapter, you will learn how to ✔ Format cells. ✔ Define styles. ✔ Apply workbook theme ...

310 Chapter 11 Change Workbook Appearance In this chapter, you’ll learn how to change the appearance of data, apply existing for ...

Most of the tools you need to change a cell’s format can be found on the Home tab. You can apply the formatting represented on a ...

312 Chapter 11 Change Workbook Appearance Another way you can make a cell stand apart from its neighbors is to add a border arou ...

One task you can’t perform by using the tools on the Home tab is to change the stan- dard font for a workbook, which is used in ...

314 Chapter 11 Change Workbook Appearance Click cell B5, hold down the Ctrl key, and click cell C4 to select the non-contiguous ...

You can distinguish header cells from other cells by applying a background color. Troubleshooting The appearance of buttons and ...

316 Chapter 11 Change Workbook Appearance Defining Styles. As you work with Excel, you will probably develop preferred formats f ...

A custom style can include number, alignment, font, and border formatting. After you set the characteristics of your new style, ...

318 Chapter 11 Change Workbook Appearance The elements of the current style are described in the Cell Style dialog box. In the ...

In the Horizontal list, click Center. Click the Font tab. In the Font style list, click Italic. The text in the Preview pane a ...

320 Chapter 11 Change Workbook Appearance On the Home tab, in the Styles group, click Cell Styles. The Cell Styles gallery ope ...

You can choose from among dozens of preformatted visual themes. When you want to format a workbook element, Excel displays color ...

322 Chapter 11 Change Workbook Appearance You can change a theme’s colors, fonts, and graphic effects by displaying the Page Lay ...