| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to swap the contents rows and columns in a spreadsheet?
Are there ways to swap the contents in the rows and the columns?
ie. A1 B1 -- A1 A2 A2 B2 -- B1 B2 Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to swap the contents rows and columns in a spreadsheet?
copy the range
go to a new sheet paste special...........tick transpose -- Greetings from New Zealand "Andrew" wrote in message ... Are there ways to swap the contents in the rows and the columns? ie. A1 B1 -- A1 A2 A2 B2 -- B1 B2 Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to swap the contents rows and columns in a spreadsheet?
Transpose will do it! Here are some ideas:
http://www.techonthenet.com/excel/fo.../transpose.php http://blogs.techrepublic.com.com/msoffice/?p=630 http://www.timeatlas.com/mos/5_Minut...umns_and_Rows/ HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bill Kuunders" wrote: copy the range go to a new sheet paste special...........tick transpose -- Greetings from New Zealand "Andrew" wrote in message ... Are there ways to swap the contents in the rows and the columns? ie. A1 B1 -- A1 A2 A2 B2 -- B1 B2 Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to swap contents between 2 cells in MS Excel 2003? | Excel Discussion (Misc queries) | |||
| Is there an easy way to swap the contents of two cells in Excel? | Excel Discussion (Misc queries) | |||
| swap rows and columns | Excel Discussion (Misc queries) | |||
| Swap contents of two cells | Excel Discussion (Misc queries) | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Linear Mode
