Transposing...

D

Dave

Hi all,
I have an Excel 97 spreadsheet with data in row 1. Cells
in other worksheets reference cells in this row. I want to
transpose the data to column 1 and remove the first row
without the references being lost. Can anyone suggest a
way to make this possible without manually moving each
cell from the row to the column?
Thanks in advance,
Dave
 
F

Frank Kabel

Hi
not sure about your references but for copying values have a look at
'Edit - Paste Special - Transpose'
 
Top