![]() ![]() In such cases, a cell can be selected by using the mouse. Note: When the scroll lock in excel is turned on, the arrow keys cannot be used to select a cell. Select a range of cells horizontally or vertically by pressing the “Shift” and the respective arrow key simultaneously.Move to the last cell of a blank range by pressing “Ctrl” and the respective arrow key together.Move up, down, left or right from one cell to the other by pressing the respective arrow key.The arrow keys perform the following functions when the scroll lock is turned off: Move quickly to the different areas of a worksheet by pressing “Ctrl” and the respective arrow key simultaneously.Move one row up or down and one column to the left or right by pressing the respective arrow key.The arrow keys perform the following functions when the scroll lock is turned on: Source: Scroll Lock in Excel () The Functions of the Arrow Keys (With and Without the Scroll Lock) You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked read more of Excel can be customized to indicate whether the scroll lock is on or off. The status bar Status Bar As the name implies, the status bar displays the current status in the bottom right corner of Excel it is a customizable bar that can be customized to meet the needs of the user. The Scroll Lock key works similar to the Caps Lock or Num Lock key. The Scroll Lock key is labeled “Scroll Lock,” “ScrLk,” “ScLk” or “Slk” depending on the kind of keyboard being used. By default, the scroll lock is disabled (turned off) in Excel. Toggling implies that the scroll lock can be switched on and off with the pressing of the key. The scroll lock is a toggle key available on all virtual (on-screen) keyboards and some physical keyboards. Hence, the active cell does change in this situation. This is the usual functioning of the four arrow keys in the absence of the scroll lock. Next, press the right arrow key and it shifts the selection to cell D4.Ĭell D4 becomes the active cell by pressing the right arrow key.Disable the scroll lock by pressing the Scroll Lock key (one more time) from a virtual or physical keyboard. Situation 2–Scroll lock is disabled (off or unlocked) Hence, the active cell does not change in this situation. This is because the right arrow key has caused a right-side movement of the scroll bar.Įven though there is a movement, the active cell (cell C4) remains selected. Press the right arrow key twice and the columns on the left (columns A and B) of the active cell (C4) can no longer be seen. Next, press the right arrow key and it allows scrolling to the right of the worksheet.Enable the scroll lock by pressing the Scroll Lock key from a virtual or physical keyboard. Situation 1–Scroll lock is enabled (on or locked) The tasks performed and the outcomes in both situations are given. How to Turn Off the Scroll Lock in Excel?įor example, let us observe the following two situations.How to Find out Whether Scroll Lock in Excel is on or off?.The Functions of the Arrow Keys (With and Without the Scroll Lock).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |