View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default help on rows and columns

On Feb 8, 1:03*am, Sahir wrote:
I have downloaded a workbook from somewhere I don't remember.

It has a worksheet in it which has columns A to I only and rows 1 to 52
only. After row 52 and column I there's just grey space which is also not
selectable with the cursor.

I want to know, how to do that and how do I unlock the rows and columns?

Please help.


The rows are hidden, Select the sheet by clicking on the square at the
left top corner of the spread sheet, the hit Ctrl+Shift+0 to unhide
the Columns And Ctrl+Shift+9 to unhide the Rows
Ctrl+0 will hide selected Columns and Ctrl+9 will hide selected rows
You can also use the format menu to hide rows and columns