Transposing...

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
Hi
not sure about your references but for copying values have a look at
'Edit - Paste Special - Transpose'
 
Back
Top