Editing Cell Contents

Editing Cell Contents

graphics/microsoft05.gif

Even if you plan ahead, you can count on having to make changes on a worksheet. Sometimes it's because you want to correct an error. Other times it's because you want to see how your worksheet results would be affected by different conditions, such as higher sales, fewer units produced, or other variables . You can edit data just as easily as you enter it, using the formula bar or directly editing the active cell.

Edit Cell Contents

graphics/one_icon.jpg Double-click the cell you want to edit. The insertion point appears in the cell.

The status bar now displays Edit instead of Ready.

graphics/tow_icon.jpg

If necessary, use the Home, End, and arrow keys to position the insertion point within the cell contents.

graphics/three_icon.jpg

Use any combination of the Backspace and Delete keys to erase unwanted characters, and then type new characters as needed.

graphics/foure_icon.jpg

Click the Enter button on the formula bar to accept the edit, or click the Esc button to cancel the edit.

graphics/02inf12.jpg

graphics/02inf13.jpg

Did You Know?

You can change editing options . Click the Tools menu, click Options, click the Edit tab, change the editing options you want, and then click OK.

You can edit cell contents using the formula bar . Click the cell you want to edit, click to place the insertion point on the formula bar, and then edit the cell contents.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net