How many ways to copy data?

[Craig]

I realize in Excel there are many ways of doing the same
thing, but I'm curious. Just for kicks, can anyone tell
me how many ways there are (or that you can think of) to
copy data from one cell to another?

My co-worker claims there are 4 ways (File/Copy, the ctrl-
c/ctrl-v keyboard shortcuts, the copy/paste buttons, and
through VBA code). I'm thinking there are more. I know
you can use named references to refer to other cells, and
in a sense, copy the data from one area to another by
refering to the referenced name. I'm sure there are
custom functions that could be created, etc.

Thanks.

 

[DDM]

Craig, in addition to the ways you mentioned:

1-Right-click cell > Copy; right-click destination cell > paste.
2-Grab cell pointer with left mouse button; drag to destination; press and
hold Ctrl; release left mouse button.
3-Grab cell pointer with right mouse button; drag to destination; release
right mouse button; select Copy here.

 

[Arvi Laanemets]

Hi

You both are wrong )
There are more as 4 ways to copy, but...

At start your co-worker forgot Paste Special option, which has a lot
different possibilities.

You can drag cell(s) so cell contents are copied to range. Select a range,
place the mouse cursor over rihtmost lower corner of range, so that the
cursor changes to cross, press down left mouse button, and holding button
down drag the marked area up/down or left/right. There are variations how
this works, depending cell contents in start range and start range
dimensions.

You can copy whole sheet into same or other workbook, right-clicking on
sheet tab and selecting 'Create a copy ...' from drop-down menu.

But in other hand, using references to source cells (by name or by address,
it doesn't matter) has nothing to do with copying. You simply write a
formula into cell. Main difference from copy is, that such formulas (links)
mirror changes made on original sheet afterwards.

Another way (again not copying) to get data from various sources (not only
Excel tables) is ODBC query, but I'm afraid it'll too much for start.

 

[Craig]

Thanks for the input!

-----Original Message-----
Craig, in addition to the ways you mentioned:

1-Right-click cell > Copy; right-click destination cell > paste.
2-Grab cell pointer with left mouse button; drag to destination; press and
hold Ctrl; release left mouse button.
3-Grab cell pointer with right mouse button; drag to destination; release
right mouse button; select Copy here.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com





.