How to use Excel : Excel Basics – How to use the scrollbars efficiently in Excel


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.

use the scrollbars efficiently in Excel

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.

use the scrollbars efficiently in Excel

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.

use the scrollbars efficiently in Excel

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.

use the scrollbars efficiently in Excel
Note # As we discussed in our navigating the cells tutorial we can use the wheel button on the mouse to navigate through the worksheet. Place the cursor anywhere on the worksheet area. Click the wheel button. A four arrow pointer will appear. Keeping the wheel button pressed move the mouse in whichever direction you want to navigate.