+ Reply to Thread
Results 1 to 6 of 6

How do I name the colums and rows?

  1. #1
    Cin3
    Guest

    How do I name the colums and rows?

    I want to put a name into the colums where it says "A-Z". I need help on
    doing this.

    Can you help?

  2. #2
    Peo Sjoblom
    Guest

    RE: How do I name the colums and rows?

    If you mean the built in column headers there is no way except removing them
    and fake lookalike headers in row1


    Regards,

    Peo Sjoblom

    "Cin3" wrote:

    > I want to put a name into the colums where it says "A-Z". I need help on
    > doing this.
    >
    > Can you help?


  3. #3
    JE McGimpsey
    Guest

    Re: How do I name the colums and rows?

    Can't be done.

    You can simulate this by hiding row and column headers
    (Tools/Options/View), then entering the values you want in A1:Z1. This
    won't change your cell references however (though you may be able to use
    the intersection operator - I don't). Then enter 1 in A2 and fill down
    as a series to simulate the row numbers.

    If you do this, select cell B2 and choose Window/Freeze Panes to keep
    the new column or row "headers" from scrolling.


    In article <67D02F71-39C1-4B6B-8A28-9223E8B86BDA@microsoft.com>,
    "Cin3" <Cin3@discussions.microsoft.com> wrote:

    > I want to put a name into the colums where it says "A-Z". I need help on
    > doing this.


  4. #4
    Bob Phillips
    Guest

    Re: How do I name the colums and rows?

    You can't. Best you can do is put a heading in row 1. You could then hide
    headings.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Cin3" <Cin3@discussions.microsoft.com> wrote in message
    news:67D02F71-39C1-4B6B-8A28-9223E8B86BDA@microsoft.com...
    > I want to put a name into the colums where it says "A-Z". I need help on
    > doing this.
    >
    > Can you help?




  5. #5
    Alan Beban
    Guest

    Re: How do I name the colums and rows?

    JE McGimpsey wrote:
    >. . .you may be able to use
    > the intersection operator - I don't....


    OK, I'll bite. Why not?

    Alan Beban

  6. #6
    JE McGimpsey
    Guest

    Re: How do I name the colums and rows?

    In article <u17Khm38EHA.3120@TK2MSFTNGP12.phx.gbl>,
    Alan Beban <unavailable@no.com> wrote:

    > OK, I'll bite. Why not?


    Because handing a file that uses intersections over to my clients to
    maintain is generally a recipe for disaster.

    Especially if the specification calls for row or column headers using
    multiple words, e.g.:

    Heading 1 Heading 2 Heading 3
    Row 1 1 2 3
    Row 2 4 5 6
    Row 3 7 8 9


    seeing

    = Heading 2 Row 1 + Heading 1 Row 3 / Heading 3 Row 2

    just doesn't make sense to them, somehow.

+ 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