How Do I Work in Microsoft Excel?

Working in Microsoft Excel

To be able to work effectively if MS Excel, one need to be able to navigate the worksheet. This can be done by using the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet. In Microsoft Office Excel 2007, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and tooltips that let you know where you are in the worksheet. There are different ways to scroll through a 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. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars.

To scroll	Do this
To the start and end of ranges	Press CTRL+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. To scroll to the start and end of each range while at the same time, selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+ARROW key.
One row up or down	Press SCROLL LOCK on the keyboard, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.
One column left or right	Press SCROLL LOCK, and then use the LEFT ARROW key or RIGHT ARROW key to scroll one column left or right.
One window up or down	Press PAGE UP or PAGE DOWN.
One window left or right	Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key.
A large distance	Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.