How to rename the head A,B,C,D,E etc. on every column
 

How to rename the head A,B,C,D,E etc. on every column
 

You can either see letters or numbers or nothing as the column headers.

In xl2003 menus, you can toggle the setting he
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.)



On 05/18/2010 05:09, shebbir wrote: