Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transposing
I have a spreadsheet that contains 45 rows and 90 columns. I need to make the
rows into 45 columns and the columns into 90 rows. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transposing
Hi Deena
Copy and right click your mouse button to select paste special and select "Transpose". thanks, Shail Deena wrote: I have a spreadsheet that contains 45 rows and 90 columns. I need to make the rows into 45 columns and the columns into 90 rows. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transposing
From the help file....
Move data between rows and columns Copy the data in one or more columns or rows. Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special. In the Paste Special dialog box, select Transpose, and then click OK. You'll find theTranspose check box in the lower-right corner of the dialog box: -- ~Anne Troy www.OfficeArticles.com "Deena" wrote: I have a spreadsheet that contains 45 rows and 90 columns. I need to make the rows into 45 columns and the columns into 90 rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty in transposing | New Users to Excel | |||
transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
How to copy a row with transposing to a column retaining links to input cells? | Excel Worksheet Functions | |||
Transposing data | New Users to Excel | |||
transposing an array converts dates into numbers | Excel Worksheet Functions |