DataLoad
DataLoad Window
Menu Functions
Using Spreadsheets
DataLoad Options
Formatting
Importing Data
Data Validation
Sorting Data
Protecting Loads

User Guide Home
DataLoad Home

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