First Column in with row tiltes??

[mark 27]

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.

 

[Anne Troy]

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.

 

[mark 27]

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.

 

[Chris Davison]

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

 

[mark 27]

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.

 

[NateO]

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