How To Scroll In Excel?

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.

Contents

Why is my Excel sheet not scrolling?

Re: My excel spreadsheet won’t scroll down
You can normally toggle Scroll Lock off and on by hitting the Scroll Lock key on your keyboard. If you don’t have a scroll lock key on your keyboard do this…That should bring up the on-screen keyboard, click on the “scroll lock” key to toggle off that option.

How do I scroll part of an Excel spreadsheet?

Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. The column will be frozen in place, as indicated by the gray line. You can scroll across the worksheet while continuing to view the frozen column on the left.

How do I scroll text in an Excel cell?

On the main worksheet, click-drag the area where you want to place the text box. Ensure Design Mode is enabled and click Properties. Set EnterKeyBehavior, MultiLine, and WordWrap to True. Set ScrollBars to 2 – fmScrollBarsVertical.

How do I unlock scrolling in Excel?

To turn off scroll lock, execute the following step(s).

  1. Press the Scroll Lock key (Scroll Lock or ScrLk) on your keyboard.
  2. Click Start > Settings > Ease of Access > Keyboard > Use the On-Screen Keyboard (or press the Windows logo key + CTRL + O).
  3. Click the ScrLk button.

What key is Scroll Lock?

The Scroll Lock key on a laptop is often a secondary function of another key, located near the Backspace key. If a laptop uses two keys as one key, you must press the Fn key with the second key you want to use. On a laptop, the Scr Lk, Pause, and Break functions are usually part of another key and are in blue text.

Why is Excel scrolling with arrow keys?

When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet, instead of moving to the next cell. Although helpful for a user viewing a large worksheet, it’s also quite annoying for those who have mistakenly enabled this feature.

How do I unlock Scroll Lock?

Turn off Scroll Lock

  1. If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard.
  2. Click the On Screen Keyboard button to turn it on.
  3. When the on-screen keyboard appears on your screen, click the ScrLk button.

How do you scroll with the keyboard?

How to Scroll With a Laptop Keyboard

  1. Use the arrow up and arrow down keys. In the lower right side of your keyboard (usually between the letter keys and number keypad) is a set of four arrow keys.
  2. Use the page up and page down keys.
  3. Use the home and end keys.
  4. Scroll numerically.

How do you scroll down on a laptop?

Click the left button under your touch pad. It will click the arrow and make the page move down. Alternatively, you can grab the scroll bar (the gray bar between arrows) by clicking the left button, holding it, then dragging the bar up and down the page.

How do you scroll in Excel without jumping?

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.

How do I scroll using Windows keyboard?

keyboard-scroll

  1. alt-up / alt-down to scroll up or down.
  2. alt-ctrl-up / alt-ctrl-down to additionally move the cursor.

How do I scroll up?

Here’s how:

  1. Using your mouse or laptop track pad, move your cursor to the scroll bar.
  2. Then click and hold your mouse; you can now move the scroll bar up and down.
  3. Release the mouse button once you reach the place on your screen you would like to go.

What is scroll key in keyboard?

Scroll Lock is a toggling lock key on the keyboard, just like the CAPS LOCK key. Once pressed, Scroll Lock is enabled. To turn it off, simply press the Scroll Lock key again.If Scroll Lock appears, then it’s turned on. To turn it off, just press the Scroll Lock key, which sometimes appears as ScrLk on the keyboard.

How do you scroll down with two fingers?

Enable two-finger scroll via Settings in Windows 10

  1. Step 1: Navigate to Settings > Devices > Touchpad.
  2. Step 2: In the Scroll and zoom section, select the Drag two fingers to scroll option to turn on the two-finger scroll feature.

How do I scroll down on Windows 10?

How to reverse touchpad scrolling direction on Windows 10

  1. Open Settings.
  2. Click on Devices.
  3. Click on Touchpad. Important: The reverse scrolling option is only available for devices with a precision touchpad.
  4. Under the “Scroll and zoom” section, use the drop-down menu to select the Down motion scrolls down option.

How do you scroll in Excel without moving the top row?

Select the cell in the upper-left corner of the range you want to remain scrollable.
To freeze the top row or first column:

  1. From the View tab, Windows Group, click the Freeze Panes drop down arrow.
  2. Select either Freeze Top Row or Freeze First Column.
  3. Excel inserts a thin line to show you where the frozen pane begins.

Can Excel scroll without snapping to cell?

Increase the height on some rows in your spreadsheet and scroll using your mouse wheel or touch pad to see that you can stop partway through a row, and avoid snapping to the top. Drag the scroll bar to see that you can scroll with precision and you can stop anywhere you like.