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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Cell data entering slow! 0
Remove Identical words 0
Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Eliminate blanks while copy row and transpose 11
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
How can I print rows that go outside of the page without shrinking the text? 0

Top