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!!!

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!!!

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!!!

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!!!