Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to switch position of columns and rows respectively?
Epinn
Hover mouse just under column letter till you see a 4 pointed arrow,right clickdrag When you release mouse button you will see a new range of options including Move -- Regards Roger Govier "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to switch position of columns and rows respectively? | Excel Worksheet Functions | |||
switch rows and columns | New Users to Excel | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Switch Rows and Columns | Excel Discussion (Misc queries) |