ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Substitution (https://www.excelbanter.com/excel-discussion-misc-queries/27267-substitution.html)

Boenerge

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.

JulieD

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.




Bob Phillips

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.





All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com