+ Reply to Thread
Results 1 to 3 of 3

Substitution

  1. #1
    Boenerge
    Guest

    Substitution

    Is it possible to substitute the displayed column letters e.g. A B C etc and
    row numbers e.g. 1 2 3 etc for other labels that would be displayed. But in
    the formula's for A B C and 1 2 3 still to be used.

  2. #2
    JulieD
    Guest

    Re: Substitution

    Hi

    no, however, you can suppress the display of the row and column headers by
    choose tools / options / view and unticking row & column headers.

    Then what ever is in column A and row 1 would appear as the "headers"

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "Boenerge" <[email protected]> wrote in message
    news:[email protected]...
    > Is it possible to substitute the displayed column letters e.g. A B C etc
    > and
    > row numbers e.g. 1 2 3 etc for other labels that would be displayed. But
    > in
    > the formula's for A B C and 1 2 3 still to be used.




  3. #3
    Bob Phillips
    Guest

    Re: Substitution

    No, the best you can do is suppress row and column headings, and then
    insert your own in row 1, column 1

    --
    HTH

    Bob Phillips

    "Boenerge" <[email protected]> wrote in message
    news:[email protected]...
    > Is it possible to substitute the displayed column letters e.g. A B C etc

    and
    > row numbers e.g. 1 2 3 etc for other labels that would be displayed. But

    in
    > the formula's for A B C and 1 2 3 still to be used.




+ 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