1.                   

Ctrl+Shift+Colon (:)

Enter the current time.

2.                   

Ctrl+Semicolon (;)

Enter the current date.

3.                   

Ctrl+Apostrophe (‘)

Copy a formula from the cell above the active cell into the cell or the formula bar.

4.                   

Ctrl+Alt+V

Open the Paste Special dialog box.

5.                   

Ctrl+Shift+Ampersand sign (&)

Apply an outline border to the selected cells.

6.                   

Ctrl+Shift+Underscore (_)

Remove the outline border from the selected cells.

7.                   

Ctrl+Shift+Tilde sign (~)

Apply the General number format.

8.                   

Ctrl+Shift+Dollar sign ($)

Apply the Currency format with two decimal places (negative numbers in parentheses).

9.                   

Ctrl+Shift+Percent sign (%)

Apply the Percentage format with no decimal places.

10.               

Ctrl+Shift+Caret sign (^)

Apply the Scientific number format with two decimal places.

11.               

Ctrl+Shift+Number sign (#)

Apply the Date format with the day, month, and year.

12.               

Ctrl+Shift+At sign (@)

Apply the Time format with the hour and minute, and AM or PM.

13.               

Ctrl+Shift+Exclamation point (!)

Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

14.               

Ctrl+Shift+G

Open the Workbook Statistics dialog box.

15.               

Alt+Enter

Start a new line in the same cell.

16.               

Ctrl+Enter

Fill the selected cell range with the current entry.

17.               

Shift+Enter

Complete a cell entry and select the cell above.