Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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" wrote in message ... 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
![]() |
|||
|
|||
![]()
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why does ON = Ambiguous in substitution formula? | Excel Worksheet Functions |