Scroll through Worksheet without changing Active Cell in Excel 2013

When you use the up arrow or the down arrow key within the excel sheet , the active cell would also change . There are times when you don’t want the active cell to change when using the keyboard to navigate.

How to Scroll through the Worksheet in Microsoft Excel 2013 without changing the active cell ?

In this case , use the Scroll Lock key .

Turn on the Scroll lock key in the keyboard and perform the navigation using the navigation keys within the worksheet.

How to return to the original active cell ?

Use the shortcut key Ctrl + backspace to navigate to the original active cell.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


Interesting BlogPosts to read

How to print title on every page in Microsoft Excel?
Most of the time we might end up having a long workbook with huge amount of data and they have lot o...
How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...