| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 50971 | 2004-11-07 21:32:00 | hidden column and row labels in Excel | Mike S (1766) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 289097 | 2004-11-07 21:32:00 | My daughter is being driven mad by an Excel spreadsheet where the originator has somehow hidden the column and row labels. She wants to get them back. Does anybody have any clues please? Platform is Excel 2002. Mike S |
Mike S (1766) | ||
| 289098 | 2004-11-07 22:22:00 | Here we go: Tools (menu)- Options - View (tab) then select the check box next to "Row & Column Headers" Hope this helps :-) |
Marlboro (4607) | ||
| 289099 | 2004-11-07 22:31:00 | Select the column tabs either side of the hidden one eg C & E if D is hidden, right click & select unhide Same with the rows To select both columns either use ctrl & click both tabs or click one tab & drag mouse |
45South (4769) | ||
| 289100 | 2004-11-07 23:51:00 | Many thanks Marlboro. It's so infuriatingly simple isn't it?!! I searched all the options in all the menus - - I THOUGHT. Great stuff. Sanity has returned. Mike S |
Mike S (1766) | ||
| 289101 | 2004-11-07 23:57:00 | Sorry I didn't read it properly I thought it was Columns & Rows that were hidden, not the tabs My bad |
45South (4769) | ||
| 289102 | 2004-11-08 01:28:00 | as 45South said with on modification select the whole sheet "ctrl A" then you get all those hidden beasties ;) | beama (111) | ||
| 1 | |||||