creating a list of column headers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rfhurley - 27 Jul 2006 23:20 GMT

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

Reply to this Message

Excelenator - 27 Jul 2006 23:42 GMT

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.

rfhurley Wrote:

> 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

Signature

Excelenator

Reply to this Message