ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   help on rows and columns (https://www.excelbanter.com/excel-discussion-misc-queries/219655-help-rows-columns.html)

Sahir

help on rows and columns
 
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.

curlydave

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


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com