How do I make columns into rows in an excell spreadsheet?

Question

I have something in a column and I want it to appear as a row... retyping it would be a LONG process so I am hoping there is some easy way to do this.

Answer 1

You can select the column you want and copy it. Then go to the target (where you want to make it into rows) and select Edit -> Paste Special from the menu bar. In there, make sure you mark the box that says 'Transpose'. Voila!

Answer 2

Excel Help is not very good, but if you word it correctly you get the right answer...

Switch rows of cells to columns or columns to rows

Data from the top row of the copy area appears in the left column of the paste area, and data from the left column appears in the top row.
1. Select the cells that you want to switch.
2. Click Copy .
3. Select the upper-left cell of the paste area.
The paste area must be outside the copy area.
4. On the Edit menu, click Paste Special.
5. Select the Transpose check box.

Answer 3

Assuming you want to negate all the numbers in column A. Enter -1 in any cell (preferably not in column A but it will work). Copy that cell. Select column A. Right click> Paste Special and select multiply. Another way is by using Visual Basic and adding a Button.

Answer 4

Copy the entire column. Then go to Edit:past special: and check the "transpose" box

Answer 5

Easy

Select Edit -> Paste Special from the menu bar. In there, make sure you mark the box that says 'Transpose'.

Now grab yourself a beer and sit back to admire your work

Answer 6

Copy the column, then right-click the beginning of the row, select "paste special", select "transpose", then "OK".

Answer 7

Highlight cells

copy/cut

paste special...

Choose "transpose" in the pop up window