View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default how to switch rows


T Kirtley wrote:
If you want to move the entire row you can use the following sequence:

Shift^Spacebar to select a row (or several consecutive rows), then
Ctrl^X to cut the row(s),
Move to the row where you want to insert the cut row and press
Shift^Spacebar again to mark where to insert the row, and finally,
Ctrl^+ (thats the plus key on the number keypad) which moves the row(s) you
cut to the new location.

Hope that helps,

TK


That works but its almost as much work as the dumb way (create an empty
row where you want the source row to go, copy paste the source row to
the empty target row and then delete the original source row).

But thanks any ways.

" wrote:

Is there a quick way to switch the contents of two rows ?

Thanks.