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

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


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565825