Formulas appear just like numbers; to help you find which cells contain formulas, Excel gives you two choices:

Display formulas in your cells (instead of numbers) Highlight the cells that contain formulas

To display formulas in a spreadsheet, press Ctrl+V (an accent grave character, which appears on the same key as the ~ sign and often appears to the left of the number 1 key near the top of a keyboard). Figure 7-16 shows what a spreadsheet looks like when formulas appear inside of cells.

Figure 7-16:

By displaying formulas

In cells, you can identify which cells display calculations.

To highlight all cells that contain formulas, follow these steps:

1. Click the Home tab.

2. Click the Find & Select icon in the Editing group.

A pull-down menu appears.

3. Click Formulas.

Excel highlights all the cells that contain formulas.

Editing a Spreadsheet

The two ways to edit a spreadsheet are

Edit the data itself, such as the labels, numbers, and formulas that make up a spreadsheet.

Edit the physical layout of the spreadsheet, such as adding or deleting rows and columns, or widening or shrinking the width or heights of rows and columns.