IT Новости
27 просмотров
Рейтинг статьи
1 звезда2 звезды3 звезды4 звезды5 звезд

Excel scroll lock

Отключение режима SCROLL LOCK

Примечание: Мы стараемся как можно оперативнее обеспечивать вас актуальными справочными материалами на вашем языке. Эта страница переведена автоматически, поэтому ее текст может содержать неточности и грамматические ошибки. Для нас важно, чтобы эта статья была вам полезна. Просим вас уделить пару секунд и сообщить, помогла ли она вам, с помощью кнопок внизу страницы. Для удобства также приводим ссылку на оригинал (на английском языке).

Чтобы отключить блокировку прокрутки, нажмите клавишу Scroll Lock (часто обозначенную как ScrLk) на клавиатуре. Если на компьютере нет клавиши SCROLL LOCK, выполните одно из следующих действий:

В Windows 10

Если на вашей клавиатуре нет клавиши SCROLL LOCK, на компьютере нажмите кнопку Пуск _гт_ Параметры _гт_ специальные возможности клавиатуры_гт_ доступа .

Нажмите кнопку экранНая клавиатура , чтобы включить ее.

Когда появится экранная клавиатура, нажмите кнопку ScrLk.

Совет: Чтобы быстро открыть экранную клавиатуру в Windows 10, нажмите кнопку Windows. Начните вводить Экранная клавиатура в поле поиска. В списке Поиск, который выводится над полем поиска, щелкните результат поиска Экранная клавиатура. Когда появится экранная клавиатура, нажмите кнопку ScrLk .

В Windows 8.1

Если на клавиатуре нет клавиши SCROLL LOCK, на компьютере нажмите кнопку Пуск , а затем нажмите клавиши CTRL + C, чтобы отобразить панель чудо-кнопок.

Нажмите кнопку Изменение параметров компьютера.

Выберите Специальные возможности > Клавиатура.

Нажмите кнопку ползунок на экранНой клавиатуре , чтобы включить ее.

Когда появится экранная клавиатура, нажмите кнопку ScrLk.

В Windows 7

Если на клавиатуре нет клавиши SCROLL LOCK, нажмите кнопку Пуск > Все программы > Стандартные Специальные возможности > Клавиатура.

Когда появится экранная клавиатура, нажмите кнопку slk.

Примечание: Чтобы закрыть экранную клавиатуру, щелкните значок X в правом верхнем углу экранной клавиатуры.

Устранение неполадок с режимом SCROLL LOCK

Определить, что режим SCROLL LOCK включен, можно по надписи Scroll Lock в строке состояния Excel.

Если похоже, что режим SCROLL LOCK включен, однако надпись Scroll Lock в строке состояния Excel отсутствует, возможно, строка состояния настроена таким образом, чтобы не отображать состояние этого режима. Чтобы определить, так ли это, щелкните строку состояния Excel правой кнопкой мыши. Найдите флажок слева от параметра Scroll Lock. Если он не установлен, то при включенном режиме SCROLL LOCK в строке состояния Excel не будет отображаться надпись Scroll Lock. Чтобы она отображалась, просто установите флажок.

How to turn off Scroll Lock in Excel

Just imagine this. 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. Don’t panic, your Excel is not broken. You have just accidentally turned Scroll Lock on, and this can be easily fixed.

What is Scroll Lock in Excel?

Scroll Lock is the feature that controls the behavior of the arrow keys in Excel.

Usually, when the Scroll Lock is disabled, arrow keys move you between individual cells in any direction: up, down, left or right.

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. When the worksheet is scrolled, the current selection (a cell or range) does not change.

How to determine that Scroll Lock is enabled

To see whether the Scroll Lock is turned on, just look at the status bar at the bottom of the Excel window. Among other useful things (such as page numbers; average, sum and count of selected cells), the status bar shows if Scroll Lock is on:

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. 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 a tick mark is not there, simply click the Scroll Lock to have its status appear on the status bar:

How to turn off Scroll Lock in Excel for Windows

Much like Num Lock and Caps Lock, the Scroll Lock feature is a toggle, meaning it can be turned on and off by pressing the Scroll Lock key.

Disable scroll lock in Excel using the keyboard

If your keyboard has a key labeled as Scroll Lock or ScrLk key, just press it to turn Scroll Lock off. Done 🙂

Читать еще:  Как написать дробь в excel

As soon as you do this, Scroll Lock will disappear from the status bar and your arrows keys will move from cell to cell normally.

Remove scroll lock in Excel using on-screen keyboard

If you don’t have the Scroll Lock key or it does not work for some reason, you can «unlock» Scroll Lock in Excel by using the on-screen keyboard.

The fastest way to turn off Screen Lock in Excel is this:

  1. Click the Windows button and start typing «on-screen keyboard» in the search box. Usually, it is sufficient to type the first two characters for the On-Screen Keyboard app to appear at the top of the search results.
  2. Click the On-Screen Keyboard app to run it.
  3. The virtual keyboard will show up, and you click the ScrLk key to remove Scroll Lock.

