Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003: Swap or flip or rotate rows and columns (instructions didn't work)
I use Excel 2003 and I'm trying to swap or flip the rows and columns (or rotate - I've seen it each way in the documentation I've read).
I have this: Columns A B C Rows 1 2 3 I need this: Columns 1 2 3 Rows A B C I need to have rows A-Z and comuns 1-31. (I don't have any data in the worksheet yet. I'm trying to set it up before entering the data.) Here's what I've tried: I selected A1-Z31 and copied it, moved outside the selected cells, clicked Edit/Paste Special/Transpose/Ok Nothing happens. I even tried opening a new worksheet, selecting A1 Edit/Paste Special/Transpose/Ok but it didn't paste. I've read these instructions on many sites and I can't figure out why it's not working! BJ Martens |
#2
|
|||
|
|||
Quote:
Dear BJ Martens, Good Morning. The procedure that you described above works on changing position of DATA. If you have one column of DATA, then you may TRANPOSE it to a one row of DATA. That function, TRANSPOSE, donīt change the LAYOUT of Excel Worksheet. it works only with DATA. You Said: "...I use Excel 2003 and I'm trying to swap or flip the rows and columns (or rotate - I've seen it each way in the documentation I've read)..." "...I've read these instructions on many sites and I can't figure out why it's not working!..." Those documentation tells about CHANGING LAYOUT of Excel Worksheet OR Transpose of DATA on Excel Worksheet? I want help you. Coulīd you pointing me those documentation?
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I rotate data in Excel table (rows to columns, and vv)? | Excel Discussion (Misc queries) | |||
Instructions to convert columns to rows Excel help are not correct | Excel Worksheet Functions | |||
My drawing rotate/flip tool not accessible in Excel | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) |