Spreadsheet view keyboard shortcuts

Insert

Add a new record to any spreadsheet.

Ctrl + Insert

Insert a copy of the selected record.

Ctrl + '

Copy the contents of the above field.

Esc

Undo changes made to a record prior to refreshing.

Delete

Delete characters or contents of the selected field.

Ctrl + Delete

Delete a record.

F1

Open online help.

F2

Access Edit mode within a cell.

Ctrl + F2

Open the Object Detail box.

F5

Refresh the spreadsheet view.

F7

Open the Spell Check tool.

Shift + F10

Display the shortcut (right-click) menu that includes cut, copy, and paste functions.

Ctrl + 1

Open the Facts spreadsheet.

Ctrl + 2

Open the Objects–Documents spreadsheet.

Ctrl + 3

Open the Issues spreadsheet.

Ctrl + 4

Open the Questions spreadsheet.

Ctrl + 5

Open the Research Authorities spreadsheet.

Ctrl + 6

Open the Research – Extracts from Authorities spreadsheet.

Ctrl + 7

Open the Research – Authorities and Extracts spreadsheet.

Ctrl + A

Opens the Add Object dialog box when you are in any of the description fields, such as Fact Text, Source(s), Author(s), and Recipient(s) that have the link icon in the field header.

Ctrl + C

Copy selected text to clipboard.

Ctrl + D

Open the Object Detail dialog box for the highlighted object short name in the Fact Text, Source(s), or Queston Text fields.

Ctrl + E

Post changes to a record when editing an existing record or adding a record.

Ctrl + F

Open the Find dialog box.

Ctrl + G

Run an instant tag.

Ctrl + H

Open the Replace dialog box.

Ctrl + O

Open the Connect to CaseMap Server dialog box to open a SQL case.

Ctrl + P

Opens the Print dialog box.

Ctrl+ R

Runs an instant filter on any value that you select in any spreadsheet cell.

Ctrl + V

Paste text from clipboard.

Ctrl + X

Cut selected text to the clipboard.

Ctrl + Z

Undo changes made to a text or description field prior to refreshing.

Ctrl + Shift + Z

Redo changes made to a text or description field prior to refreshing.

Ctrl + Spacebar

Open the Link Assistant when you are working in one of the description fields, such as Fact Text, Source(s), Author(s), and Recipient(s).

Spacebar

Toggle the state of check boxes or option buttons.

Home

Move cursor to the beginning of a line within a cell.

Move cursor to the first cell in a spreadsheet record.

End

Move cursor to the end of a line within a cell.

Move cursor to the first cell in a spreadsheet record.

Ctrl + Home

Move the cursor to the beginning of text within a cell.

Move cursor to the beginning of the transcript.

Move the selected cell to the first record of a column when a cell is selected (highlighted).

Ctrl + End

Move the cursor to the end of the text within a cell.

Move cursor to the end of the transcript.

Move the selected cell to the last record of a column when a cell is selected (highlighted).

Tab

Move selection to the next cell to the right in a spreadsheet row (excluding read-only fields).

Shift + Tab

Move selection back one cell to the left in a spreadsheet row.

Left or Right Arrow

Move selection left or right across cells in a single record.

Up or Down Arrow

Move selection up or down across cells in a single field.

Ctrl + Up or Down Arrow

Move the selected cell to the first or last record in a column.

Ctrl + Shift + Left Arrow

Select the entire word to the left of the cursor position.

Ctrl + Shift + Right Arrow

Select the entire work to the right of the cursor position.

Alt + Down Arrow

Open the dialog box associated with clicking the Ellipsis button (...) in a cell.

Open a list of options associated with a cell, such an open-ended lists.

Ctrl + Left or Right Arrow

Move the cursor one word at a time left or right from the current position within a cell.

Move the selected cell to the first or last cell in the spreadsheet record.