| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas
Is there a quick way to copy a formula down thousands of rows?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
Just Ctrl-C in the cell where the formula is then highlight the range to
which you wish to paste the formula then Ctrl-V to paste it. If my comments have helped please hit Yes. Thanks. "Diane" wrote: Is there a quick way to copy a formula down thousands of rows? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
"Diane" wrote:
Is there a quick way to copy a formula down thousands of rows? First, copy the formula (select the first cell or row, and press ctrl+C). Then enter the remaining range into the Name Box, and press ctrl+V. This presumes that you have used relative and absolute cell references in the formula as intended. Be sure to review the result. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Hybrid Mode