You’ll know that Scroll Lock is disabled when the ScrLk key returns to dark-grey. If it is blue, Scroll Lock is still on.

Alternatively, you can open the virtual keyboard in the following ways:

On Windows 10

Click Start > Settings > Ease of Access > Keyboard, and then click the On-Screen Keyboard slider button.

On Windows 8.1

Click Start, press Ctrl + C to display the Charms bar, then click Change PC Settings > Ease of Access > Keyboard > On Screen Keyboard slider button.

On Windows 7

Click Start > All Programs > Accessories > Ease of Access > On-Screen Keyboard.

To close the on-screen keyboard, click the X button in the upper-right corner.

Scroll Lock in Excel for Mac

Unlike Excel for Windows, Excel for Mac does not show Scroll Lock in the status bar. So, how can you know that Scroll Lock is on? Press any arrow key and watch the address in the name box. If the address does not change and the arrow key scrolls the whole worksheet, it’s safe to assume that Scroll Lock is enabled.

How to remove Scroll Lock in Excel for Mac

On the Apple Extended Keyboard, press the F14 key, which is an analogue of the Scroll Lock key on a PC keyboard.

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. Depending on your settings, you may need to press the CONTROL or OPTION or COMMAND (⌘) key instead of the SHIFT key.

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.

That’s how you turn off Scroll Lock in Excel. I thank you for reading and hope to see you on our blog next week!

How to disable Scroll Lock in Excel

Your report is due in an hour. You’re working along in Excel, things are going fine, when suddenly you notice that you can no longer move around properly. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving about. WTF?!

Before you panic and call support to tell them Excel is broken, check to see if Scroll Lock has been accidentally enabled.

What is Scroll Lock?

Usually, the arrow keys will move you one cell at a time in whatever direction you wish. However, when Scroll Lock is enabled, the worksheet is «scrolled» instead. The up and down arrow keys scroll one row up and down, and the right and left arrow keys scroll one column right and left. The active cell never changes.

If you don’t understand what’s going on, this can be quite distressing 🙂

Fortunately, the Scroll Lock setting is a toggle, much like Caps Lock. If you have a Scroll Lock key on your keyboard, just press it toggle Scroll Lock off. Done.

No key for Scroll Lock?

Unfortunately, it’s harder to disable Scroll Lock if your keyboard doesn’t have a Scroll Lock key. How can you press a key you don’t have?

The «trick» is to figure out how to send the equivalent of the Scroll Lock keystroke to Excel. The rest of this article explains how to do that on both Mac and Windows.

Читать еще:  Как вставить файл в таблицу excel

Is Scroll Lock really on?

First, make sure Scroll Lock is really enabled. You can do this by working with the status bar, the name for the bottom edge of the Excel Window, which displays various information about the state of the current worksheet.

On Windows, the status bar will display Scroll Lock if Scroll Lock is toggled on, and if the Scroll Lock status is enabled in the status bar. If Scroll Lock status is not enabled in the status bar, it might be toggled on and you’ll never see it.

Right click the status bar to make sure Scroll Lock status is enabled:

The Scroll Lock setting here doesn’t control Scroll Lock, it only displays Scroll Lock status.

Once you make sure that the Scroll Lock status is on, look for the Scroll lock message in the lower left.

Yes, Scroll Lock is turned on.

On a Mac, as far as I know, Scroll Lock status will not appear in the status bar of Excel 2011. (I haven’t checked Excel 2016 yet). The only way I know to verify the Scroll Lock state is to use the arrow keys and observe behavior. Try moving around with the arrow keys and watch the address in the name box (directly left of the formula bar). If the address doesn’t change change, Scroll Lock is probably turned on.

Mac Excel 2011 doesn’t show scroll lock status anywhere.

How to disable Scroll Lock on Windows

If you’re using a full keyboard in Windows – one that has a Scroll Lock key – simply press the key to disable. You should see the Scroll Lock message disappear from the status bar and then be able to move around normally.

If your keyboard does not have a Scroll Lock key, you can access a virtual keyboard in Windows via Start > All Programs > Accessories > Ease of Access > On-Screen Keyboard.

The On-Screen Keyboard in Windows, Scroll Lock key in white

Once the keyboard is displayed, make sure Excel is the active application and click the ScrLk key. That should do it.

How to disable Scroll Lock on a Mac

The official Microsoft shortcut for Scroll Lock is Shift + F14. If you have an extended keyboard with an F14 key, try that first.

A Mac Extended Keyboard has an F14 key (click to enlarge)

If you have a Macbook Pro, or other machine with a smaller keyboard that does not have extended keys, you’ll have to go a little deeper.

You’d think that you could go System Preferences > Keyboard, then enable an extended virtual keyboard, then use that to press F14. But, after an hour so of fiddling around, I couldn’t get it to work, and I’m not sure it can be done.

