Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 206
Default extra rows and columns wouldn't show

See your other post?
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where are the extra columns and rows? frankoamerican Excel Discussion (Misc queries) 6 January 15th 09 10:07 PM
How to do: If 'yes', then show extra columns mgirving Excel Discussion (Misc queries) 1 September 2nd 06 01:36 PM
extra rows and columns Wooster New Users to Excel 3 December 4th 05 12:45 AM
2 Columns - Show extra items in Column B orbojeff Excel Worksheet Functions 4 October 9th 05 04:51 AM
2 Columns - Show extra items in Column B orbojeff Excel Discussion (Misc queries) 3 October 7th 05 09:55 PM


All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"