[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Pivot Grid
  [Collapse]Spreadsheet
   [Expand]Product Information
    Getting Started
   [Collapse]Concepts
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Expand]Spreadsheet Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
    [Expand]Charting
     Printing
    [Expand]Mail Merge
     Protection
     Adaptivity
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Gauges
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[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]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Keyboard Shortcuts

The Spreadsheet provides the capability to perform common commands quickly using keyboard shortcuts.

All supported shortcuts are divided into the following groups.

Expanded File Operations

Shortcut

Description

CTRL+N Creates a blank workbook (supported only on the Internet Explorer and Microsoft Edge browsers).
CTRL+O Invokes the Open dialog box to open a new file (the Internet Explorer browser performs its native open action before a Spreadsheet's open action).
CTRL+S Saves changes in the current workbook.
CTRL+P Invokes the Print dialog box.
CTRL+F Invokes the Find and Replace dialog (with the Find tab activated).
SHIFT+F11 Inserts a new worksheet in front of the existing worksheet within the current workbook (not supported on the Safari browser).

Expanded Navigation Inside Worksheets

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

Expanded Work with Selection

Shortcut

Description

ENTER Moves the active cell one cell down in the selection.
SHIFT+ENTER Moves the active cell one cell up in the selection.
TAB Moves the active cell one cell to the right in the selection.
SHIFT+TAB Moves the active cell one cell to the left in the selection.
CTRL+A Selects the entire worksheet or the data region to which the active cell belongs.
SHIFT+ARROW KEYS Extends the selection by one cell in the specified direction.

Expanded Cell Content Editing

Shortcut

Description

F2 Turns on the edit mode for the active cell and positions the cursor at the end of the cell's 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.
ENTER Completes a cell entry and selects the cell below.
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's current position to the start of the next word.
CTRL+Z Performs the Undo command to reverse the last action or to delete the last entry you typed.

Expanded Copy/Paste Operations

Shortcut

Description

CTRL+V or SHIFT+INSERT Inserts the contents of the Clipboard in the specified cell and replaces any selection.
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 active cell.
CTRL+R Performs the Fill Right command to copy the contents of the leftmost cell to the active cell.

Expanded Cell Formatting

Shortcut

Description

CTRL+B or CTRL+2 Applies or removes bold formatting.
CTRL+I or CTRL+3 Applies or removes italic formatting.
CTRL+U or CTRL+4 Applies or removes underlining.
CTRL+5 Applies or removes strikethrough formatting.
CTRL+SHIFT+7 Applies the outline border to the selected cell or cell range.
CTRL+SHIFT+1 Applies the General number format with two decimal places.
CTRL+SHIFT+2 Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+3 Applies the Date format with the day, month and year.
CTRL+SHIFT+4 Applies the Currency format with two decimal places (negative numbers in parantheses).
CTRL+SHIFT+5 Applies the Percentage format with no decimal places.
CTRL+SHIFT+6 Applies the Scientific number format with two decimal places.

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