Then click the Ease of Access > Ease of Access Center > Start On-Screen Keyboard successively in the following three dialog boxes. In the opening folder, click the Control Pane Home in the left.ģ.
#Turn off scroll lock in excel 2007 windows#
Right click any blank place on the screen in the Windows 8, and click the Personalize from the context menu.Ģ. Turn on/off scroll lock on the On-Screen Keyboard in Windows 8ġ. Then the On-Screen Keyboard appears on the screen, and just click the ScrLk button. Then click Accessories > Ease of Access > On-Screen Keyboard. Turn on/off scroll lock on the On-Screen Keyboard in Windows 7/Vistaġ. If there is no Scroll Lock key in your keyboard, you can use this this method. If you want to turn scroll lock off, just need to press the Scroll Lock button again. Open the Excel, and then press Scroll Lock button on the keyboard to turn on it. Turn on/off scroll lock by click Scroll Lock button on the On-Screen KeyboardĪ very easy way to turn on or turn off scroll lock is to press the Scroll Lock button on the keyboard. Turn on/off scroll lock by press Scroll Lock button on the keyboard
#Turn off scroll lock in excel 2007 how to#
Here, I talk about how to turn this scroll lock on or off in Excel. Sometimes, this is quite annoying, and you want to turn it on. In Excel, when you press Up and Down arrows or Left and Right arrows incautiously, the active cell moves at the same time. You can always ask an expert in the Excel Tech Community or get support in the Answers community.How to turn on/off the scroll lock in Excel? Point to any cell that contains detail data, and then hold down SHIFT while you rotate the wheel back. Point to a cell that summarizes data in the outline, and then hold down SHIFT while you rotate the wheel forward. The percentage of the zoomed worksheet is displayed on the status bar. Hold down CTRL while you rotate the IntelliMouse wheel forward or back. To stop automatic scrolling, click any mouse button. To slow down scrolling, move the pointer closer to the origin mark. To speed up scrolling, move the pointer away from the origin mark.
To slow down scrolling, move the pointer closer to the origin mark.Ĭlick the wheel button, and then move the mouse in the direction that you want to scroll. Hold down the wheel button, and drag the pointer away from the origin mark in any direction that you want to scroll. Press and hold CTRL+SHIFT and rotate the wheel forward or backward. For more information, see the instructions for your pointing device. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars. Some mouse devices and other pointing devices, such as the Microsoft IntelliMouse pointing device, have built-in scrolling and zooming capabilities that you can use to move around and zoom in or out on your worksheet or chart sheet. Hold down SHIFT while dragging the scroll bar. Moving the mouse in the opposite direction slows down the scroll speed.Ĭlick above or below the scroll bar on the vertical scroll bar.Ĭlick to the left or right of the scroll bar on the horizontal scroll bar. While scrolling, hold down the mouse at the farthest end of the screen for more than 10 seconds to increase the scrolling speed. Scroll through a worksheet with increased scroll speed The following table describes different ways for using the scroll bars to move through a worksheet.Ĭlick the scroll arrows or on the vertical scroll bar to move the sheet one row up or down.Ĭlick the scroll arrows or on the horizontal scroll bar to move the sheet one column to the left or right. In Excel 2007, click the Microsoft Office Button, and then click Excel Options.Ĭlick Advanced, and then under Display options for this workbook, make sure that the Show horizontal scroll bar and the Show vertical scroll bar check boxes are selected, and then click OK. If you do not see the scroll bars, do the following to display them: Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet. Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key. Press SCROLL LOCK, and then use the LEFT ARROW key or RIGHT ARROW key to scroll one column left or right. Press SCROLL LOCK, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down. To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key. Press CTRL+an arrow key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet.
When you move to a cell, it becomes the active cell. To move between cells on a worksheet, click any cell or use the arrow keys.
0 kommentar(er)
