View Single Post
  #5   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

What do you consider a "page"? The viewable window area of a worksheet or
what would be printed on a sheet of paper?

What do you consider a "spreadsheet"? A workbook or a worksheet within a
workbook?

Maybe just hiding the rows and columns you don't to want see on each worksheet
would suffice?

Using VBA you can set the scrolling area of a worksheet so's users cannot move
out of that area.

If interested in that, post back.


Gord Dibben MS Excel MVP


On Sat, 14 Jul 2007 11:38:01 -0700, Maui Dave <Maui
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.