It seems that the Mac is «aware» of the keyboard currently attached, and uses this information to display the virtual keyboard. If you know a way to enable an extended virtual keyboard (on a Mac that doesn’t have one attached), please let me know.

Virtual Keyboard, a commercial freeware utility by Corallo Software (14 day trial) seems to work, but I did very little testing.

AppleScript to the rescue

On Macs, AppleScript is a built-in scripting language that can be used to automate applications and other general tasks. One of the things you can do with AppleScript is send keystrokes to an application.

While researching this problem, I ran into a nice AppleScript by Damien Clark here. However, I couldn’t get the script work like I expected. I could enable Scroll Lock with the script. But when I ran the script again, Scroll Lock wasn’t disabled.

At least not without checking the «use all F1, F2, etc keys as standard function keys setting» checkbox in the Mac’s keyboard preferences. which made the process pretty confusing.

So, after a bit more investigation (read: a few hours flailing about), I adapted the script to send the equivalent of fn + shift + F14, with a small delay. This works on my 2015 Macbook Pro reliably to turn Scroll Lock on and off.

To use this script, run the AppleScript Editor, create a new file, and paste in the code above. Then compile the script (Command + K), and run it (play button, or Command + R).

Читать еще:  Как убрать промежуточные итоги в excel

If Scroll Lock is currently on, it should be disabled.

Caution: if Scroll Lock is not currently enabled, it will be enabled, so you’ll need to run the script again to toggle it off again.

How to Turn Scroll Lock On (or Off) in Excel for Windows or Mac

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

… if you haven’t accidentally turned it on, you have no idea how frustrating this single key can be!

Don’t get me wrong:

When you want to use scroll lock, it’s great. But when you don’t, it can be infuriating.

Not familiar with scroll lock?

It has a simple function: the arrow keys scroll your spreadsheet without changing the selected cell.

It’s great when you’re skimming through data.

But when you’re used to using the arrow keys to change your selection, it’s downright maddening.

Here’s what to do to fix the problem…

*This tutorial is for Excel 2019 for Windows. Got a different version? No problem, you can still follow the exact same steps.

Table of Contents

Disabling scroll lock in Windows

Many Windows keyboards have a scroll lock button, and disabling scroll lock is as easy as hitting that button. It might be labeled “Scroll Lock” or “ScrLk.”

Your keyboard also probably has a light that turns on when scroll lock is engaged. Hit that button, and if the light turns off, you’ve disabled scroll lock.

But what if you don’t have a scroll lock button?

Then you’ll need to use the on-screen keyboard.

In Windows, right-click on the Start menu, then select Run.

You can also press the Windows key on your keyboard + R.

This will bring up the Run dialog.

From here, just type in “osk” and hit Enter.

Then click the ScrLk button on the on-screen keyboard.

You’ll know that scroll lock is on if the key is blue. When it returns to grey, it’s off.

If you’re using Windows 8, you can also use the Charms bar to search for “run” and launch the run dialog from there.

Pro tip: scroll lock status in Excel

If your keyboard doesn’t have a scroll lock light, or you’re not sure if scroll lock is on, look at Excel’s status bar.

When scroll lock is on, you’ll see “Scroll Lock” displayed in the status bar. When it’s off, you won’t see any indication.

Disabling scroll lock in macOS

Disabling scroll lock on a Mac is just as easy—but only if you have a full-size keyboard.

On an extended keyboard, hit the F14 button to turn scroll lock on and off. You may have to hit Shift + F14, depending on your settings. (If that doesn’t work, try Command + F14).

However, if you’re working on a laptop or a smaller keyboard, you don’t have an F14 button. And that causes a lot of problems.

After quite a bit of research, we’ve found what is probably the best solution. It uses AppleScript to send a command to Excel via your keyboard.

set returnedItems to (display dialog “Press OK to send scroll lock keypress to Microsoft Excel or press Quit” with title “Excel Scroll-lock Fix” buttons <“Quit”, “OK”>default button 2)
set buttonPressed to the button returned of returnedItems

if buttonPressed is “OK” then
tell application “Microsoft Excel”
end tell
tell application “System Events”
key code 107 using
end tell
display dialog “Scroll Lock key sent to Microsoft Excel” with title “Mac Excel Scroll-lock Fix” buttons <“OK”>
end if

Open a new text document, then copy and paste the above script into the document. Save it as “Excel-ScrLk.applescript” in your Applications folder.

Now, to activate (or deactivate) scroll lock, make sure Excel is open and double-click the Excel-ScrLk icon. This will open the script. Click the Run button at the top of the window.

You’ll then be asked if you want to send the scroll lock command. Click OK.

After that, scroll lock will be activated or deactivated, depending on its state before you ran the script.

Head to Excel and push a few arrow keys to see how it behaves.

This whole process seems a bit complicated, but once you’ve done it a few times, it becomes very easy and fast.

Ссылка на основную публикацию
ВсеИнструменты 220 Вольт