Excel: Copying the Exact Formula from the Cell Above

ID: Q26449

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY

In Microsoft Excel, when you choose Fill Down from the Edit menu, formulas containing relative references update based on the new cells that the formula appears in. For example, if cell B1 contains the formula =A1*10, cell B2 will contain the formula =A2*10 if Fill Down is used to copy the formula into that cell.

To copy the exact formula from the cell above, do the following:

Select the cell that that the formula is to appear in.

Press COMMAND+'(apostrophe). This key sequence copies the formula from the cell directly above and pastes it into the formula bar.

Press RETURN or ENTER to enter the formula in the active cell.

Additional query words: 1.x 2.20 3.00 4.00


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 11, 1999