Exchange row and columns

[Donald Jacobs]

How do I transpose or change the rows and columns in a spread sheet. I
want all the columns to become rows and rows to become columns. I tried
transpose but nothing happened.

Don Jacobs

[JulieD]

Hi Don

there's the transpose function and the edit / paste special / transpose
option - so i'm not sure which one didn't work for you, however, one thing
about the transpose function is that it is an array function - which means
that it needs to be entered with control & shift & enter not just enter.

with the edit/ paste special - transpose functionality, you need to COPY
your data, not CUT it.

in addition, i'm sure you're aware that you can't exceed the limit of 256
columns in a worksheet by using transpose.

Hope this helps
Cheers
JulieD

"Donald Jacobs" <[email protected]> wrote in message
news:%[email protected]...
> How do I transpose or change the rows and columns in a spread sheet. I
> want all the columns to become rows and rows to become columns. I tried
> transpose but nothing happened.
>
> Don Jacobs
>

[Donald Jacobs]

Thanks for the information. I tried the copy, paste special, transpose
and it did the job. I'm going to try the ctrl shift enter to see if it
does the job as well.

Really appreciate you time.
Don Jacobs

[JulieD]

Hi Don

you're welcome and thanks for the feedback.

Cheers
julieD

"Donald Jacobs" <[email protected]> wrote in message
news:[email protected]...
> Thanks for the information. I tried the copy, paste special, transpose
> and it did the job. I'm going to try the ctrl shift enter to see if it
> does the job as well.
>
> Really appreciate you time.
> Don Jacobs
>