![]() When the scroll lock is turned on, the status bar of Excel shows the status “scroll lock” at the left side. Under this method, there can be the following two cases: The values supplied to the function can be numbers, cell references or ranges. Being categorized under the Math and Trigonometry function, it is entered by typing “=SUM” followed by the values to be summed. read more, sum Sum Of Numbers The SUM function in excel adds the numerical values in a range of cells. It shows the average Average Of Numbers Average is the value that is used to represent the set of values of data as is the average calculated from whole data and this formula is calculated by adding all the values of the set given, denoted by summation of X and dividing it by the number of values given in set denoted by N. The status bar is shown in the following image. When the scroll lock in excel is turned on or off, it is reflected on the status bar of the Excel worksheet. Method 2: By the status of the status bar If the Caps Lock key is turned off, the light is switched off. Turn on this key and the light is switched on. The Caps Lock key usually has a light indicator which is shown (within the red circle) in the following image. Make the desired changes in “make the keyboard easier to use.” Click “Ok” to proceed.īy enabling the settings listed under “method 1,” a beep sound will also be made if the Caps Lock or the Num Lock keys are turned on. Note 2: In Windows 7, click “start” and type “ease of access center” (without the double quotation marks) in the search box. Click “make the keyboard easier to use.” Make the required changes and click “Ok” or “apply” to save them. Note 1: The Ease of Access Center can also be accessed from the Control Panel of Windows 10. 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |