Protecting worksheet

  • Thread starter Thread starter Patricia
  • Start date Start date
P

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
 
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.
 
Back
Top