When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet in that direction, 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. The following sections give instructions for turning off the scroll lock feature.
Excel for Mac 2011 Step 1: Quit all programs and close all windows. On the Apple menu, click Force Quit. Select an application in the 'Force Quit Applications' window. Note You cannot quit Finder. Click Force Quit. Repeat steps A through C until you exit all active applications. Step 2: Remove Excel preferences. Quit all Microsoft Office for Mac programs. If your Paste Special option is missing, look here. Paste Special allows you to paste using the formatting of your choice. Paste Special option is missing or not working in Microsoft Office - Office Microsoft. The 'close' button would not work if you were editing a sheet name. The ribbon tab for shapes would appear if you copied a cell and then pasted as 'linked cells'. Fixed some crashes and minor bugs.
Turning off scroll lock with the keyboard key
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 key or the Shift + F14 key combination. If that does not turn off scroll lock, try pressing Command + F14.
Microsoft Excel Mac Buttons Not Working On Mac
Turning off scroll lock without the keyboard key
Select the operating system on your computer from the list below, and follow the instructions.
Windows 10 users
- Press the Windows key.
- Type on-screen keyboard and press Enter.
- When the on-screen keyboard appears, click the ScrLk button on the right side of the on-screen keyboard.
To turn on Scroll Lock again, repeat the steps above.
Windows 8 users
- Navigate to your Start Screen.
- Type on-screen keyboard and press Enter.
- You should see a full keyboard appear. If you see a small bar with a few keys, click General.
- When the on-screen keyboard appears, click the ScrLk button on the right side of the on-screen keyboard.
To turn on Scroll Lock again, repeat the steps above.
Windows XP, Vista, and 7 users
Microsoft Office Not Working
- Click Start in the lower-left corner of your desktop.
- Locate the search bar in the window that appears.
- Type on-screen keyboard and press Enter.
- When the on-screen keyboard appears, click the ScrLk or Slk button.
To turn on Scroll Lock again, repeat the steps above.
macOS users
If you do not have an extended keyboard, and therefore no F14 key, for your Mac computer, you need to use an AppleScript to turn off Scroll Lock.
Microsoft Excel Mac Buttons Not Working Free
- Open a blank text file in your preferred text editor.
- Copy and paste the following script code into the text editor.
Excel Not Working Windows 10
In the script below, some lines wrap around to the next line. In your AppleScript document, these should be written as one long line.
- Save the text file with a file name of Excel-ScrollLock.applescript and save it to a location where you can easily access it.
- Open Microsoft Excel.
- Double-click the Excel-ScrollLock.applescript file, opening an AppleScript window. Click the Run button near the top left of the AppleScript window.
- In the Excel Scroll-lock Fix prompt window, click OK.
To turn on Scroll Lock again, repeat the steps above.
Why Is Microsoft Not Working
Additional information
Microsoft Excel Mac Buttons Not Working Windows 10
- See the Excel and scroll lock definition for additional information about this term and related links.