ExcelBanter - Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/263190-excel-2007-a.html)

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

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

"LogJAM57" wrote:

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

You will find Transpose, on the r-click Menu, under Paste Special.

LogJAM57 wrote:

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