Zoom to a section of the screen

Display tip

By Neale Blackwood

Large spreadsheets frequently have the zoom percentage set to below 100% to fit more information on the screen. This can make it hard to read some details. Excel allows you to zoom into a region of the sheet so that it fills your screen and you can read it more easily.

First select a range. Then click the drop down arrow on the Zoom tool on your toolbar and click Selection.

The range should fill the screen. Undo will take you back to the original zoom percentage.