Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

There are different ways to scroll through a worksheet. You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet.

In Excel, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and ScreenTips that let you know where you are in the worksheet. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars.

To move between cells on a worksheet, click any cell or use the arrow keys. When you move to a cell, it becomes the active cell.

To scroll

Do this

To the start and end of ranges

Press CTRL+an arrow key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet.

To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key.

One row up or down

Press SCROLL LOCK, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.

One column left or right

Press SCROLL LOCK, and then use the LEFT ARROW key or RIGHT ARROW key to scroll one column left or right.

One window up or down

Press PAGE UP or PAGE DOWN.

One window left or right

Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key.

A large distance

Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.

Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard. If your keyboard doesn't include this key, you can turn off SCROLL LOCK by using the On-Screen Keyboard. To open the On-Screen Keyboard, click the Start button on your Windows desktop and type On-Screen Keyboard. To turn off SCROLL LOCK, click the ScrLk key, and then close the On-Screen Keyboard.

If you do not see the scroll bars, do the following to display them:

  1. Click File > Options.

    In Excel 2007, click the Microsoft Office Button Office button image, and then click Excel Options.

  2. Click Advanced, and then under Display options for this workbook, make sure that the Show horizontal scroll bar and the Show vertical scroll bar check boxes are selected, and then click OK.

The following table describes different ways for using the scroll bars to move through a worksheet.

To scroll

Do this

One row up or down

Click the scroll arrows button image or button image on the vertical scroll bar to move the sheet one row up or down.

One column left or right

Click the scroll arrows button image or button image on the horizontal scroll bar to move the sheet one column to the left or right.

Scroll through a worksheet with increased scroll speed

While scrolling, hold down the mouse at the farthest end of the screen for more than 10 seconds to increase the scrolling speed.

Moving the mouse in the opposite direction slows down the scroll speed.

One window up or down

Click above or below the scroll bar button image on the vertical scroll bar.

One window left or right

Click to the left or right of the scroll bar button image on the horizontal scroll bar.

A large distance

Hold down SHIFT while dragging the scroll bar button image.

Notes: 

  • When you use the scroll bars to move through a worksheet, Excel displays a ScreenTip to indicate row numbers or column letters (or numbers, if the R1C1 reference style is specified for the workbook) so that you know where you are in the worksheet.

  • The size of a scroll bar indicates the proportional amount of the used area of the sheet that is visible in the window. The position of a scroll bar indicates the relative location of the visible area within the worksheet.

 To view all your data, you can scroll smoothly through a worksheet without snapping to the top-left cell in your display. Even if you stop scrolling partly through a row or column, Excel doesn’t advance any further, which is of particular benefit for large cells. These improvements work with a mouse, mouse wheel, touchpad, touch screen, or scroll bar drag.

By default, scrolling is based on the height of one Excel row. If you have a precision mouse or touchpad, you can scroll one pixel at a time. However, if your Windows mouse option is set to move one line of text for each click of the mouse wheel, it supersedes the Excel behavior.

Tip: If you do need to snap to the top-left cell, use the arrow buttons on the scroll bar, or use the arrow keys on the keyboard to change your cell selection until you get the sheet positioned the way you want.

Some mouse devices and other pointing devices, such as the Microsoft IntelliMouse pointing device, have built-in scrolling and zooming capabilities that you can use to move around and zoom in or out on your worksheet or chart sheet. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars. For more information, see the instructions for your pointing device.

To

Do this

Scroll up or down a few rows at a time

Rotate the wheel forward or back.

Scroll left or right in Windows

Press and hold CTRL+SHIFT and rotate the wheel forward or backward.

Scroll through a worksheet with increased scroll speed

While scrolling, hold down the mouse at the farthest end of the screen for more than 10 seconds to increase the scrolling speed.

Moving the mouse in the opposite direction slows down the scroll speed.

Pan through a worksheet

Hold down the wheel button, and drag the pointer away from the origin mark origin mark in any direction that you want to scroll. To speed up scrolling, move the pointer away from the origin mark. To slow down scrolling, move the pointer closer to the origin mark.

Pan through a worksheet automatically

Click the wheel button, and then move the mouse in the direction that you want to scroll. To speed up scrolling, move the pointer away from the origin mark. To slow down scrolling, move the pointer closer to the origin mark. To stop automatic scrolling, click any mouse button.

Zoom in or out

Hold down CTRL while you rotate the IntelliMouse wheel forward or back. The percentage of the zoomed worksheet is displayed on the status bar.

Show detail in outlines

Point to a cell that summarizes data in the outline, and then hold down SHIFT while you rotate the wheel forward.

Hide detail in outlines

Point to any cell that contains detail data, and then hold down SHIFT while you rotate the wheel back.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×