Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart, Displaying two values on one column. | Charts and Charting in Excel | |||
Time delay in displaying charts & chart names | Charts and Charting in Excel | |||
Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
Range names are displaying in big blue letters on sheet | Excel Discussion (Misc queries) | |||
Displaying names only once | Excel Worksheet Functions |