View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default How to switch position of columns and rows respectively?

http://www.mvps.org/dmcritchie/excel/swap.htm
--
David Biddulph

"Epinn" wrote in message
...
No, I am not talking about transposing column(s) to row(s) etc.

I want to switch position of column A and column B, barring the fact that no
formulae will be jeopardized.

I can use CTRL|Shift|+ to shift a column to the right. I can just click and
drag a sheet tab to a new position. But I don't know how to drag column A
to the right of column B or row 1 under row 2. Of course, I can insert
column, copy, paste etc. But I am hoping there is something easier.

I have searched the entire shortcut key table, but didn't have much luck.
So, I decided to post.

All methods welcome. Thank you.

Epinn