[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)

Copy, Paste and Edit the Cell Content

The key combinations used to work with cell content are listed below.

Shortcut

Description

F2

Turns on the edit mode for the active cell and positions the cursor at the end of the cell content.

SHIFT+LEFT ARROW KEY

In the cell edit mode, selects or deselects one character to the left.

SHIFT+RIGHT ARROW KEY

In the cell edit mode, selects or deselects one character to the right.

CTRL+SHIFT+LEFT ARROW KEY

In the cell edit mode, selects or deselects one word to the left.

CTRL+SHIFT+RIGHT ARROW KEY

In the cell edit mode, selects or deselects one word to the right.

SHIFT+HOME

In the cell edit mode, selects from the cursor current position to the beginning of the cell.

SHIFT+END

In the cell edit mode, selects from the cursor current position to the end of the cell.

ALT+ENTER

Starts a new line in the same cell.

CTRL+ENTER

Completes a cell entry and stays in the same cell.

ENTER

Completes a cell entry and selects the cell below.

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

SHIFT+ENTER

Completes a cell entry and selects the cell above.

TAB

Completes a cell entry and selects the cell to the right.

SHIFT+TAB

Completes a cell entry and selects the cell to the left.

ESC

Cancels an entry in a cell or Formula Bar.

BACKSPACE

In the cell edit mode, deletes a character to the left of the cursor.

DELETE

Removes the cell content without affecting the cell formatting.

In the cell edit mode, deletes a character to the right of the cursor.

CTRL+DELETE

In the cell edit mode, deletes all characters from the cursor current position to the end of the line.

CTRL+Z or ALT+BACKSPACE

Performs the Undo command to reverse the last action or to delete the last entry you typed.

CTRL+Y or ALT+SHIFT+BACKSPACE

Repeats the last action.

CTRL+C or CTRL+INSERT

Copies the selected cell in the Clipboard.

CTRL+V or SHIFT+INSERT

Inserts the contents of the Clipboard in the specified cell and replaces any selection.

CTRL+ALT+V

Invokes the Paste Special dialog box to specify the paste options.

CTRL+X or SHIFT+DELETE

Cuts the selected cells.

CTRL+D

Performs the Fill Down command to copy the contents of the topmost cell to the cells below.

CTRL+R

Performs the Fill Right command to copy the contents of the leftmost cell to the cell to the right.

CTRL+K

Invokes the Insert Hyperlink dialog box to create a new hyperlink.

SHIFT+F2

Adds a comment to the active cell.

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