0
Transposing means changing the orientation of data. So data in rows can be changed to be in columns and data in columns can be put into rows. It can only be done with copied data, and not cut data. So you could delete the original if you did not want it afterwards.
The first thing to do is to select the data. The do a copy action, using the mouse, menu or keys. Now put the cursor into the cell where you want the transposed data to start from. Now, the important part. Instead of pasting, you activate Paste Special. This can be found on the Edit menu, or if you right click on the mouse, it will be on the shortcut menu. At the end of the dialog box that Paste Special has, you will see the Transpose option. Click the box beside it to put a tick into it and then Click OK. Your data will be transposed.
What else can I help you with?
How do you explain a Microsoft Excel?
spreadsheet
What is the step function of Microsoft Excel?
There is no step function in Excel. However, you can use excel to create a Step Function Chart. See related links for a video to explain the process.
In Microsoft Excel you dont have LHS explain that?
I might be able to explain it if you define LHS.
How do you convert rows to columns in an Microsoft Excel sheet?
1) Copy the data to be converted 2) Paste Specialand tick the Transpose box
Can a person complete calculations in Microsoft Excel 2003?
Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.
How do you convert a piece of text written in columns to rows?
In Microsoft Excel, you use the transpose() function to convert columns to rows and vice versa. Please see the link.
Who are the creators of Microsoft Excel?
Microsoft excel was created by Microsoft
How do you launch Microsoft Excel?
Programs->Microsoft Office->Microsoft Excel
Switch rows and columns in Excel?
Columns and rows can be swapped by transposing them. You can copy a row of cells and using Paste Special and the Transpose option the data can be put into columns. You can do the same with data in columns and transpose them into rows. There is also a Transpose function in Excel.
What is the spreadsheet program in Microsoft office 2007?
I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.
Who created Microsoft Excel?
Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.
Is there any hidden game in Excel 2003?
There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.
