Shortcut & Function Keys

The following keys can be used to edit, control and navigate around the spreadsheets:

CTRL + A	Selects the entire spreadsheet
CTRL + C	Copies the selected cells
CTRL + D	Uses the Fill Down command to copy the topmost cell of a selected range in to the cells below
CTRL + F	Opens the Find window
CTRL + H	Opens the Replace window
CTRL + N	Creates a new, blank load
CTRL + O	Displays the Open window to open a new file
CTRL + S	Saves the current load
CTRL + T	Opens the column setup window
CTRL + V	Pastes data from the Windows clipboard
CTRL + X	Cuts the selected cells

F1	Displays the DataLoad User Guide
F2	Opens the current cell for editing

ARROW KEYS	Move one cell up, down, right or left in the spreadsheet CTRL + ARROW KEY moves to the edge of the current data region in a spreadsheet CTRL +SHIFT + ARROW KEY extends the selection of cells to the last non blank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next non blank cell.
BACKSPACE	Clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point.
DELETE	Clears the content of the active cell. In cell editing mode, it deletes the character to the right of the insertion point.
END	Moves to the last cell in the current row. If SHIFT is also depressed the selection is extended to the last cell in the current row. CTRL + END moves to the last cell in the spreadsheet. If SHIFT is also depressed the selection is extended to the last cell in the spreadsheet.
ENTER	Takes the current cell out of edit mode, if required, and moves the active cell down by one row. ALT + ENTER inserts a new line in the current cell, allowing multi line editing within cells. ALT + ENTER also puts the long cell edit box above the spreadsheets in to multi line mode but in that area new lines can then be inserted using just ENTER without the ALT key.
ESC	Cancels cell data entry and takes the cell out of edit mode.
HOME	Moves to the first cell in the current row. If SHIFT is also depressed the selection is extended to the first cell in the current row. CTRL + HOME moves to the first cell in the spreadsheet. If SHIFT is also depressed the selection is extended to the first cell in the spreadsheet.
PAGE UP	Moves one page up in the spreadsheet. SHIFT + PAGE UP moves one page up in the spreadsheet and extends the selection CTRL + PAGE UP moves to the topmost cell that is currently visible SHIFT + CTRL + PAGE UP extends the selection to the topmost cell that is currently visible ALT + PAGE UP navigates to the previous spreadsheet, i.e. from the footer to main to header spreadsheets
PAGE DOWN	Moves one page down in the spreadsheet. SHIFT + PAGE DOWN moves one page down in the spreadsheet and extends the selection CTRL + PAGE DOWN moves to the bottommost cell that is currently visible SHIFT + CTRL + PAGE DOWN extends the selection to the bottommost cell that is currently visible ALT + PAGE DOWN navigates to the next spreadsheet, i.e. from the header to main to footer spreadsheets
TAB	Moves to the next cell in a spreadsheet SHIFT + TAB moves to the previous cell in a spreadsheet