How to Scroll One Row at a Time in Excel (4 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes we want a smooth scroll down to work and understand the datasheet properly. However, we don’t get it directly from the device settings. But if you desire such a facility, you have to know only a few techniques to modify your device settings. In this article, we will demonstrate four quick ways to scroll one row at a time in Excel. If you are curious to know, follow us.


How to Scroll One Row at a Time in Excel: 4 Easy Methods

To demonstrate the approaches, we consider a dataset of 21 employees. We mentioned their ID in column B, their names in column C, residency area in column D, total income in column E,  and total costs in column F. So, we can say that our dataset is in the range of cells B4:F25.


1. Use of Excel’s Built-in Vertical Scroll Bar Slider

In this method, we will use Excel’s built-in Vertical Scroll Bar Slider located in the scroll bar on the right side of the Excel window. The procedure is described below as follows:

📌 Steps:

  • At first, launch the Microsoft Excel file on your device.
  • Now, move your mouse cursor to the down arrow sign located at the bottom of the Vertical Scroll Bar Slider.

Use of Excel’s Built-in Up-Down Scroll Arrow to Scroll One Row at a Time

  • Then, click once on the left key of the mouse.

  • You will see one row will scroll down.
  • Similarly, click the scroll-up arrow sign to scroll a row upward arrow at a time.

Use of Excel’s Built-in Up-Down Scroll Arrow to Scroll One Row at a Time

Thus, we can say that our method worked perfectly and we are able to scroll a row at a time.

Read More: [Solved!] Vertical Scroll Not Working in Excel


2. Changing Mouse Settings

We can modify the Control Panel of our device to scroll a row at a time. This modification will apply to all the applications on that device. The steps of this method are given below:

📌 Steps:

  • First of all, click on the Search Engine of your device and write down ‘Control Panel’ in the box.
  • After that, click on the Open option.

  • The Control Panel dialog box will appear in front of you.
  • Now, click on the Hardware and Sound option, and you will find the Mouse option inside the Device and Printer section.

Change Mouse Setting to Scroll One Row at a Time

  • Click on the Mouse option.

Change Mouse Setting to Scroll One Row at a Time

  • Besides it, write down ‘mouse’ in the Search Engine of the Control Panel. The Mouse option will be at the top of the result.
  • Then, select the Change mouse settings option.

Change Mouse Setting to Scroll One Row at a Time

  • As a result, the Mouse Properties dialog box will appear.
  • In the Wheel tab, choose the option called The following number of lines at a time in the Vertical Scrolling section, if it is not chosen yet.
  • Now, reduce the number 3 to 1 and click OK.

Change Mouse Setting to Scroll One Row at a Time

  • Close the Control Panel dialog box.
  • After that, open the file in Microsoft Excel.
  • Roll the mouse wheel, and you will see only one row is scrolled down or scrolled up at a time.

Change Mouse Setting to Scroll One Row at a Time

Finally, we can say that our method worked effectively, and we are able to scroll a row at a time.

Read More: Smooth Scrolling with Mouse Wheel in Excel


Similar Readings


3. Embedding VBA Code

Writing a VBA code can also help you to scroll one row at a time in an Excel worksheet. Our dataset is in the range of cells B4:F25. The process is explained below step by step:

📌 Steps:

  • To start the approach, go to the Developer tab and click on Visual Basic. If you don’t have that, you have to enable the Developer tab. Or You can also press ‘Alt+F11’ to open the Visual Basic Editor.

Embedding VBA Code

  • A dialog box will appear.
  • Now, in the Insert tab on that box, click Module.

Embedding VBA Code

  • Then, write down the following visual code in that empty editor box.

Sub Scroll_Down_One_Row()
    ActiveWindow.SmallScroll Down:=1
End Sub
  • Similarly, insert another Module from the Insert tab and write down the following visual code to scroll up one row.
Sub Scroll_Up_One_Row()
    ActiveWindow.SmallScroll Up:=1
End Sub
  • Close the Editor tab.
  • Now, from the View ribbon, click on Macros > View Macros.

Embedding VBA Code

  • A new dialog box called Macro will appear. Select Scroll_Down_One_Row.
  • Click on the Run button to run this code.

Embedding VBA Code to Scroll One Row at a Time

  • You will see one row will scroll down.

Scroll One Row at a Time

  • Similarly, in the Macro, select Scroll_Up_One_Row and click Run.
  • You will get one row scrolled up at a time.

At last, we can say that our visual code worked successfully and we are able to scroll one row at a time in Excel.

Read More: How to Repeat Rows in Excel When Scrolling


4. Though Keyboard Keys

The up and down button of the keyboard can also help us to scroll a row at a time. It is the easiest and most widely used process. The process is shown below:

📌 Steps:

  • First, open the Microsoft Excel file on your device.
  • Now, select any cell close to the Sheet Name Bar. To show the approach, we select cell B16.

  • Then, press the Down button once on your keyboard.

Scroll One Row at a Time Though Up and Down Key

  • A row will scroll down.

Scroll One Row at a Time Though Up and Down Key

  • Press the button further to move down into the dataset. With every press, a row will scroll at a time.
  • Similarly, you can press the Up button to scroll up a row at a time.

So, we can say that our approach worked successfully and we are able to scroll a row at a time.

Read More: How to Turn On/Off Scroll Lock in Excel


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to scroll one row at a time in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta
Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo