• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 11: Appendixes > Enter Data

Enter Data

PressTo
EnterComplete a cell entry and select the cell below. Alt+Enter Start a new line in the same cell.
Ctrl+EnterFill the selected cell range with the current entry.
Shift+EnterComplete a cell entry and select the previous cell above.
TabComplete a cell entry and select the next cell to the right.
Shift+TabComplete a cell entry and select the previous cell to the left.
EscCancel a cell entry.
Arrow keysMove one character up, down, left, or right.
HomeMove to the beginning of the line.
F4 or Ctrl+YRepeat the last action.
Ctrl+Shift+F3Create names from row and column labels.
Ctrl+DFill down.
Ctrl+RFill to the right.
Ctrl+F3Define a name.
Ctrl+KInsert a hyperlink.
Ctrl+; (semicolon)Enter the date.
Ctrl+Shift+: (colon)Enter the time.
Alt+Down ArrowDisplay a drop-down list of the values in the current column of a list if your cursor is in the cell containing the column name.
Ctrl+ZUndo the last action.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint