View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Protecting worksheet

Look at freezing the pane to keep certain rows and/or columns from scrolling
off of the screen.

Excel 2003 and earlier: Window -- Freeze Panes
Excel 2007: [View] tab, "Window Group", Freeze Panes pulldown.


"Patricia" wrote:

Hi

I have protected a worksheet but when I scroll up too far up to the top or
too far left instead of stopping there it takes me of to a different part of
the spreadsheet. Does anyone know how to stop this?

Dawn