help on rows and columns

S

Sahir

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.
 
C

CurlyDave

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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extra rows and columns wouldn't show 2
counting blank cells within two columns 2
rows and columns on worksheet 1
Freeze multiple rows/columns in Excel 2007 11
Data Filter on Selected rows and columns 2
Freeze columns and rows 3
How to filter rows data based on background color of individual cells 1
How to covert rows to columns or columns to rows. 11

Top