View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Jerakis[_2_] Mike Jerakis[_2_] is offline
external usenet poster
 
Posts: 8
Default creating list of column headers

You could just select the row where all the headers are and Copy them.
Instead of paste, use EditPaste Special and then select Transpose.

"rfhurley" wrote:

Hi

I'm trying to create a list of column headers for an enormous
spreadsheet, and I was wondering if there was an easy way to do this
without cutting each header individually and pasting it into a single
column.