Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying formulas to new rows, 20000 times
How can I automatically paste a formula into existing rows. I need to add
formulas to 20,000 rows. Help! |
#2
|
|||
|
|||
Put it in the first cell, copy the cell, select the next 19,999 and use Edit
/ Paste. What is your formula, where is it, and where do you want it, and what do you want it to be when you copy it - Give us an example. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Box" wrote in message ... How can I automatically paste a formula into existing rows. I need to add formulas to 20,000 rows. Help! |
#3
|
|||
|
|||
Copy the cell with the formula
select the range A quick way: edit|goto type: A1:A20000 (or whatever the range is) Hit enter Edit|Paste Box wrote: How can I automatically paste a formula into existing rows. I need to add formulas to 20,000 rows. Help! -- Dave Peterson |
#4
|
|||
|
|||
Thanks, didn't realize it would copy into all cells selected.
"Dave Peterson" wrote: Copy the cell with the formula select the range A quick way: edit|goto type: A1:A20000 (or whatever the range is) Hit enter Edit|Paste Box wrote: How can I automatically paste a formula into existing rows. I need to add formulas to 20,000 rows. Help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying rows where a result cell has a certain value or higher | Excel Discussion (Misc queries) | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Copying Formulas | Excel Worksheet Functions | |||
Copying whole rows based upon one criteria | Excel Discussion (Misc queries) | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |