How can I change my vertical headings for my Excel spreadsheet in.

H

Helpless

I have a spreadsheet set-up, by I need to make the data run across the page
in rows and now down in columns. How can I easily flip my data to this new
format?
 
G

Gord Dibben

Copy then Paste Special>Transpose

NOTE: Excel has 256 columns so your rows to transpose cannot exceed that
number.

Gord Dibben Excel MVP
 

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
Need Help with Macro Security 1
Excel does not accept text format! 0
White space above heading inconsistently applied 1
Booklet in Word, Merge Directory from Excel 0
Need help merging Excel into Publisher Booklet w 2 columns 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top