| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy same cell formula in many rows...
PERFECT!!!
Thanks "pinmaster" wrote: Hi, Try this: Enter the formula in the first cell then go to the name box (left of the formula bar)and enter the range you want the formula copied to.......e.g. A1:A2000, then hit the F2 key, next hold down the Ctrl key and hit Enter. HTH Jean-Guy "Dennis1188" wrote: I would like to copy a cell formula by left clicking the bottom right corner , hold and drag down 2000 rows. Excel quickly counts past 2000 rows and I go up and down till I get it right. Is there a way to left click, hold and maybe enter the row number?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy same cell formula in many rows... | Excel Discussion (Misc queries) | |||
| copy formula every x rows | Excel Worksheet Functions | |||
| COPY FORMULA EVERY TWO ROWS | Excel Discussion (Misc queries) | |||
| Copy formula with skipping rows | Excel Worksheet Functions | |||
| I want to copy a formula down several rows and lock a cell ref. | Excel Discussion (Misc queries) | |||
Hybrid Mode
