Excel because that cg-tower.com 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More...Less

There are different ways come scroll with a worksheet. You can use the arrow keys, the role bars, or the mouse to move in between cells and also to move conveniently to different locations of the worksheet.

You are watching: To move the active cell up one row, press

In Excel, you can take advantage of raised scroll speeds, straightforward scrolling come the finish of ranges, and ScreenTips the let you understand where you space in the worksheet. Friend can also use the mouse to scroll in dialog crate that have actually drop-down lists v scroll bars.

Use the arrow keys to relocate through a worksheet

To move between cells ~ above a worksheet, click any kind of cell or use the arrowhead keys. Once you relocate to a cell, it i do not care the active cell.

To scroll

Do this

To the start and also end of ranges

Press CTRL+an arrow key to role to the start and end that each selection in a column or row prior to stopping at the finish of the worksheet.

To scroll to the start and end that each range while picking the ranges prior to stopping in ~ the finish of the worksheet, press CTRL+SHIFT+an arrowhead key.

One row up or down

Press scroll LOCK, and also then usage the up ARROW crucial or under ARROW an essential to role one heat up or down.

One tower left or right

Press role LOCK, and also then usage the LEFT ARROW vital or best ARROW vital to scroll one pillar left or right.

One window up or down

Press web page UP or page DOWN.

One home window left or right

Press role LOCK, and also then host down CTRL while you push the LEFT arrowhead or RIGHT arrow key.

A large distance

Press role LOCK, and also then simultaneously hold down CTRL and an arrow crucial to quickly move through large areas of her worksheet.


Note: When role LOCK is on, Scroll Lock is presented on the status bar in Excel. Pushing an arrow vital while role LOCK is on will scroll one row up or under or one pillar left or right. To usage the arrow keys to move in between cells, you need to turn scroll LOCK off. To execute that, push the scroll Lock crucial (labeled as ScrLk) on her keyboard. If your key-board doesn"t include this key, you can turn turn off SCROLL LOCK by making use of the On-Screen Keyboard. To open the On-Screen Keyboard, click the Start button on her Windows desktop and kind On-Screen Keyboard. To turn off role LOCK, click the ScrLk key, and also then close the On-Screen Keyboard.


Use the role bars to relocate through a worksheet

If you carry out not watch the scroll bars, do the complying with to screen them:

Click File > Options.

In Excel 2007, click the cg-tower.com Office Button

*
, and then click Excel Options.

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

The adhering to table explains different methods for using the scroll bars to move through a worksheet.

To scroll

Do this

One heat up or down

Click the scroll arrows

*
or
*
on the vertical scroll bar to relocate the sheet one heat up or down.

One tower left or right

Click the scroll arrows

*
or
*
top top the horizontal role bar to move the paper one shaft to the left or right.

Scroll v a worksheet with boosted scroll speed

While scrolling, host down the mouse at the farthest finish of the display for more than 10 secs to increase the scrolling speed.

Moving the mouse in opposing direction slows under the role speed.

One window up or down

Click above or listed below the scroll box top top the vertical role bar.

One home window left or right

Click come the left or appropriate of the scroll crate top top the horizontal scroll bar.

A big distance

Hold down transition while dragging the scroll box .


Notes: 

When you use the scroll boxes to relocate through a worksheet, Excel screens a ScreenTip to show row number or column letters (or numbers, if the R1C1 reference layout is stated for the workbook) so that you recognize where you are in the worksheet.

The dimension of a role box suggests the proportional quantity of the offered area the the sheet that is visible in the window. The place of a role box suggests the relative ar of the clearly shows area within the worksheet.


Scroll and zoom by making use of the mouse

Some mouse devices and other pointing devices, such as the cg-tower.com IntelliMouse pointing device, have integrated scrolling and also zooming capabilities that you have the right to use to move around and zoom in or the end on your worksheet or chart sheet. Girlfriend can also use the computer mouse to scroll in dialog box that have drop-down lists with scroll bars. For an ext information, view the indict for her pointing device.

To

Do this

Scroll increase or under a couple of rows at a time

Rotate the wheel forward or back.

Scroll left or right in Windows

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

Scroll with a worksheet with boosted scroll speed

While scrolling, organize down the computer mouse at the farthest finish of the display for an ext than 10 secs to rise the scrolling speed.

Moving the computer mouse in the opposite direction slows down the role speed.

Pan through a worksheet

Hold down the wheel button, and drag the reminder away indigenous the origin mark

*
in any type of direction the you desire to scroll. To speed up scrolling, move the pointer away from the beginning mark. To slow-moving down scrolling, move the guideline closer to the origin mark.

Pan with a worksheet automatically

Click the wheel button, and also then relocate the computer mouse in the direction that you want to scroll. To speed up scrolling, relocate the tip away indigenous the origin mark. To slow-moving down scrolling, move the reminder closer come the beginning mark. To avoid automatic scrolling, click any kind of mouse button.

Zoom in or out

Hold down CTRL if you rotate the IntelliMouse wheel forward or back. The portion of the zoomed worksheet is shown on the standing bar.

Show information in outlines

Point come a cell the summarizes data in the outline, and also then host down shift while you turn the wheel forward.

Hide information in outlines

Point to any kind of cell that consists of detail data, and also then organize down shift while you revolve the wheel back.

See more: Impossible Quiz Deal Or No Deal, Deal Or No Deal

Need an ext help?

You can constantly ask an professional in the Excel technology Community or acquire cg-tower.com in the answers community.