Keyboard shortcuts
A reference guide to keyboard shortcuts available in OCT (ONESOURCE Corporate Tax). Most shortcuts are available when working in a workbook (the spreadsheet-style data entry and calculation grid) and follow familiar spreadsheet conventions similar to Microsoft Excel.
note
- We group shortcuts by the area of OCT where they apply. Your permissions and whether the workbook is read-only affects which shortcuts you can use.
- When using function keys (F2, F6, F7, F8, F10), you may need to press the Fn key at the same time (for example, Fn + F2). This depends on your keyboard and itsFunction Key Behaviorsetting. This article notes which shortcuts require this.
- Verify your device's keyboard settings if a function key shortcut doesn't respond.
Move around and edit a workbook
Shortcut | What It Does |
|---|---|
Arrow keys | Move the active cell up, down, left, or right. |
Enter | Move down 1 cell. If a cell is being edited, it commits the edit. |
Shift + Enter | Move up 1 cell. |
F2 (Fn + F2) | Edit the active cell, with the cursor placed at the end of its contents. |
Start typing | Begin editing the active cell, replacing its current contents. |
Delete or Backspace | Clear the contents of the selected cell or range. |
Escape | Cancel the current cell edit without saving changes. |
Insert | Insert a new row or column at the current selection. |
Undo and redo
Shortcut | What It Does |
|---|---|
Ctrl + Z | Undo the last change made in the workbook. |
Ctrl + Y | Redo the last undone change. |
Copy, cut, and paste
Shortcut | What It Does |
|---|---|
Ctrl + C | Copy the selected cells. |
Ctrl + X | Cut the selected cells. |
Ctrl + V | Paste into the selected cells. |
Ctrl + Shift + V | Paste values only (no formulas or formatting). |
Ctrl + V (Chart of Accounts) | Paste tab-delimited rows copied from Excel directly into the grid to bulk-import them. |
Working with formulas
Shortcut | What It Does |
|---|---|
Click or Shift + click a cell while typing a formula | Insert a reference to that cell, or extend the reference to a range—the same way it works in Excel. |
Ctrl + click a cell while typing a formula | Add a separate, additional cell reference to the formula. |
Enter | Commit the formula you're building. |
Escape | Cancel formula entry and return to the original cell. |
Dropdown list cells
Some workbook cells present a list of choices instead of a free-form entry. While the list is open, use the following shortcuts:
Shortcut | What It Does |
|---|---|
Arrow Up/Arrow Down | Selects the previous or next item in the list. |
Enter | Selects the highlighted item. |
Escape | Close the list without making a selection. |