Displaying column and row names

I

Ingebelle's

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.
 
P

Per Jessen

Hi

In excel 2000 and similar:

Tools > Options > View > Check "Row & column headers" > OK

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column that needs separation 2
Specific Names 1
Column and Row mapping? 4
Hide and Unhide Function 4
Auto Fill 5
Help with conditionally unhiding columns 1
How to sort entire spreadsheet by one column sort 5
Excel - Hiding Column Headings (A,B,C,...) and Row Names (1,2,3,.. 4

Top