Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

Adjusts the view of a worksheet. You can zoom in to get a close-up view of your worksheet data.

Magnification

<Percentage>

Select one of the default options of 200%, 100%, 75%, 50%, or 25%.

Fit selection

Zoom the worksheet so the selected range of cells fills the entire window. This can help you focus on a specific area of the worksheet.

Custom

Select and then type a percentage from 10 to 400 percent.

Select OK to save your changes or select Cancel to dismiss this dialog box without making any zoom setting changes.

See also

Zoom in or out of a document, presentation, or worksheet

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.