Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [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]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

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 SpreadsheetSelectionOptions.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.
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.

How would you rate this topic?​​​​​​​