I thank you for reading and hope to see you on our blog next week! You may also be interested in That's how you turn off Scroll Lock in Excel. If you are working on a smaller keyboard that does not have the F14 key, you can try to remove Scroll Lock by running this AppleScript that emulates the Shift + F14 keystroke. Depending on your settings, you may need to press the CONTROL or OPTION or COMMAND (⌘) key instead of the SHIFT key.
If F14 exists on your keyboard, but there is no Fn key, use the Shift + F14 shortcut to toggle the Scroll Lock on or off. On the Apple Extended Keyboard, press the F14 key, which is an analogue of the Scroll Lock key on a PC keyboard.
Excel for mac not working on pc monitor how to#
How to remove Scroll Lock in Excel for Mac If the address does not change and the arrow key scrolls the whole worksheet, it's safe to assume that Scroll Lock is enabled. So, how can you know that Scroll Lock is on? Press any arrow key and watch the address in the name box. Unlike Excel for Windows, Excel for Mac does not show Scroll Lock in the status bar. To close the on-screen keyboard, click the X button in the upper-right corner.
Excel for mac not working on pc monitor windows#
On Windows 7Ĭlick Start > All Programs > Accessories > Ease of Access > On-Screen Keyboard. On Windows 8.1Ĭlick Start, press Ctrl + C to display the Charms bar, then click Change PC Settings > Ease of Access > Keyboard > On Screen Keyboard slider button. If it is blue, Scroll Lock is still on.Īlternatively, you can open the virtual keyboard in the following ways: On Windows 10Ĭlick Start > Settings > Ease of Access > Keyboard, and then click the On-Screen Keyboard slider button. You'll know that Scroll Lock is disabled when the ScrLk key returns to dark-grey.
How to turn off Scroll Lock in Excel for Windows The Excel status bar only displays the Scroll Lock status, but does not control it. If a tick mark is not there, simply click the Scroll Lock to have its status appear on the status bar: To determine if it's the case, right click the status bar and see if there is a tick mark to the left of Scroll Lock. If your arrow keys scroll the whole sheet instead of moving to the next cell but the Excel status bar has no indication of Scroll Lock, most likely your status bar was customized not to display the Scroll Lock status. Among other useful things (such as page numbers average, sum and count of selected cells), the status bar shows if Scroll Lock is on: To see whether the Scroll Lock is turned on, just look at the status bar at the bottom of the Excel window. How to determine that Scroll Lock is enabled When the worksheet is scrolled, the current selection (a cell or range) does not change. However, when the Scroll Lock is enabled in Excel, arrow keys scroll the worksheet area: one row up and down or one column to the left or right. Usually, when the Scroll Lock is disabled, arrow keys move you between individual cells in any direction: up, down, left or right. Scroll Lock is the feature that controls the behavior of the arrow keys in Excel.
You have just accidentally turned Scroll Lock on, and this can be easily fixed. You are working on a spreadsheet normally when all of a sudden you notice that you cannot move from cell to cell - instead of getting to the next cell, the arrow keys scroll the whole worksheet. For example, if you want to know how to use the Reading Layout View, you just need to type in Reading keyword in the search box.Just imagine this.
You can quickly access the feature tutorials by typing in a feature name in the following search box.
0 kommentar(er)
