| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Swapping Rows & Columns
Is there a way to switch data from rows to colums?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Swapping Rows & Columns
Copy your data (select it and press Ctrl-V)
Select a cell where there is ample room for your data Press Alt-E, S, E (Edit-Paste special-Transpose) "Alan" wrote: Is there a way to switch data from rows to colums? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Swapping Rows & Columns
A quick way is to select the data and use Edit | Copy (or [ctrl]+[C]) and
then pick the place where you want to put it in the new layout and use Edit | Paste Special and be sure and click the checkbox next to "Transpose" just above the buttons, and then click the [OK] button. "Alan" wrote: Is there a way to switch data from rows to colums? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| swapping column info between 2 columns | Excel Worksheet Functions | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
| swapping data from 2 separate columns | Excel Discussion (Misc queries) | |||
| swapping columns?? | Excel Discussion (Misc queries) | |||
| Swapping rows and columns | Excel Worksheet Functions | |||
Linear Mode
