officefileapi-devexpress-dot-xtraspreadsheet-dot-spreadsheetselectionoptions-9b1b9b36.md
Specifies the direction in which an active cell moves on an ENTER key press.
Namespace : DevExpress.XtraSpreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[DefaultValue(MoveActiveCellModeOnEnterPress.Down)]
public MoveActiveCellModeOnEnterPress MoveActiveCellMode { get; set; }
<DefaultValue(MoveActiveCellModeOnEnterPress.Down)>
Public Property MoveActiveCellMode As MoveActiveCellModeOnEnterPress
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to MoveActiveCellMode |
|---|---|
| SpreadsheetBehaviorOptions |
.Selection .MoveActiveCellMode
|
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
SpreadsheetSelectionOptions Class