Excel.Range.AutoOutline.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.AutoOutline method (Excel)	vbaxl10.chm144087	vbaxl10.chm144087	Excel.Range.AutoOutline	a2553695-6d45-9b7c-7c45-5255fa3641f0	05/10/2019	medium

Range.AutoOutline method (Excel)

Automatically creates an outline for the specified range. If the range is a single cell, Microsoft Excel creates an outline for the entire sheet. The new outline replaces any existing outline.

Syntax

expression.AutoOutline

expression A variable that represents a Range object.

Return value

Variant

Example

This example creates an outline for the range A1:G37 on Sheet1.

Note

The range must contain either a summary row or a summary column.

Worksheets("Sheet1").Range("A1:G37").AutoOutline

[!includeSupport and feedback]