Get started
Search
Search Corporate Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE Corporate Tax

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 its
    Function Key Behavior
     setting. 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.

Workbook navigation

Shortcut
What It Does
F6 (Fn + F6)
Jump back to the last worksheet you visited.
F7 (Fn + F7)
Jump to the next calculation error in the workbook.
F8 (Fn + F8)
Open the Dependent References panel for the selected cell.
F10 (Fn + F10)
Open the workbook navigation panel (sheet tree).

Use the navigation panel while open

Press F10 again to select the current sheet in the navigation tree after you open the panel. You can then go to the rest of the list without your mouse.
Shortcut
What It Does
F10 (panel already open) (Fn + F10)
Selects the current sheet in the navigation tree.
Arrow Up/Arrow Down
Moves the selection to the previous or next sheet in the tree.
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.