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.

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" <Iyer@discussions.microsoft.com> wrote in message
news:47033312-5758-446F-A3D9-FAF202F983EE@microsoft.com...
>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.

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" <info@1001solutions.co.uk>
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" <Iyer@discussions.microsoft.com> wrote in message
>news:47033312-5758-446F-A3D9-FAF202F983EE@microsoft.com...
>>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.
>