If you zoom in and out of your documents quite a bit, you may get tired of using the Zoom controls on the View tab of the ribbon. If you have one of the mice that has a small wheel between the left and right mouse buttons, you can do a neat trick. All you need to do is hold down the Ctrl key as you turn the small wheel. Each click up or down increases or decreases the zoom factor by 15%. You can use this method of zooming for any magnification between 10% and 400%.
If you like this feature so much that you want to use it all the time (without the need to hold down the Ctrl key), you can instruct Excel to always use the mouse's wheel to zoom. Follow these steps:
Figure 1. The Advanced option of the Excel Options dialog box.
Now you can zoom by rolling the mouse wheel, or scroll through the worksheet by holding down the Ctrl key as you turn the wheel.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (10318) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Nifty Zooming.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Tired of shared workbooks opening at some strange zoom factor that makes viewing your data difficult? Here's how to make ...
Discover MoreExcel doesn't provide a keyboard shortcut that allows you to zoom in or out on your workbook. It is easy, however, to ...
Discover MoreIf you have trouble seeing the information presented in a worksheet, you can use Excel's zooming capabilities to ease the ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-04-05 13:03:18
Allan
If you choose this approach you give up wheel scrolling.
2019-04-05 10:03:57
Daniel
A mouse-free zoom is possible by the shortcut key F6, which circles between the status bar, the ribbon and the spreadsheet. When you are in the status bar you can use the arrow keys to highlight the plus or the minus button. Then you can hit enter to zoom. When you are back in the spreadsheet, the next time you hit F6, Excel will remember the last button you highlighted so you can hit enter to repeat that procedure.
2014-09-05 09:44:37
Bryan
I'm glad I was able to contribute to the accuracy of this tip.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments