| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I copy big ranges of cells without drag or copy/paste?
Double-click on the fill handle will fill down to end of data in an adjacent
column. Or.....with formula in A1, type A1:A2000 in namebox, hit Enter then CTRL + d Gord Dibben MS Excel MVP On Mon, 22 Mar 2010 14:20:01 -0700, Ricardo Julio <Ricardo wrote: I need to copy formulas in a big range of cells and I'm sure there should be a way different than dragging until the last cell I want to copy it. I'm talking of hundreds of cells where I want to copy the formulas. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| Copy drag formula down cells | Excel Worksheet Functions | |||
| Can we drag-copy cells from evry five row to every row | Excel Discussion (Misc queries) | |||
| Can I fix a format so it doesn't change when I drag or copy/paste | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Threaded Mode
