| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transposing columns
I would like to transpose Column A to Column B....how do I do that in Office
2003? -- LP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transposing columns
Copy the column and then move the point to the cell where you want the data
to start in and click EDIT in the menu, select PASTE SPECIAL and place a check in the TRANSPOSE check box. Click OK to complete. -- Kevin Backmann "Lynne" wrote: I would like to transpose Column A to Column B....how do I do that in Office 2003? -- LP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transposing columns
On 29 Oct, 21:11, Lynne wrote:
I would like to transpose Column A to Column B....how do I do that in Office 2003? -- LP Right Click in Column B, Paste Special, Transpose Steve |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transposing columns
Select column B, right click header and select cut, then select A header
and right click and select insert cut cells. -- Regards, Peo Sjoblom "Lynne" wrote in message ... I would like to transpose Column A to Column B....how do I do that in Office 2003? -- LP |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Transposing columns
One more.....
Select column B. Slide cursor down to side of B1 and you will get a 4-headed arrow. Hold SHIFT + click and move to left. Gord Dibben MS Excel MVP On Mon, 29 Oct 2007 14:11:02 -0700, Lynne wrote: I would like to transpose Column A to Column B....how do I do that in Office 2003? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing Rows and Columns Using Paste Special | Excel Discussion (Misc queries) | |||
| Transposing three columns into one row after manipulating data in columns | Excel Discussion (Misc queries) | |||
| Transposing | Excel Worksheet Functions | |||
| Transposing 4-row clumps of name and address in Column A to Columns A,B,C,D | Excel Worksheet Functions | |||
| Transposing Repeat Rows Into Consolidated Columns | Excel Discussion (Misc queries) | |||
Linear Mode
