+ Reply to Thread
Results 1 to 3 of 3

Copy Column headings to Rows

  1. #1
    DTTODGG
    Guest

    Copy Column headings to Rows

    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.

  2. #2
    Forum Contributor
    Join Date
    07-11-2005
    Posts
    110
    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...

  3. #3
    DTTODGG
    Guest

    Re: Copy Column headings to Rows

    Simple - Beautiful.
    Thanks for teaching me.

    "Brisbane Rob" wrote:

    >
    > 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...
    >
    >
    > --
    > Brisbane Rob
    > ------------------------------------------------------------------------
    > Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
    > View this thread: http://www.excelforum.com/showthread...hreadid=484424
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1