Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: First Column in with row tiltes??

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Mark
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm looking to move/merge/hide COLUMN A into the row titles. I've seen it done before and it works well any ideas would be appreciated.

    Thanks in advance.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not sure I understand what you want, but perhaps:

    Select the cells in column A.
    Hit Copy.
    Hit Edit-Paste special-Transpose.

    This takes the contents of column A and spreads them across the columns in row 1.
    ~Anne Troy

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Mark
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes it is a bit hard to explain...

    Basically can I have the contents of column a merged with the row titles? Eh? mmm it's hard. I want them on the far left?

    I have a sheet with it done already but don't know the author.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mark,

    do you mean you want the rows to read something other than 1,2,3,4,5,6,7 etc etc ?

    (guessing your example has column and row headers switched off, but employs freeze panes frozen on column A)

    To freeze Column A so it always stays "far left" click in cell B1 and goto "window" and then "freeze panes"

    To remove row and column headers goto "tools" then "options" then "view" and uncheck the "rows and column headers"

    Hope this is what you're after
    Chris


    [ This Message was edited by: Chris Davison on 2002-02-24 15:22 ]

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Mark
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not it, sorry. I'll try again......

    label row 1 = a1
    label row 2 = a2
    label row 3 = a3
    etc, etc...

    Maybe i'll just keep using the copy I have when I need to use it.

  6. #6
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Depends what you want. For the cell address:

    =SUBSTITUTE(ADDRESS(ROW(),COLUMN()),"$","")

    For the contents of the corresponding column to be transposed in the row:

    =INDIRECT(ADDRESS(1,ROW()))

    Cheers, Nate

    [ This Message was edited by: NateO on 2002-02-25 11:56 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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