EXCEL SHOTCUT KEYS2

Selection
Press To Select
Shift + Arrow Keys One cell in given direction
Ctrl + Shift + Arrow Keys To the edge of current data region
Ctrl + Spacebar Current column
Shift + Spacebar Current row
Ctrl + Shift + * Current region (contiguous rows/columns)
Alt + Semicolon Only visible cells
Shift + Home To the beginning of the row (from the active cell)
Ctrl + Shift + Home To the beginning of the sheet (from the active cell)
Ctrl + Shift + End To the end of the sheet (from the active cell)
Ctrl + A The entire worksheet
Ctrl + Shift + O Cells with comments
Data Entry
Press To
Enter, Tab or Arrow Keys Complete a cell entry
Esc Cancel data entry or editing
F2 Change to Edit Mode (in the active cell)
Ctrl + ; Insert the current date
Ctrl + Shift + : Insert the current time
Ctrl + K Insert a hyperlink
Ctrl + ‘ or Ctrl + Shift + “ Copy the value from the cell above
Alt + down arrow Display the AutoComplete list
(unique values in column)
Alt + Enter Start a new line in a cell
Ctrl + D Fill down (after a range is selected)
Ctrl + R Fill right (after a range is selected)
Ctrl + Enter Fill the selected range with the current entry
‘ Designate a number as text
Formulas
Press To
= (equal sign) Start a formula
Alt + = (equal sign) Insert the AutoSum function
F3 Paste a name into a formula
F9 Calculate all sheets in workbook
Shift + F9 Calculate the active sheet
Ctrl + ~ (tilde) Toggle between displaying formulas and values
Ctrl + Shift + Enter Enter the formula as an array
Editing
Press To
Ctrl + C Copy
Ctrl + X Cut
Ctrl + V Paste
Ctrl + Z Undo
Ctrl + - Delete cells
Ctrl + Shift + + Insert cells
Delete Clear the contents of the selected cell(s)
Backspace / Delete Delete the character to the left / right of the insertion
point (while in edit mode)
Ctrl + Delete Delete to the end of the line (from the insertion point)
Formatting
Press To
Ctrl + 1 Display the Format Cells dialog window
Ctrl + Shift ~ (tilde) Apply General number formatting
Ctrl + Shift + $ Apply Currency formatting
Ctrl + Shift + ! Apply Number formatting
(two decimals, thousands separator)
Ctrl + Shift + % Apply Percent formatting (no decimals)
Ctrl + Shift + ^ Apply Exponential formatting (no decimals)
Ctrl + Shift + # Apply Date formatting (d-m-yy)
Ctrl + Shift + @ Apply Time formatting
Ctrl + Shift + & Apply outline border
Ctrl + Shift + _ Remove all borders
Ctrl + B Apply or remove bold formatting
Ctrl + I Apply or remove italic formatting
Ctrl + U Apply or remove underline formatting
Ctrl + 5 Apply or remove strikethrough formatting
Ctrl + 9 Hide rows
Ctrl + Shift + ( Unhide rows
Ctrl + 0 (zero) Hide columns
Ctrl + Shift + ) Unhide columns
Select Chart Items
Press To Select
Down / Up Arrow The previous / next group of items
Right / Left Arrow The next / previous item within the group
Source: Microsoft Excel Help Excel Shortcut Booklet –01/23