Navigate Without Losing Your Place in MS Excel

When you move around in your worksheet, you most likely use the arrow keys or the Page Up and Page Down keys. Those keys get the job done, but you are selecting a different cell as you move around.

To find out how to scroll and keep the current cell selected, follow the steps below:

1. Press the Scroll Lock key
    
2. Use the arrow or Page Up/Down keys.

When you are finished, be sure to press the Scroll Lock key again to toggle this functionality off.

Follow these steps to quickly return to your original cell:

1. Use the Edit | Go To command (or Ctrl + G).
    
2. Choose the Special button (or Alt + S), then Cancel (or Escape).

When Excel pulls up the Go To | Special dialog box, it will reposition your worksheet back to the original selected cell that was active before you pressed Scroll Lock and started your move about the worksheet.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!