Excel 2007


L

LogJAM57

How do you change the rows to columns and the columns to rows in a spread
sheet when copying, using excel 2007. I believe with excel 2003 you could do
it with paste special, but I cannot find that option with my excel 2007
 
Ad

Advertisements

T

Tom Hutchins

Copy the range you want to transpose. Select the starting cell where you want
to paste the cells. On the Home ribbon, click the arrow under Paste to show
the Paste options. Select Transpose. Or, the keystrokes to paste/transpose
are {Alt}HVT

Hope this helps,

Hutch
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top