ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   extra rows and columns wouldn't show (https://www.excelbanter.com/excel-discussion-misc-queries/219654-extra-rows-columns-wouldnt-show.html)

Sahir

extra rows and columns wouldn't show
 
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

extra rows and columns wouldn't show
 
See your other post?

Gord Dibben

extra rows and columns wouldn't show
 
Ctrl + a to select all cells then FormatRowsUnhide.

Same for Columns.


Gord Dibben MS Excel MVP

On Sun, 8 Feb 2009 00:02:01 -0800, 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.




All times are GMT +1. The time now is 04:00 PM.

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