How to Zoom in on a Selection in Excel 2010

When you really want to focus on a specific part of a spreadsheet in Microsoft Excel 2010, it can be hard to concentrate because of the other data that remains in view. Sure, you can always hide certain rows and columns so that they are still part of the spreadsheet, but not visible, but this can create problems later if you forget to unhide that data.

One other method that you can attempt is to select a portion of the worksheet, then zoom to that selection. Excel will automatically adjust the size of the selection to fill the Excel window, which can often achieve the effect that you want. This can also be a helpful action when you are sharing your screen in a presentation and are having difficulty identifying the data about which you are talking.


Zoom in on a Section of Selected Cells in Excel 2010

The steps in this article will show you how to select a specific group of cells in your Excel worksheet, then zoom the view so that the selection fills the window.

Note that if you have a large monitor and you do no select a lot of data, then Excel will make the selected data very large.


    • Step 1: Open your spreadsheet which contains the data on which you wish to zoom.


    • Step 2: Use your mouse to select the cells on which you wish to zoom.

make your selection



    • Step 3: Click the View tab at the top of the window.

click the view tab



  • Step 4: Click the Zoom to Selection button in the Zoom section of the ribbon at the top of the window.

click the zoom to selection button



The selected data should then fill your Excel window.

small image of zoomed selection



Once you are done zooming in on the data, you can click the 100% button in the Zoom section of the ribbon to return to the normal-sized window.

how to unzoom



Do you need to print from your spreadsheet, but you only want to print some of the data? Click here to learn about the changes that you need to make on the Print menu so that you only print the cells that you have selected. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.