50 Excel shortcuts to be a Hero

7 File Shortcuts:

Arrow - Save as = F12 - Save = Ctrl + S - Print = Ctrl + P - Close Excel = Alt + F4 - New workbook = Ctrl + N - Open workbook = Ctrl + O - Close current window = Ctrl + W

8 Format Shortcuts:

Arrow - Bold = Ctrl + B - Italics = Ctrl + I - Underline = Ctrl + U - Strikethrough = Ctrl + 5 - Date format = Ctrl + Shift + # - Number format = Ctrl + Shift + ! - Percentage format = Ctrl + Shift + % - Currency format = Ctrl + Shift + $

6 Navigation Shortcuts:

Arrow - Start of row = Home - Start of worksheet = Ctrl + Home - Prior sheet in workbook = Ctrl + Page Up - Next sheet in workbook = Ctrl + Page Down - Up or down to data edge = Ctrl + Up or Down Arrow - Left or right to data edge = Ctrl + Left or Right arrow

6 Copy, paste and paste special Shortcuts:

Arrow - Copy = Ctrl + C - Paste = Ctrl + V - Paste value = Alt, H, V, V - Paste format = Alt, H, V, R - Paste formula = Alt, H, V, F - Paste source + format = Alt, H, V, E

4 Insert and Delete Shortcuts:

Arrow - Select Row = Shift + Space Bar - Select Column = Ctrl + Space Bar - Delete Row or Column = Ctrl + - - Insert Row or Column = Ctrl + Shift + +

5 Adjust, group and ungroup row and column Shortcuts:

Arrow - Remove groups = Alt, A, U, C - Autofit row height = Alt, H, OA - Autofit column width = Alt, H, O, I - Group row or column = Shift + Alt + Right arrow - Ungroup row or column = Shift + Alt + Left arrow

7 Formula Shortcuts:

Arrow - Edit formula = F2 - Autosum = Alt + = - Toggle cell format = Ctrl + ` - Open insert function = Shift + F3 - Paste a formula as values = F2, F9 - Show formula bar = Ctrl + Shift + U - Copy formula from cell above = Ctrl + '

7 Bonus Shortcuts:

Arrow - Redo = Ctrl + Y - Undo = Ctrl + Z - Zoom in = Ctrl + Alt + = - Zoom out = Ctrl + Alt + - - Insert current date = Ctrl + ; - Insert current time = Ctrl + Shift + ; - Add row of text in a cell = Alt + Enter