creating a list of column headers

[rfhurley]

I'm trying to take just the column headers/captions and arange them
into a simple list. Could anyone suggest an easier way than cutting and
pasting each individual header into the list?
Thanks

 

[Excelenator]

Highlight all the column headers you want to put in the list (I assume
you mean in rows in a single column) right click and select Copy and
then select the first cell where you want the list items to appear and
right click and select paste special. At the bottom of the dialog box
check the box next to "Transpose" and click OK.

I'm trying to take just the column headers/captions and arange them
into a simple list. Could anyone suggest an easier way than cutting
and
pasting each individual header into the list?
Thanks