Excel.PageSetup.Zoom.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PageSetup.Zoom property (Excel)	vbaxl10.chm473103	vbaxl10.chm473103	Excel.PageSetup.Zoom	3deebce5-8605-c549-371c-033848073ffe	05/03/2019	medium

PageSetup.Zoom property (Excel)

Returns or sets a Variant value that represents a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing.

Syntax

expression.Zoom

expression A variable that represents a PageSetup object.

Remarks

This property applies only to worksheets.

If this property is False, the FitToPagesWide and FitToPagesTall properties control how the worksheet is scaled.

All scaling retains the aspect ratio of the original document.

Example

This example scales Sheet1 by 150 percent when the worksheet is printed.

Worksheets("Sheet1").PageSetup.Zoom = 150

[!includeSupport and feedback]