Scrolling in Excel: Options, Smooth Scrolling, Scroll Lock, Custom Scroll Bar, and Issues

Excel Scrolling Options for Vertical and Horizontal Scrolling

1. Scrolling Using the Arrow Keys

  • To scroll up, select a cell => Press the Up Arrow (↑)
  • To scroll down, select a cell => press the Down Arrow (↓)
  • Use the Right or Left arrow keys to scroll in those directions.

2. Scrolling Using the Vertical and Horizontal Scrollbars

Click and hold the left mouse button on the vertical or horizontal scroll bar, move it in the desired direction to scroll through the dataset.

Take a look at the following video for a better understanding.


3. Using the Mouse Wheel

Turn the mouse wheel inward to scroll down and outward to scroll up.


What Is Smooth Scrolling in Excel?

Smooth scrolling means scrolling the spreadsheet smoothly and gradually rather than jumping from one cell to another.

Smooth scrolling in Excel


Mimicking Smooth Scrolling in Older Versions:

Press the mouse wheel once and hover your mouse in the direction you want to scroll the worksheet. You can follow the GIF image given below.

Mimic smooth scrolling by using the scroll wheel


Scroll Lock – Scrolling with Arrow Keys Without Moving the Active Cell

How to Turn On/Off Scroll Lock Feature?

To turn on the scroll lock feature, right-click on the status bar => find the option Scroll Lock => and click on the Scroll Lock option if found unmarked.

Unmark the Scroll Lock feature

To turn the Scroll Lock off, simply unmark the command again from the status bar.

Scrolling Without Moving the Active Cell:

After you have turned on the Scroll Lock feature, if you scroll with arrow keys, you will not move from cell to cell.

Stopping the Arrow keys from scrolling in Excel

Note: You can also turn on or off the Scroll Lock feature by using the Scroll Lock key on your keyboard.

If not found on your keyboard, you can use the On-Screen keyboard of your Windows operating system.


How to Scroll One Row at a Time in Excel?

To scroll one row at a time, click the vertical scroll bar’s up and down arrows. Clicking once will scroll one row.

Dataset with built-in Vertical Scroll Bar Slider

Look at the following GIF image to see how to scroll one row at a time using a vertical scroll bar.

Scroll one Row at a time in Excel


Another way is changing the mouse settings.

To change mouse settings so that when you turn the scroll wheel, one row will be scrolled with one unit turn-

  • Go to Mouse settings from the Control Panel => Select the Change mouse settings option.

Click on the Change mouse settings option

  • The Mouse Properties window appears => Select Wheel tab => Insert 1 in The following number of lines at a time section.

Insertion 1 in the following number of lines at a time section

When you rotate the scroll wheel, you will see the effect of scrolling one row at a time.


How to Simultaneously Scroll 2 Workbooks in Excel?

  • Go to View tab => Window group => Select the View Side by Side

Select the View Side by Side feature

The Synchronous Scrolling command will be enabled automatically for both workbooks.

Opening workbooks on one screen

  • Select any cell from any workbook and scroll the mouse wheel.
Synchronous Scrolling in Excel

Click on the image for a clearer view

Note: To view and scroll the workbook files in this way, all the workbooks must be open and will not be minimized.

How to Repeat Rows When Scrolling in Excel?

Follow these steps:

  • Select row 6 => Go to the View tab => Window section => Click on the Freeze Panes drop-down => Freeze Panes.

Selection of the Freeze Panes feature

  • A gray-colored line will appear above row 6.
  • The rows above the line (rows 1-5) will repeat while scrolling.
  • Scroll down using the mouse wheel. We will get results like the following screenshot.

Repeat Rows When Scrolling in Excel

Note 1: To repeat only the first row or first column, go to View tab => Window => Click on the Freeze Panes drop-down => Freeze Top Row, or Freeze First Column.

Freezing or repeating the top row

Note 2: To freeze both a row and a column at the same time, choose the cell directly below the row and to the right of the column. Click on the “Freeze Panes” command.


