D
Dave Peterson
You can either see letters or numbers or nothing as the column headers.
In xl2003 menus, you can toggle the setting here:
Tools|Options|General Tab|check/uncheck the R1C1 reference style
To hide the numbers or letters:
Tools|Options|View Tab|check/uncheck Row and column headers
======
For me, I like to see the letters at the top (for the most part). And I would
expect most excel users know how excel works and find those headers useful --
even if they like to see numbers.
I wouldn't change that view for the users.
But I would put the headers I want in row 1 and freeze the window so that those
headers are always visible:
Select A1 to make sure it's visible
select B1
Window|Freeze Panes.
Every row above the selected cell will be frozen. (And every column to the left
of the selected cell will be frozen -- even though I didn't use it in this example.)
In xl2003 menus, you can toggle the setting here:
Tools|Options|General Tab|check/uncheck the R1C1 reference style
To hide the numbers or letters:
Tools|Options|View Tab|check/uncheck Row and column headers
======
For me, I like to see the letters at the top (for the most part). And I would
expect most excel users know how excel works and find those headers useful --
even if they like to see numbers.
I wouldn't change that view for the users.
But I would put the headers I want in row 1 and freeze the window so that those
headers are always visible:
Select A1 to make sure it's visible
select B1
Window|Freeze Panes.
Every row above the selected cell will be frozen. (And every column to the left
of the selected cell will be frozen -- even though I didn't use it in this example.)