ExcelBanter - how do I invert the rows and colums in excel?

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

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

- - how do I invert the rows and colums in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/51255-how-do-i-invert-rows-colums-excel.html)

Aldofabrizi

how do I invert the rows and colums in excel?

Is there an easy way to invert rows and columns in Excel?

Niek Otten

how do I invert the rows and colums in excel?

Look at EditPaste Special, Transpose

--
Kind regards,

Niek Otten

"Aldofabrizi" wrote in message
...
Is there an easy way to invert rows and columns in Excel?

bpeltzer

how do I invert the rows and colums in excel?

Select the range you wish to 'invert' and copy. Then Edit Paste Special
and select the Transpose radio button.

--Bruce

"Aldofabrizi" wrote:

Is there an easy way to invert rows and columns in Excel?

All times are GMT +1. The time now is 04:33 AM.