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.
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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks