| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy a formula down a set number of times
I'm trying to figure out how I can copy down a formula in a column a set
number of times. I have data where I need to have a formula copied into about 1000 rows. I do this by dragging the formula down 999 rows, and this is becoming tedious. Is there an easy way to tell excel to copy down the formula 999 times, after writing it in, say, cell A2? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| Display the max, then the next down, then the next down, etc. | Excel Discussion (Misc queries) | |||
| how to copy just the number that a formula creates | Excel Worksheet Functions | |||
| Number of times a number is shown | Excel Worksheet Functions | |||
| How do you copy a formula without incrementing some constants? | Excel Worksheet Functions | |||
Threaded Mode
