# Using Excel-compatible Keyboard Shortcuts

Learn how to save time and increase efficiency by using Excel-compatible keyboard shortcuts with Spread for WinForms. Find out the supported shortcuts and their behavior when ExcelCompatibleKeyboardShortcuts is set to true.

## Content

By using keyboard shortcuts, you can save your time and increase efficiency. Spread for WinForms provides **ExcelCompatibleKeyboardShortcuts** property which when set to true, allows you to use Excel-compatible keyboard shortcuts.

> !type=note
> **Note**:
>
> * The supported shortcuts and their behavior when **ExcelCompatibleKeyboardShortcuts** is true, may change in next releases to match with Excel behavior.
> * If **ExcelCompatibleKeyboardShortcuts** is false, some of the shortcut keys are available on Spread Designer as well.

The below table lists the Excel-compatible keyboard shortcuts:

| **Shortcut** | **Spread Designer Support** | **Description** |
| -------- | :---------------------- | ----------- |
| CTRL + - | No | Delete cells |
| CTRL + F3 | Yes | Show Name Manager dialog |
| SHIFT + F9 | Yes | Calculate the active sheet |
| F9 | Yes | Calculate the entire workbook |
| CTRL + SHIFT + T | Yes | Show/hide total row of the table |
| CTRL + T | Yes | Create table |
| CTRL + U | Yes | Format text as underline |
| CTRL + I | Yes | Format text as italic |
| CTRL + B | Yes | Format text as bold |
| CTRL + SHIFT + % | Yes | Format as a Percent |
| CTRL + SHIFT + V | No | Paste plain text or paste values |
| ALT + SHIFT + RIGHT Arrow | Yes | Group data |
| ALT + SHIFT + LEFT Arrow | Yes | Ungroup data |
| SHIFT + F2 | No | Create cell comment (EnhancedShapeEngine = True) |
| ALT + UP Arrow | No | Show Data Validation auto complete list when cell in editmode |
| SHIFT + F3 | Yes | Show Insert Function / Function Arguments dialog |
| F3 | No | Show Paste Name dialog |
| Ctrl+\` | No | Toggle between displaying formulas in cells and displaying calculated values as in Excel |
| Ctrl+1 | No | Show "Format Cells" dialog |
| Ctrl+Shift+F5 | No | Show card (for .NET data object) |
| Ctrl+K | No | Show Insert Hyperlink dialog |
| Ctrl+Enter | No | Input data for multiple cells |
| Tab | No | Move to the next cell at the right In case of a table, if active cell is in the last column of table <ul><li>If the last row of table is selected, add new data row and move active cell to the first cell of new row</li><li>Otherwise, move to the first cell of the next row (or the first cell of the first row if current row is the last)</li></ul> |
| Shift + Tab | No | Move the active cell to the previous cell at the left If the active cell is in the first column of table, move to the last cell of previous row (or the last cell of the last row if current row is the first) |
| Ctrl + A | No | Select neighbor cells, then worksheet on each subsequent use of Ctrl+A If the cell belongs to Table, select table data range, then table range, then worksheet on each subsequent use of Ctrl+A |
| Ctrl + Shift + "+" | No | Insert cut or copied cells |
| Ctrl + Page Up | No | Navigate to the next sheet. |
| Ctrl + Page Down | No | Navigate to the previous sheet. |

The below example code sets **ExcelCompatibleKeyboardShortcuts** property to true which allows you to use above mentioned shortcuts.

```csharp
// Set ExcelCompatibleKeyboardShortcuts features to true
 fpSpread1.Features.ExcelCompatibleKeyboardShortcuts = true;
// Set value in Cells
 fpSpread1.ActiveSheet.Cells["A1"].Value = 10;
 fpSpread1.ActiveSheet.Cells["B1"].Value = 20;
 // Set formula in Cell
 fpSpread1.ActiveSheet.Cells["C1"].Formula = "SUM(A1: B2)";
```


```csharp
' Set ExcelCompatibleKeyboardShortcuts features to true
fpSpread1.Features.ExcelCompatibleKeyboardShortcuts = True
' Set value in Cells
fpSpread1.ActiveSheet.Cells("A1").Value = 10
fpSpread1.ActiveSheet.Cells("B1").Value = 20
' Set formula in Cell
fpSpread1.ActiveSheet.Cells("C1").Formula = "SUM(A1: B2)"
```