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.
>