Get started
Search
Search Corporate Tax (ONESOURCE) 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
  • Shortcuts are grouped by the area of OCT where they apply. Availability can depend on your permissions and on whether the workbook is read-only.
  • Shortcuts that use a function key (F2, F6, F7, F8, F10) may require holding the Fn key at the same time—for example, Fn + F2—depending on your keyboard and its Function Key Behavior setting. The shortcuts in this topic note this where it applies. Check your device's keyboard settings if a function-key shortcut doesn't respond.

Moving Around and Editing a Workbook

Shortcut
What It Does
Arrow keys
Move the active cell up, down, left, or right.
Enter
Move down one cell. If a cell is being edited, commits the edit.
Shift + Enter
Move up one 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 cell(s).
Ctrl + X
Cut the selected cell(s).
Ctrl + V
Paste into the selected cell(s).
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.
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).
Once the navigation panel is open, pressing F10 again highlights the current sheet in the tree, so you can browse the rest of the list without a mouse.
Shortcut
What It Does
F10 (panel already open) (Fn + F10)
Highlight the current sheet in the navigation tree.
Arrow Up / Arrow Down
Move the highlight to the previous or next sheet in the tree.
Some workbook cells present a list of choices instead of free-form entry. While the list is open, use the following shortcuts:
Shortcut
What It Does
Arrow Up / Arrow Down
Highlight the previous or next item in the list.
Enter
Select the highlighted item.
Escape
Close the list without making a selection.