change rows to columns/columns to rows

M

Meenie

Isn't there a way to change a spreadsheet so the column headers change to
rows and the row headers change to columns?
I have Excel 2003.
Thanks, Meenie
 
D

Dave

Hi,

Select all your data,
Copy.
Select cell in which you want the top left cell of the transposed data to
appear.
Paste Special.
Tick the Transpose box.
OK.

Regards - Dave
 
M

Meenie

I tried that but it didn't work. I get this error message:
"The selection is not valid. There are several possible reasons
 
G

Gord Dibben

Read the rest of the error message and you will get an idea of what you're doing
incorrectly.

Make sure your selected cell to copy to is not within the range you just copied
to transpose.

Do not select entire columns and try to transpose.

Not enough room across rows.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Calculating Time 5
Can you protect a worksheet from having the columns resized,not ro 3
Find last column matching criteria 2
convert columns to rows 6
excluding column headers from formulas 3
Automatic Sorting? 6

Top