show only the required part of the sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Iyer - 25 Jul 2006 09:13 GMT

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.

Reply to this Message

davesexcel - 25 Jul 2006 09:30 GMT

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

Signature

davesexcel

Reply to this Message

Bill Ridgeway - 25 Jul 2006 10:00 GMT

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

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

Reply to this Message

Gord Dibben - 25 Jul 2006 16:35 GMT

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

Gord Dibben MS Excel MVP

>You don't say why you want to have cells displayed only if the contain data.
>You could -
[quoted text clipped - 14 lines]
>> should
>> only be displayed.

Reply to this Message