Spreadsheet view keyboard shortcuts

Inserts

Adds a new record to any spreadsheet.

Ctrl + Insert

Inserts 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

Deletes characters or contents of a selected field.

Ctrl + Delete

Deletes a record.

F1

Opens online help.

F2

Accesses Edit mode within a cell.

Ctrl + F2

Opens the Object Detail box.

F5

Refreshes the spreadsheet view.

F7

Launches the Spell Check tool.

Shift + F10

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

Ctrl + 1

Opens the Facts spreadsheet.

Ctrl + 2

Open the Objects–Documents spreadsheet.

Ctrl + 3

Opens the Issues spreadsheet.

Ctrl + 4

Opens the Questions spreadsheet.

Ctrl + 5

Opens the Research Authorities spreadsheet.

Ctrl + 6

Opens the Research – Extracts from Authorities spreadsheet.

Ctrl + 7

Opens 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

Copies selected text to clipboard.

Ctrl + D

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

Ctrl + E

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

Ctrl + F

Opens the Find dialog box.

Ctrl + G

Runs an instant tag.

Ctrl + H

Opens the Replace dialog box.

Ctrl + O

Opens 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

Cuts selected text to the clipboard.

Ctrl + X

Cuts 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

Opens 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

Toggles the state of check boxes or option buttons.

Home

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

Moves cursor to the first cell in a spreadsheet record.

End

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

Moves cursor to the first cell in a spreadsheet record.

Ctrl + Home

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

Moves cursor to the beginning of the transcript.

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

Ctrl + End

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

Moves cursor to the end of the transcript.

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

Tab

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

Shift + Tab

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

Left or Right Arrow

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

Up or Down Arrow

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

Ctrl + Up or Down Arrow

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

Ctrl + Shift + Left Arrow

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

Ctrl + Shift + Right Arrow

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

Alt + Down Arrow

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

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

Ctrl + Left or Right Arrow

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

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