I want to change the orientation of an Excel spreadsheet. Is there a fast
way to change the horizontal data enteries across multiple columns to now be
stacked vertically in rows (or vice versa)? Thanks in advance!

Look at Copy/Paste Special=Transpose (at bottom of Paste Special form).

HTH

"Chris Fearon" wrote:

I want to change the orientation of an Excel spreadsheet. Is there a fast
way to change the horizontal data enteries across multiple columns to now be
stacked vertically in rows (or vice versa)? Thanks in advance!

Copy your range. Then, after selecting destination first cell,
EditPaste Special... Check the Transpose checkbox at the bottom.

You can make a permanent link to the original data using the TRANSPOSE
function. Before entering you need to select the entire NxM range (if
MxN was the original). Then, with the entire range selected:

=TRANSPOSE(original range)

Commit with Shift+Ctrl+Enter (array formula)

HTH
Kostis Vezerides

On Jun 22, 8:47 pm, Chris Fearon
wrote:
I want to change the orientation of an Excel spreadsheet. Is there a fast
way to change the horizontal data enteries across multiple columns to now be
stacked vertically in rows (or vice versa)? Thanks in advance!

Copy and PasteSpecial Transpose but the areas can't overlap

Regards

Trevor


"Chris Fearon" wrote in message
...
I want to change the orientation of an Excel spreadsheet. Is there a fast
way to change the horizontal data enteries across multiple columns to now
be
stacked vertically in rows (or vice versa)? Thanks in advance!