Protecting worksheet
 

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

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