PDA

View Full Version : hidden column and row labels in Excel



Mike S
08-11-2004, 10:32 AM
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

Marlboro
08-11-2004, 11:22 AM
Here we go:

Tools (menu)- Options - View (tab) then select the check box next to "Row & Column Headers"

Hope this helps :-)

45South
08-11-2004, 11:31 AM
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

Mike S
08-11-2004, 12:51 PM
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

45South
08-11-2004, 12:57 PM
Sorry I didn't read it properly I thought it was Columns & Rows that were hidden, not the tabs
My bad

beama
08-11-2004, 02:28 PM
as 45South said with on modification select the whole sheet "ctrl A" then you get all those hidden beasties ;)