Easier way to move content of a cell than cut/paste or drag/drop?

[user]

I move content of cells to new location all the time. Cut and paste takes just a little too many clicks.

When I used to use the spreadsheet in AppleWorks, I was able to select a cell, hold down command key, then click on a
new cell in order to move the content of the original cell to the new one. Is there a way this could be done in Excel? TIA.

George

 

[Bernard Rey]

I move content of cells to new location all the time. Cut and paste takes just
a little too many clicks.

When I used to use the spreadsheet in AppleWorks, I was able to select a cell,
hold down command key, then click on a
new cell in order to move the content of the original cell to the new one. Is
there a way this could be done in Excel? TIA.

When you cell is selected, if you move the cross to one of the four border
lines, you'll see the cross become a hand. If you then click and hold, you
can drag the cell to wherever you like (it's equivalent to cut and paste,
which can cause some formatting problems - the original cell being totally
reset). If you hold the "Option" key down doing this, it'll copy the cell to
the new destination. This works with Excel v.X and Excel:2001. In Excel 98,
it works too though the cross won't become a hand, but an arrow.