Displaying column and row names
 

I have a spreadsheet where someone has hidden just the column name (A, B, C -
AZ and so on) as well as the numbered row names. How do I get them to
display on the screen? I do not want to hide/unhide entire columns or rows,
I know how to. I want to see the alpha and numeric names on the top and side
of the screen. Without them one cannot select the entire column by clicking
on the column name.

Displaying column and row names
 

Tools/Options/View/Row & Column Headers

Best rgds
Lav
"Ingebelle's" wrote in message
...
I have a spreadsheet where someone has hidden just the column name (A, B,
C -
AZ and so on) as well as the numbered row names. How do I get them to
display on the screen? I do not want to hide/unhide entire columns or
rows,
I know how to. I want to see the alpha and numeric names on the top and
side
of the screen. Without them one cannot select the entire column by
clicking
on the column name.

Displaying column and row names
 

In Tools, Options, elect to Show Row and Column headers.

Ingebelle's wrote:

I have a spreadsheet where someone has hidden just the column name (A, B, C -
AZ and so on) as well as the numbered row names. How do I get them to
display on the screen? I do not want to hide/unhide entire columns or rows,
I know how to. I want to see the alpha and numeric names on the top and side
of the screen. Without them one cannot select the entire column by clicking
on the column name.

Displaying column and row names
 

Hi

In excel 2000 and similar:

Tools Options View Check "Row & column headers" OK

Regards,
Per

"Ingebelle's" skrev i meddelelsen
...
I have a spreadsheet where someone has hidden just the column name (A, B,
C -
AZ and so on) as well as the numbered row names. How do I get them to
display on the screen? I do not want to hide/unhide entire columns or
rows,
I know how to. I want to see the alpha and numeric names on the top and
side
of the screen. Without them one cannot select the entire column by
clicking
on the column name.