Copy Column headings to Rows

G

Guest

Hello-
I'm trying to find a fast way to list all the headings in my spreadsheet.
Because there are so many, I thought I could just list them vertically. Is
this possible?
I didn't get anyone to answer my post on wraping columns, so I'm hoping this
will atleast let me print the headings.
Thanks.
 
B

Brisbane Rob

Easiest way I know is to Copy the column headings, highlight the cell
you want to be the start of your new column with the headings in, and
go to Copy Paste Special and check the Transpose box. Works for me...
 

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

Row & Column Headings 2
Column Headings (Excel 2007) 2
Column Headings, Fixing In-Place 10
Excel Help to copy information from one row at a time to another sheet 1
Printer purchase help and advice 10
Off Set printing 3
Copy column and rearrange rows 5
VBA - retrieve data on last create named range from previous inserted named range 0

Top