show only the required part of the sheet
 

i want excell to display only the selected part of the sheet where there is
data in it and rest all should not be displayed. e.g. from a1 to aa155 should
only be displayed.

show only the required part of the sheet
 

select the entire row 156
shift end down to highlight the rest of the sheet
hit Ctrl 9 (hides rows)
select column AB
shift end right to highlight the rest of the sheet
and press Ctrl 0 ( hides columns)

to unhide rows highlight the entire sheet (by clicking on the top left
corner)and press
Ctrl shift 9

column
Ctrl shift 0


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564601

show only the required part of the sheet
 

You don't say why you want to have cells displayed only if the contain data.
You could -
hide whole rows or whole columns
format cells to be white on white
change the width and height of rows or columns to expand the image to
the size of the screen
change the zoom
set the view to "page break preview"

Regards.

Bill Ridgeway
Computer Solutions

"Iyer" wrote in message
...
i want excell to display only the selected part of the sheet where there is
data in it and rest all should not be displayed. e.g. from a1 to aa155
should
only be displayed.

show only the required part of the sheet
 

To add to Bill's shopping list.........you can, through VBA code, restrict the
Scroll Area of the sheet.


Gord Dibben MS Excel MVP

On Tue, 25 Jul 2006 10:00:10 +0100, "Bill Ridgeway"
wrote:

You don't say why you want to have cells displayed only if the contain data.
You could -
hide whole rows or whole columns
format cells to be white on white
change the width and height of rows or columns to expand the image to
the size of the screen
change the zoom
set the view to "page break preview"

Regards.

Bill Ridgeway
Computer Solutions

"Iyer" wrote in message
...
i want excell to display only the selected part of the sheet where there is
data in it and rest all should not be displayed. e.g. from a1 to aa155
should
only be displayed.