ExcelBanter - How do I change existing shreadsheet info from vertical to horizon

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I change existing shreadsheet info from vertical to horizon (https://www.excelbanter.com/excel-worksheet-functions/7353-how-do-i-change-existing-shreadsheet-info-vertical-horizon.html)

neokorros

How do I change existing shreadsheet info from vertical to horizon

I have an existing spreadsheet with info already entered. I need to rotate
the info so that the heading (titles) are on along the top (horizontal)
instead of down the side (vertical). How can I do that? Using both microsoft
excel 97 and 2003.

Frank Kabel

Hi
try using
'Edit - Paste Special - Transpose'

--
Regards
Frank Kabel
Frankfurt, Germany

"neokorros" schrieb im
Newsbeitrag ...
I have an existing spreadsheet with info already entered. I need to
rotate
the info so that the heading (titles) are on along the top
(horizontal)
instead of down the side (vertical). How can I do that? Using both
microsoft
excel 97 and 2003.

All times are GMT +1. The time now is 08:48 AM.