| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I copy big ranges of cells without drag or copy/paste?
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I copy big ranges of cells without drag or copy/paste?
Use 'Go To' on the Edit menu (CTRL + G). In reference field enter the
range you want to copy like A1:F25, and click ok. Now the range is selected and ready to be copied. Hopes this helps. .... Per On 22 Mar., 22:20, 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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I copy big ranges of cells without drag or copy/paste?
Click on the cell in the upper most left hand corner of the data you want to copy. Scroll down to the bottom and while holding down the SHIFT key, click on the cell in the lower most right hand corner of the data you want to copy. That will select everything in between the two cells. |
|
#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, |
| Reply |
| 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) | |||
Linear Mode
