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:
- 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.
- 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.
Thus, we can say that our method worked perfectly and we are able to scroll a row at a time.
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:
- 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.
- Click on the Mouse option.
- 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.
- 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.
- 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.
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
- How to Stop Excel from Scrolling to Infinity
- [Fix]: Arrow Keys Not Moving Cells in Excel
- [Fixed!] Excel Scrolling Too Many Rows
- Horizontal Scroll Not Working in Excel
- Excel Not Scrolling with Arrow Keys
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:
- 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.
- A dialog box will appear.
- Now, in the Insert tab on that box, click Module.
- 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.
- A new dialog box called Macro will appear. Select Scroll_Down_One_Row.
- Click on the Run button to run this code.
- You will see one row will scroll down.
- 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:
- 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.
- A row will scroll down.
- 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.
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!