Scrolling Up and Down

Everyone knows that you can use the Up and Down Arrow keys to move vertically through an Excel worksheet. You probably even know that you can use the Page Up and Page Down keys to make even bigger jumps. What if you don't want to take your hands off your mouse, however? Obviously you can click on the controls on the scroll bar, but Excel provides yet another way to scroll vertically, provided you are using Excel 97 or a later version.

If you have a newer mouse--the kind with the small wheel between the two buttons--you can turn the wheel to quickly move vertically through the worksheet. This allows you to use your mouse pointer for something different--such as pointing at something you need to remember. (I hate it when I scroll down and can't remember which column I was working with.)