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

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

" wrote:

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

Thanks.