- Introduction
- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
Editing a Formula
You can edit formulas just as you do other cell contents, using the formula bar or working in the cell. You can select, cut, copy, paste, delete, and format cells containing formulas just as you do cells containing 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 Paste command or Paste Options button.
Edit a Formula Using the Formula Bar
- Select the cell that contains the formula you want to edit.
- Press F2 to change to Edit mode.
- If necessary, use the Home, End, and arrow keys to position the insertion point within the cell contents.
- Use any combination of Backspace and Delete to erase unwanted characters, and then type new characters as needed.
- Click the Enter button on the formula bar, or press Enter.
Copy a Formula Using AutoFill
- Select the cell that contains the formula you want to copy.
- Position the pointer (fill handle) on the lower-right corner of the selected cell.
- Drag the mouse down until the adjacent cells where you want the formula pasted are selected, and then release the mouse button.
Copy and Paste a Formula
- Select the cell that contains the formula you want to copy.
- Click the Home tab.
- Click the Copy button.
- Select one or more cells where you want to paste the formula.
- Click the Paste button or click the Paste button arrow, point to an option to display a live preview of the paste, and then click to paste the item.
- Click the Paste Options button, point to an option for the live preview, and then select the option you want.
If you don’t want to paste this selection anywhere else, press Esc to remove the marquee.