Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetSelectionOptions.MoveActiveCellMode Property

Specifies the direction in which an active cell moves on an ENTER key press.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

[DefaultValue(MoveActiveCellModeOnEnterPress.Down)]
public MoveActiveCellModeOnEnterPress MoveActiveCellMode { get; set; }

#Property Value

Type Default Description
MoveActiveCellModeOnEnterPress Down

A MoveActiveCellModeOnEnterPress enumeration value.

Available values:

Name Description
None

An active cell does not move on an ENTER or a SHIFT+ENTER press.

Down

An active cell moves one cell down on an ENTER press, and one cell up on a SHIFT+ENTER press.

Right

An active cell moves one cell to the right on an ENTER press, and one cell to the left on a SHIFT+ENTER press.

Up

An active cell moves one cell up on an ENTER press, and one cell down on a SHIFT+ENTER press.

Left

An active cell moves one cell to the left on an ENTER press, and one cell to the right on a SHIFT+ENTER press.

#Property Paths

You can access this nested property as listed below:

Object Type Path to MoveActiveCellMode
SpreadsheetBehaviorOptions
.Selection .MoveActiveCellMode

#Remarks

By default, when the ENTER key is pressed, the SpreadsheetControl moves an active cell one cell down. Use the MoveActiveCellMode property to set another direction to move an active cell (for example, Up, Right or Left). To keep an active cell on an ENTER press, set the MoveActiveCellMode property to the MoveActiveCellModeOnEnterPress.None value.

The SHIFT+ENTER key combination moves an active cell in the opposite direction of what the MoveActiveCellMode property specifies.

TAB and SHIFT+TAB moves an active cell one cell to the right and to the left respectively, and this behavior is not customized.

Note

If a cell range or multiple ranges are selected in a worksheet, ENTER, SHIFT+ENTER, TAB and SHIFT+TAB move an active cell within this selection only.

See Also