Short keys

Shortcuts                   Description
CTRL + ;    For current date.
CTRL + 9          Hide selected rows.
CTRL + 0Hide selected columns.
CTRL + KTo insert Hyperlink.
CTRL + HOpens up the Find and Replace dialog box.
ALT + F1This creates a chart out of the data in the current range (selected cells).
ALT + SHIFT + F1Inserts a new worksheet into a workbook.
Alt + EscCycle through items in the order in which they were opened.
CTRL + DFill down command on the selected cells. Fill down copies the content and format of the topmost cell into the cells below.
CTRL + RFill right command on the selected cells. Fill right copies the content and format of the leftmost cell to the cells to the right.
CTRL + SPACEBARSelects an entire column in a worksheet.
SHIFT + SPACEBARSelects an entire row in a worksheet.
CTRL + SHIFT + 1Number formatting with two decimal places.
CTRL + SHIFT + 2Format as time.
CTRL + SHIFT + 3Format as date.
CTRL + SHIFT + 4 Format as currency value ($).
CTRL + SHIFT + 5Format as percentage.
CTRL + SHIFT + 6Format number in exponential form also known as scientific form.
ALT + =Auto sum.
ALTLetter gets highlighted.
F4Do something, and press F4 to repeat the action.
CTRL + 1Format a cell quickly.
CTRL + ASelect All.
CTRL + PgDn/PgUpScroll thourgh Worksheets.
CTRL + SHIFT + PgDn/PgUp  Select Multiple Sheets at same time.
CTRL + WClose A Workbook.
SHIFT + F11Insert New Sheet.
CTRL + ARROWSGo to extreme ends of data.
CTRL + ENDGo to end of data.
F12Save As.
ALT + F11Go to VBA Screen.