I started on a Mac, where the mouse had one big button. Later, I moved to a PC, with a two button mouse. For the past few years I’ve used a mouse with two buttons and a scroll wheel.
Scroll Through Excel
At first, I completely ignored the scroll wheel, and found it faster to drag the scroll bar, than to move the scroll wheel. Now I use the wheel occasionally, but more often in Firefox or Word, than in Excel.
Use the Scroll Wheel With Outlines
AlexJ, who shared his technique to hide Excel rows with outlining a few days ago, also uses the scroll wheel to show and hide outline levels.
- Point to a cell within the outlined range
- Press the Shift key, then roll the scroll wheel down, to hide the outline levels for that cell.
- Or, press the Shift key, then roll the scroll wheel up, to show the outline levels for that cell.
Use the Scroll Wheel to Zoom
He also reminded me that you can use the scroll wheel to zoom in or out on the worksheet.
- Point to a cell within the outlined range
- Press the Ctrl key, then roll the scroll wheel down, to hide the outline levels for that cell.
- Or, press the Shift key, then roll the scroll wheel up, to show the outline levels for that cell.
Use the Scroll Wheel to Scroll
And yes, you can even use the scroll wheel to scroll. Really fast!
- Click the scroll wheel, and a four-headed arrow appears
- Move the mouse up, down, left or right, and a single arrow appears, pointing in the direction that the mouse is moving.
- The Excel sheet scrolls very quickly, increasing in speed as you move the single arrow toward the edge of the worksheet.
- To stop the scrolling, tap the scroll wheel, or click a mouse button.
Other Scroll Wheel Shortcuts?
Do you use the scroll wheel? Do you have any other shortcuts for it?
_________________________