What are Scrollbars in Excel?
Scrollbars are the two bars placed at the bottom and the right edge of the worksheet. These bars or more precisely – these scrollbars can be used to bring a new portion of the worksheet in the screen view. The scrollbar at the bottom of the worksheet is called the horizontal scrollbar and is used to navigate back and forth through the columns of the worksheet and change the visible columns. The scrollbar at the right edge of the worksheet is called the vertical scrollbar and is used to navigate up and down through the rows of the worksheet and change the visible rows.
Scroll arrows – Scroll arrows are the buttons located at both the ends of the two scrollbars. These buttons can be used to scroll the worksheet one column at a time or one row at a time. Press the appropriate scroll arrow to navigate one column at a time or one row at a time in the desired direction.
To the immediate left of the horizontal scrollbar there is a button with three vertical dots. Drag this button to left or right to widen or shorten the horizontal scrollbar.
Move around the sheet quickly –
- Hold down the shift key
- Click somewhere on the scrollbar
- Move your mouse in the desired direction
The scrollbar becomes very narrow and we can navigate really quickly through the sheet. A screen tip appears which shows us the rows and columns that we are scrolling through right now.