Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Invert layout
Not sure how to words this, but bascially, I have an excel doc that I want to
invert, i.e make the data in the rows into columns, and the data in the columns into rows.. The reason I want to do this is because I have 2-3 rows, but 20-30 columns. You can't print the doc nicely like that. Any ideas? |
#2
|
|||
|
|||
I'd insert a new worksheet.
Then select the original range and edit|copy then go to A1 of that new worksheet and edit|paste special|transpose and print the sheet (and delete it???) Moshe Rosenberg wrote: Not sure how to words this, but bascially, I have an excel doc that I want to invert, i.e make the data in the rows into columns, and the data in the columns into rows.. The reason I want to do this is because I have 2-3 rows, but 20-30 columns. You can't print the doc nicely like that. Any ideas? -- Dave Peterson |
#3
|
|||
|
|||
Amazing! Thanks!
"Dave Peterson" wrote: I'd insert a new worksheet. Then select the original range and edit|copy then go to A1 of that new worksheet and edit|paste special|transpose and print the sheet (and delete it???) Moshe Rosenberg wrote: Not sure how to words this, but bascially, I have an excel doc that I want to invert, i.e make the data in the rows into columns, and the data in the columns into rows.. The reason I want to do this is because I have 2-3 rows, but 20-30 columns. You can't print the doc nicely like that. Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application to turn a table layout webpage back into a spreadsheet? | Excel Discussion (Misc queries) | |||
How do you name and use a custom Layout | Excel Discussion (Misc queries) | |||
I want to copy only the layout and formulas and not the exisiting | Excel Discussion (Misc queries) | |||
Invert Text | Excel Discussion (Misc queries) | |||
Invert Excel Selection | Excel Discussion (Misc queries) |