Editing and Copying a Formula

graphics/microsoft45.gif

You can edit formulas just as you do other cell contents: use the formula bar or work in the cell. When you select a cell to edit a formula, the status bar displays Edit Mode, indicating that you can edit the contents of a cell . You can select, cut, copy, paste, delete, and format cells that contain formulas, just as you do cells that contain labels or values. Using AutoFill, you can quickly copy formulas to adjacent cells . If you need to copy formulas to different parts of a worksheet, use the Office Clipboard.

Edit a Formula Using the Formula Bar

graphics/one_icon.jpg

Select the cell that contains the formula you want to edit.

graphics/two_icon.jpg

Press the F2 key to change to Edit Mode.

graphics/three_icon.jpg

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

graphics/four_icon.jpg

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

graphics/five_icon.jpg

Click the Enter button on the formula bar, or press Enter.

graphics/08inf02.jpg

Copy a Formula Using AutoFill

graphics/one_icon.jpg

Select the cell that contains the formula you want to copy.

graphics/two_icon.jpg

Point to the fill handle in the lower-right corner of the selected cell. (The pointer changes to a black plus sign.)

graphics/three_icon.jpg

Drag to select the adjacent cells where you want to paste the formula, and then release the mouse button.

graphics/four_icon.jpg

Click the AutoFill Options button, and then click an option that specifies how you want to fill in the data.

graphics/08inf03.jpg



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

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