Excel 2010

How to Quickly and Easily Zoom in Excel

If you spend a lot of time zooming in your Excel worksheets I am sure you will agree that it becomes very tiresome very quickly! It also uses a lot of time which we all know I hate to do!

So, if you have a mouse with a small wheel between the left and right mouse buttons, there is a cool little trick that you can use to do your zooming.

All you really need to do is hold down your CTRL  key while simultaneously turning that small wheel!  Each click up or down will increase or decrease the zoom factor by 15%.

Also, you can use this method o zoom any magnification between ten and one hundred percent! If, for whatever reason you would want to, if you want to zoom over 100%, you would have to use the controls on the View tab of your Ribbon.

But, if you like this feature a lot and would like to use it to zoom all the time in your Excel worksheets, you can tell Excel to always use your mouse wheel to zoom.

Follow the steps below to learn how:

  1. Display the Excel Options dialog box (in Excel 2007, click the Office button and then click Excel Options). In Excel 2010, Click the File tab on your Ribbon and click Options.
  2. Click the Advanced option at the left-hand side of the dialog box.
  3. In the Editing area, select the Zoom On Roll with IntelliMouse check box.


  1. Click OK.

You can now zoom using your mouse wheel or scroll through your worksheet by holding down the CTRL key while using the wheel.