How to Insert & Copy a Formula in Excel 2007
Excel 2007 represents another step in the development of Microsoft's popular spreadsheet software. The ability to use powerful formulas in spreadsheets has been one of the features that have made Excel a favorite of its users. Excel 2007 offers a new toolbar for users called a ribbon with a Formulas tab, and a convenient fill-handle tool that makes it easy to insert and copy formulas.
Other People Are Reading
Instructions
-
-
1
Open Excel and the worksheet in question. Position the cursor in the cell in which you wish to insert the formula.
-
2
Click on the Formulas tab at the top of the Excel window. Choose the proper category for the formula you will be using, and then select the formula that you wish to insert from the list that appears.
-
-
3
Enter the cell references as prompted in the Function Arguments dialog box that appears.
-
4
Copy any of your existing formulas by first selecting the cell that contains the formula you wish to copy.
-
5
Click on the Home tab at the top of the Excel window, and select the Copy icon. Select Paste if you would like to paste both the formula and the formatting, and click on Paste Special if you want to paste the formula only.
-
6
Copy your formula into adjacent cells by using the Excel fill handle. This is a small black square that is located at the lower-right corner of the cell or group of cells you have selected. Move your mouse over it, and when the pointer turns to a black cross, left-click and drag the fill handle over the range of cells into which you wish to copy the formula.
-
1
