en uk

Editing a Formula Microsoft Excel 2007

    After you create a formula, you can always edit it later. You can edit a formula in two places:

    In the Formula bar In the cell itself

    To edit a formula in the Formula bar, follow these steps:

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

    Excel displays the formula in the Formula bar.

    2. Click in the Formula bar and edit your formula using the Backspace and Delete keys.

    To edit a formula in the cell itself, follow these steps:

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

    Excel displays a cursor in the cell you selected.

    2. Edit your formula using the Backspace and Delete keys.

    Because formulas display their calculations in a cell, it can be hard to tell the difference between cells that contain numbers and cells that contain formu­las. To make formulas visible, press Ctrl+V (an accent grave character, which appears on the same key as the ~ symbol).




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.