Row / Column Header not fully shown in Normal View

**codepin** · 03-10-2009, 11:54 PM

Hi All,

Recently I come across a file with only 1 sheet, in which is a table only occupied an array of A1:Q49. In Normal View I can see the row / column header of A-Q and 1-49 as usual, but nothing outside that range (only grey colour). Also, the empty cells outside A1:Q49 are all grey too. How can I do that? Kindly please advise, thanks.

**shg** · 03-11-2009, 12:22 AM

Select all the cells on the sheet (click the box at the upper left intersection of the row and column headers) and do Format > Row > Unhide, then Format > Column > Unhide.

**codepin** · 03-11-2009, 01:22 AM

Originally Posted by shg

Select all the cells on the sheet (click the box at the upper left intersection of the row and column headers) and do Format > Row > Unhide, then Format > Column > Unhide.

Hi SHG,

It works great, many thanks.