Show
Untuk mengaktifkan dan menonaktifkan fungsi ini, tekan salah satu tombolnya masing-masing (baik tombol Scroll Lock, Num Lock, atau tombol Caps Lock) satu kali di keyboard Anda. Menekan tombol akan mengaktifkan fitur keyboard itu. Misalnya, jika Num Lock dihidupkan dan Anda menekan tombol Num Lock, Num Lock akan dimatikan, begitu pula sebaliknya. Tip Jika Anda mengalami kesulitan menemukan tombol Scroll Lock, Num Lock, atau Caps Lock, lihat definisi keyboard kami. Bagaimana jika tombol-tombol itu rusak atau hilang dari keyboard saya?Beberapa keyboard yang lebih kecil, seperti yang ada di laptop, tidak memiliki tombol Num Lock. Dalam kasus lain, kunci Num Lock rusak, tidak ada, atau pengguna tidak dapat menemukannya. Untungnya ada fitur di Windows bernama Keyboard di Layar yang membantu Anda. Gulir ke bawah hingga Anda menemukan versi Windows Anda, lalu ikuti petunjuknya. Windows 10Catatan Keyboard Layar Windows 10 berbeda dari versi sebelumnya dengan keypad numerik hilang dan tombol Num Lock diaktifkan secara default. Anda masih dapat mengaktifkan Scroll Lock dan Caps Lock, tetapi Anda harus mengaktifkan tombol Num Lock untuk menggunakannya. Beralih Caps Lock dan Scroll Lock
Beralih Num Lock
Windows Vista, 7, dan 8
Tip Saat Scroll Lock (ScrLk), Num Lock (NumLock), atau Caps Lock (Membela timnas) aktif, kunci mereka akan berwarna biru atau putih (seperti yang ditunjukkan di atas dengan NumLock kunci). Pengguna Windows XP
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. 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. 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: Note. The Excel status bar only displays the Scroll Lock status, but does not control it. 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 keyboardIf your keyboard has a key labeled as Scroll Lock or ScrLk
key, just press it to turn Scroll Lock off. Done :) 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. Turn off Scroll Lock on Dell laptopsOn some Dell laptops, you can use the Fn + S shortcut to toggle Scroll Lock on and off. Toggle Scroll Lock on HP laptopsOn an HP laptop, press the Fn + C key combination to turn Scroll Lock on and off. Remove scroll lock in Excel using on-screen keyboardIf you don't have the Scroll Lock key and none of the above mentioned key combinations work for you, 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:
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 10Click Start > Settings > Ease of Access > Keyboard, and then click the On-Screen Keyboard slider button. On Windows 8.1Click 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 7Click 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. 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 MacOn 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! You may also be interested inBagaimana cara mematikan scroll lock pada laptop?Menonaktifkan Scroll Lock. Jika keyboard Anda tidak memiliki tombol scroll Lock, di komputer Anda, klik mulai pengaturan> > kemudahan akses > keyboard.. Klik tombol pada keyboard layar untuk mengaktifkannya.. Ketika keyboard layar muncul di layar Anda, klik tombol ScrLk.. Bagaimana Cara Unlock Scroll di Excel?Cara yang sangat mudah untuk mengaktifkan atau menonaktifkan kunci gulir adalah dengan menekan tombol Scroll Lock pada keyboard. Buka Excel, lalu tekan Scroll Lock tombol pada keyboard untuk menyalakannya. Secara default, Scroll Lock tidak aktif.
Apa Fungsi Scroll Lock di keyboard?Scroll lock. Zaman DOS dulu, tombol panah berfungsi memindah kursor mengikuti panahnya. Kalau scroll lock aktif, kursor tidak pindah tetapi seluruh layar di-scroll mengikuti arah panah. Di zaman modern, tombol ini sudah dianggap angin lalu.
Kenapa tombol panah di keyboard tidak berfungsi?Masalah tombol panah yang tidak berfungsi dapat disebabkan oleh driver yang salah. Untuk memperbaikinya, kamu dapat mencoba menghapus dan menginstal ulang driver keyboard. Begini caranya: Di task bar, klik kanan tombol start dan pilih Device Manager.
|