Application.DefaultSheetDirection property (Excel)

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



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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.