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

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

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