Zo te zien gebruik je de verkeerde toetscombinatie:
Voor tijd in te voegen: CTRL + SHIFT + :
Hieronder een overzicht van mogelijk combinaties om data in te voeren.
Complete a cell entry and select the cell below.
ENTER
Start a new line in the same cell.
ALT+ENTER
Fill the selected cell range with the current entry.
CTRL+ENTER
Complete a cell entry and select the previous cell above.
SHIFT+ENTER
Complete a cell entry and select the next cell to the right.
TAB
Complete a cell entry and select the previous cell to the left.
SHIFT+TAB
Cancel a cell entry.
ESC
Move one character up, down, left, or right.
Arrow keys
Move to the beginning of the line.
HOME
Repeat the last action.
F4 or CTRL+Y
Create names (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) from row and column labels.
CTRL+SHIFT+F3
Fill down.
CTRL+D
Fill to the right.
CTRL+R
Define a name.
CTRL+F3
Insert a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.).
CTRL+K
Enter the date.
CTRL+; (semicolon)
Enter the time.
CTRL+SHIFT+: (colon)
Display a drop-down list of the values in the current column of a range.
ALT+DOWN ARROW
Undo the last action.
CTRL+Z
