View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default View Only One Page

Select the row below the bottom of data range.

SHIFT + END + DownArrow.

FormatRowsHide

Same for columns to right of data range except use the RightArrow


Other Gord

On Sat, 14 Jul 2007 11:56:03 -0700, Maui Dave
wrote:

How do I select the rest of the cells to hide? There's an infinite number of
cells past my one sheet

"Gordon" wrote:

Maui Dave wrote:
How can I view only the first page of my excel spreadsheet in all the views?
I don't need to see the rest of the rows and columns I'm not using.
Thanks in advance.


Hide them.