Application.DefaultSheetDirection Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns or sets the default direction in which Microsoft Excel displays new windows and worksheets. Can be one of the following constants: xlRTL (right to left) or xlLTR (left to right). Read/write Long.

expression .DefaultSheetDirection

expression A variable that represents an Application object.

Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed.

This example sets right to left as the default direction.

Application.DefaultSheetDirection = xlRTL