Hold down SHIFT while dragging the scroll box. Moving the mouse in the opposite direction slows down the scroll speed.Ĭlick above or below the scroll box on the vertical scroll bar.Ĭlick to the left or right of the scroll box 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: Use the scroll bars to move through a worksheet To turn off SCROLL LOCK, click the ScrLk key, and then close the On-Screen Keyboard.
#SHORTCUT KEY FOR SCROLLING UP AND DOWN INBOX IN OUTLOOK FOR MAC WINDOWS#
To open the On-Screen Keyboard, click the Start button on your Windows desktop and type On-Screen Keyboard. If your keyboard doesn't include this key, you can turn off SCROLL LOCK by using the On-Screen Keyboard. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard. To use the arrow keys to move between cells, you must turn SCROLL LOCK off. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. 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. Use the arrow keys to move through a worksheet You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars. In Excel, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and ScreenTips that let you know where you are in the worksheet.
You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet. There are different ways to scroll through a worksheet. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 kommentar(er)
