Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Direction Columns/Rows
Hi There-
I'm trying to use a pricing spreadsheet that's already been created and used for several years in Excel, but I need to copy/paste it into a layout program (Quark) where the columns and rows run the opposite direction. Any suggestions on ways to use this spreadsheet and change the direction it runs??? Otherwise I'm retyping pricing for our entire catalog - which is a bit tedious and requires much proofreading. Help!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Direction Columns/Rows
Select, Copy, Paste Special, Transpose, will switch the contents columns
to rows. Try pasting into another sheet to play. Lori Cartwright wrote: Hi There- I'm trying to use a pricing spreadsheet that's already been created and used for several years in Excel, but I need to copy/paste it into a layout program (Quark) where the columns and rows run the opposite direction. Any suggestions on ways to use this spreadsheet and change the direction it runs??? Otherwise I'm retyping pricing for our entire catalog - which is a bit tedious and requires much proofreading. Help!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Direction Columns/Rows
It worked!! Thank you, thank you.
"Bob I" wrote: Select, Copy, Paste Special, Transpose, will switch the contents columns to rows. Try pasting into another sheet to play. Lori Cartwright wrote: Hi There- I'm trying to use a pricing spreadsheet that's already been created and used for several years in Excel, but I need to copy/paste it into a layout program (Quark) where the columns and rows run the opposite direction. Any suggestions on ways to use this spreadsheet and change the direction it runs??? Otherwise I'm retyping pricing for our entire catalog - which is a bit tedious and requires much proofreading. Help!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Direction Columns/Rows
You're welcome, have a great day!
Asphalt Dancer wrote: It worked!! Thank you, thank you. "Bob I" wrote: Select, Copy, Paste Special, Transpose, will switch the contents columns to rows. Try pasting into another sheet to play. Lori Cartwright wrote: Hi There- I'm trying to use a pricing spreadsheet that's already been created and used for several years in Excel, but I need to copy/paste it into a layout program (Quark) where the columns and rows run the opposite direction. Any suggestions on ways to use this spreadsheet and change the direction it runs??? Otherwise I'm retyping pricing for our entire catalog - which is a bit tedious and requires much proofreading. Help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Columns to Rows | Excel Discussion (Misc queries) | |||
Changing worksheet direction | Excel Worksheet Functions | |||
Changing Rows into Columns | Excel Discussion (Misc queries) | |||
Changing Columns to Rows | Excel Discussion (Misc queries) | |||
Changing the Direction of Data within a Column | Excel Worksheet Functions |