show only the required part of the sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
To add to Bill's shopping list.........you can, through VBA code, restrict the
Scroll Area of the sheet.


Gord Dibben MS Excel MVP
 
Back
Top