[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Collapse]Spreadsheet
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Expand]Pivot Table Overview
   [Expand]Charts and Graphics
    Printing
    Events
    Protection
    Operation Restrictions
    Find and Replace
   [Expand]Mail Merge
   [Expand]Visual Elements
    Services
    Themes and Templates
   [Collapse]Shortcuts
     File Operations
     Navigation inside Worksheets
     Work with Selections
     Copy, Paste and Edit the Cell Content
     Cell Formatting
     Work with Columns and Rows
     Sort and Filter
     Work with Formulas
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Navigation inside Worksheets

The key combinations that allow you to navigate through a worksheet are listed in the table below.

Shortcut

Description

LEFT ARROW KEY

Moves the active cell one cell to the left in a worksheet.

RIGHT ARROW KEY

Moves the active cell one cell to the right in a worksheet.

UP ARROW KEY

Moves the active cell one cell up in a worksheet.

DOWN ARROW KEY

Moves the active cell one cell down in a worksheet.

ENTER

Moves the active cell one cell down in a worksheet.

To change this default behavior, use the SpreadsheetSelectionBehaviorOptions.MoveActiveCellMode property.

SHIFT+ENTER

Moves the active cell one cell up in a worksheet.

TAB

Moves the active cell one cell to the right in a worksheet.

SHIFT+TAB

Moves the active cell one cell to the left in a worksheet.

CTRL+ARROW KEYS

Move the active cell to the edge of the current data region in a worksheet.

HOME

Moves the active cell to the beginning of a row in a worksheet.

CTRL+HOME

Moves the active cell to the beginning of a worksheet.

CTRL+END

Moves the active cell to the last cell in a worksheet (the last edited row of the rightmost edited column).

PAGE DOWN

Moves the active cell one screen down in a worksheet.

PAGE UP

Moves the active cell one screen up in a worksheet.

ALT+PAGE DOWN

Moves the active cell one screen to the right in a worksheet.

ALT+PAGE UP

Moves the active cell one screen to the left in a worksheet.

CTRL+F

Invokes the Find and Replace dialog (with the Find tab activated).

CTRL+H

Invokes the Find and Replace dialog (with the Replace tab activated).

CTRL+PAGE DOWN

Moves to the next worksheet in the current workbook.

CTRL+PAGE UP

Moves to the previous worksheet in the current workbook.

Is this topic helpful?​​​​​​​