Microsoft Office Tutorials and References

In Depth Information

**Editing a Spreadsheet**

A pull-down menu appears.

3. Click Formulas.

Excel highlights all the cells that contain formulas.

Figure 8-16:

By

displaying formulas

in cells, you

can identify

which cells

display

calculations.

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 height of rows

and columns.

Editing data in a cell

To edit data in a single cell, follow these steps:

1. Double-click the cell that contains the data you want to edit.

Excel displays a cursor in your selected cell.

2. Edit your data by using the Backspace or Delete key, or by typing new

data.

If you click a cell, Excel displays the contents of that cell in the Formula bar.

You can click and edit data directly in the Formula bar, which can be more

convenient for editing large amounts of data such as a formula.