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.