Protecting worksheet

[Patricia]

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

 

[JLatham]

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.