Spreadsheet keys

[Ctrl]+[1]

From the spreadsheet, it opens the One-time Item window.

From the Totals pane, it opens the One-time Addon window.

[Ctrl]+[A] Selects the entire spreadsheet.
[Ctrl]+[Shift]+[A] Performs the Copy Sum function.

[Ctrl]+[D]

Opens the Detail window.

[Ctrl]+[E]

Goes to the first visible Equipment column.

[Ctrl]+[F]

  • Opens the Find/Go To window in the spreadsheet or in assembly takeoff.
  • Opens the Search area in a List window.

[Ctrl]+[Shift]+[H]

In the Totals pane, hides Addon columns in the Totals pane.

[Ctrl]+[Shift]+[J]

In the Totals pane, opens the Edit Job Size window.

[Ctrl]+[I]

Lets you edit the selected item in the standard database.

[Ctrl]+[L]

Goes to the first visible Labor column.

[Ctrl]+[M]

Goes to the first visible Material column.

[Ctrl]+[N]

Starts a new estimate.

[Ctrl]+[Shift]+[N]

Opens the Notes window.

[Ctrl]+[O]

Lets you open an existing estimate.

[Ctrl]+[P]

Lets you edit the selected phase in the standard database.

[Ctrl]+[Q]

Goes to the Takeoff Quantity column.

[Ctrl]+[S]

Goes to the first visible Sub column.

[Ctrl]+[Shift]+[S]

In the Totals pane, shows hidden Addon columns.

[Ctrl]+[T]

Goes to the first visible total column.

[F2]

Lets you edit a cell.

[F3]

Finds the next item that matches the current search criteria.

[F4]

Opens the Totals window.

[Esc]

Cancels your changes to a cell.

[Ctrl]+[0] (zero)

Goes to the first visible Other column.

[Ctrl]+[Page Down]

Goes to the next spreadsheet sequence tab.

[Ctrl]+[Page U[]

Goes to the previous spreadsheet sequence tab.

[Ctrl]+[=]

Expands the entire spreadsheet one level.

[Ctrl]+[+]

Also expands the entire spreadsheet one level.

[Ctrl]+[-]

Collapses the entire spreadsheet one level.

[Ctrl]+[Z]

Reverses the previous action.