Re: My excel spreadsheet won’t scroll down
Try this: Check and make sure your Scroll Lock is not turned on. You can normally toggle Scroll Lock off and on by hitting the Scroll Lock key on your keyboard. … That should bring up the on-screen keyboard, click on the “scroll lock” key to toggle off that option.
Besides, Where is the Scroll Lock key on a laptop?
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.
Keeping this in mind, How do I turn on scroll down in Excel? To turn off SCROLL LOCK,
click the ScrLk key
, and then close the On-Screen Keyboard.
…
Use the arrow keys to move through a worksheet.
| To scroll | Do this |
|---|---|
| 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. |
How do I unlock scroll lock in Excel?
Click Change PC Settings. Select Ease of Access > Keyboard. Click the On Screen Keyboard slider button to turn it on. When the on-screen keyboard appears on your screen, click the ScrLk button.
How do I fix scrolling in Excel?
Click the “ScrLk” key to turn off Scroll Lock. The key should no longer be blue when Scroll Lock is off. The Scroll Lock indicator on the status bar goes away when Scroll Lock is off. Again, make sure the “Scroll Lock” indicator is selected to display on the status bar so you can tell if it’s on or off.
Which is the Scroll Lock key on HP laptop?
On my new company HP Elitebook, I found you have to press ‘FN Lock’ & ‘FN’ & ‘C’ together to turn the scroll lock on and off. Unfortunately trial and error was the only way to solve this. Just use Fn + C (no need for Fn lock). That’ll toggle it.
How do I use the Scroll Lock key on my 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.
Why are my up and down arrow keys not working in Excel?
One of the common reasons why the arrow keys don’t work in Excel is because you’ve enabled the scroll lock feature on your computer. For as long as it remains enabled, the keys won’t do what they’re supposed to do. … Simply press the scroll lock button on your keyboard and the lock will be disabled.
Why can’t I see the bottom scroll bar in Excel?
Click the File tab. Click Options, and then click the Advanced category. Under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box to hide or display the scroll bars.
How do I turn off scroll lock on my keyboard?
Scroll lock is one of the more esoteric settings on a computer keyboard today. It’s often the third light on a keyboard, represented by a down arrow with a line under it on the keyboard. Turn the scroll lock light off by hitting the scroll lock button to toggle scroll lock mode itself off.
How do you stop Excel from scrolling past data?
Press the Ctrl and Shift keys while pressing the down arrow to select all rows beneath. Select Format » Row » Hide to hide them all.
How do I scroll on my HP laptop?
To scroll a window, a screen, or a list, place two fingers on the TouchPad, then swipe them from side to side or up and down. Lift your fingers to stop scrolling.
How do I scroll lock on HP probook?
Please use FN + C for scroll lock to enable or disable.
Why are my up and down keys not working?
On a Windows computer, to toggle scroll lock on and off, press the Scroll Lock key. On most keyboards, it’s located in the control keys section of the keyboard, above the arrow keys or right of the function keys. … If that does not turn off scroll lock, try pressing Command + F14 .
Why is my keyboard arrows not working?
How to fix malfunctioning arrow keys with Scroll Lock? Check whether your SCROLL LOCK is ON. Just turn it off by pressing on the Scroll Lock button key on your keyboard!
How do I get the bottom toolbar back in Excel?
How to show ribbon in Excel
- Press the ribbon shortcut Ctrl + F1.
- Double-click on any ribbon tab to make the entire ribbon visible again.
- Right-click any ribbon tab and clear the check mark next to Collapse the Ribbon in Excel 2019 – 2013 or Minimize the Ribbon in Excel 2010 and 2007.
- Pin the ribbon.
Why is my scroll bar not showing?
Scroll bars may disappear when a page element that holds content expands to accommodate excess content. … Clicking the browser window’s “Maximize” button will expand the window width to the monitor’s width, which causes the horizontal scroll bar to disappear.
How do I restore my scroll bar?
In Word
- Click on the File menu then Options.
- Select Advanced from the sidebar.
- Scroll to the section for Display.
- Ensure that the Show horizontal scroll bar and Show vertical scroll bar options are selected.
- Click OK.
How do you unlock your keyboard?
How to Fix a Keyboard That’s Locked
- Restart your computer. …
- Turn off Filter Keys. …
- Try your keyboard with a different computer. …
- If using a wireless keyboard, replace the batteries. …
- Clean your keyboard. …
- Check your keyboard for physical damage. …
- Check your keyboard connection. …
- Update or reinstall the device drivers.
How do you unlock the arrow keys on a keyboard?
On a Windows computer, to toggle scroll lock on and off, press the Scroll Lock key. On most keyboards, it’s located in the control keys section of the keyboard, above the arrow keys or right of the function keys. On a Mac computer, to toggle scroll lock on and off, press the F14 or the Shift + F14 key combination.
Where is Scroll Lock on laptop HP?
Toggle Scroll Lock on HP laptops
On an HP laptop, press the Fn + C key combination to turn Scroll Lock on and off.
Why does excel scroll past data?
Excel thinks that since you have taken the time to format cell A200 that cell must be important to you and you are just waiting to input some data into it and therefore it still gives you the ability to move swiftly to it by using the scroll bar.
How do you stop Excel from creating infinite rows?
Press Ctrl+Shift+down to select all the rows that already contain data. (
DO NOT select the whole column by selecting from the top)
- Press and hold Control and the press the right arrow. So Ctrl+Right.
- Then press Ctrl-Down.
- Then press Delete.
- Save.