If you are using a UK keyboard typing CTRL+# on a date cell will format the date to dd-mmm-yy.

The US keyboard is CTRL+SHIFT+#

Entering data
ENTER
Complete a cell entry and select the cell below.
ALT+ENTER
Start a new line in the same cell.
CTRL+ENTER
Fill the selected cell range with the current entry.
SHIFT+ENTER
Complete a cell entry and select the previous cell above.
TAB
Complete a cell entry and select the next cell to the right.
SHIFT+TAB
Complete a cell entry and select the previous cell to the left.
ESC
Cancel a cell entry.
Arrow keys
Move one character up, down, left, or right.
HOME
Move to the beginning of the line.
F4 or CTRL+Y
Repeat the last action.
CTRL+SHIFT+F3
Create names from row and column labels.
CTRL+D
Fill down.
CTRL+R
Fill to the right.
CTRL+F3
Define a name.
CTRL+K
Insert a hyperlink.
CTRL+; (semicolon)
Enter the date.
CTRL+SHIFT+: (colon)
Enter the time.
ALT+DOWN ARROW
Display a drop-down list of the values in the current column of a range.
CTRL+Z
Undo the last action.

Here are some keyboard shortcuts to help you work with macros

ALT+F8
Displays the Macro dialog box.

ALT+F11
Displays the Visual Basic Editor.

CTRL+F11
Inserts a Microsoft Excel 4.0 macro sheet.