excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Car Tips
Excel2007 Tips
Pet Tips
Wedding Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

Zooming or Scrolling with the Mouse Wheel

Summary: Excel allows your mouse's center wheel to be used for two different purposes. Here's how to throw the switch that indicates which purpose should be used.

If you have a computer mouse that has a wheel between its two buttons, you may know that Excel recognizes the wheel and allows you to use it for different purposes. The default behavior of the wheel is to scroll your worksheet up and down. You can modify how Excel reacts to moving the wheel by following these steps:

  1. Click the Office button, then click Excel Options. Excel displays the Excel Options dialog box.
  2. At the left side of the dialog box, click Advanced. (Click here to see a related figure.)
  3. Scroll through the available options until you find the Editing Options area.
  4. Select the Zoom On Roll With IntelliMouse check box.
  5. Click on OK.

Now when you use the mouse wheel, Excel zooms your worksheet in and out. If you decide you again want to use the wheel to scroll, simply repeat the steps but clear the check box.

Related Tips:

More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!