How to Limit Scroll Area in Excel?

Limiting the Scroll Area in Excel means restricting scrolling to a set range. It helps you to focus on a certain part for better visibility.

There are 2 ways we can limit the scroll area in Excel.

  • Changing Worksheet Properties from the Developer Tab
  • Applying a VBA Code

Method 1 – Changing Worksheet Properties from the Developer Tab

  • Go to Developer tab => Controls => Properties.
  • The Properties window pops up => Set scroll area in the ScrollArea. The range in my case is $A$1:$F$28.
  • Click the Close (X) button to close the Properties.

Setting the limit of the scroll area

  • Your Excel sheet can no longer scroll beyond this range.

Using Developer Property command to limit scroll area


Method 2 – Applying a VBA Code

  • Go to the Developer tab => Visual Basic.

Selection of the Visual Basic command

  • Select Insert tab => Module.

Selection of the Module command

  • Then a VBA Module will be launched. Enter the following code and run the macro.
Sub Limit_Scroll_Area()
Dim mtm As Worksheet
Set mtm = ActiveSheet
mtm.ScrollArea = "$A$1: $E$25"
End Sub

Copy and Paste VBA code in the Module


Creating a Custom Scrollbar Within a Sheet to Scroll Through Large Data

Create a custom scrollbar for that particular dataset only and scroll in that specific area, not in the whole worksheet.

Overview of dataset

Follow these steps:

  • Generate a blank dataset with the same formatting and column headings.
  • From the “Scroll Bar” sheet, go to the Form Control menu and choose Developer => Insert => Scroll Bar.
  • Design the Scroll Bar and drag it to give it a vertical scrollbar shape.
Using Scroll Bar command to create scroll bar

Click here to enlarge the image

  • Right-click on the Scroll Bar and select Format Control from the Context Menu.
Selection of the Format Control feature

Click here to enlarge the image

  • In the Format Control dialog box, insert the parameter. In our case,
    • Current Value: 0
    • Minimum Value: 0
    • Maximum Value: 20 (It is 20 in this case since we display 10 rows at a time. When the user enters the value 20 for the scroll bar, rows 20-29 are displayed)
    • Cell Link: $L$1
    • Other parameters are kept default values

The Scroll Bar is linked to the L1 cell. The value of this cell changes from 0 to 20 when you scroll down the custom bar.

Format Control dialog box

Click here to enlarge the image

  • Link the data using the formula below in cell G6 (in the “Scroll Bar” sheet).
=OFFSET(B6,$L$1,0)
  • Copy this formula to the rest of the cells in the blank dataset.
AutoFill the OFFSET function

Click here to enlarge the image

Scroll and see the magic.

Using a Customized Scroll Bar to scroll vertically in Excel


What Issues You May Face While Scrolling in Excel?

Method 1 – Horizontal or Vertical Scroll Bar Not Visible

The default Scroll Bars of an Excel workbook may not always be visible. Sometimes it can be accidentally disabled in the worksheet.

  • Select File tab => Options.
  • Excel Options dialog box will pop up => Select the Advanced option => Scroll down and check both Show horizontal scroll bar and Show vertical scroll bar options under Display options for this workbook menu => OK.
  • Tthe Scroll Bars will display.

Checking both Show horizontal scroll bar and Show vertical scroll bar options


Method 2 – Mouse Wheel Zooming In or Out Instead of Scrolling

  • To disable the feature, just open the Excel Options window from the File menu and select the Advanced
  • Scroll and uncheck the “Zoom on Roll with IntelliMouse” feature => Press OK.

Uncheck the Zoom on Roll with IntelliMouse feature

This will disable the feature, and you will be able to scroll with the IntelliMouse.

Note: If the problem persists, repair your Excel app from the Control Panel or update it.

Download Practice Workbook


Scrolling in Excel: Knowledge Hub


<< Go Back to Navigation in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo