top of page

Essential microsoft excel keyboard shortcuts

I made a quick overview of the most essential microsoft excel keyboard shortcuts. It is part of my series of productivity enhancement keyboard shortcuts for productivity software. They work on both windows and mac.


excel keyboard shortcuts




Excel keyboard shortcuts pdf

Click download pdf version to print.




General Shortcuts:

  • New Workbook: Ctrl/⌘ + N

  • Open Workbook: Ctrl/⌘ + O

  • Save Workbook: Ctrl/⌘ + S

  • Save As: F12 / Cmd + Shift + S

  • Print: Ctrl/⌘ + P

  • Close Workbook: Ctrl/⌘ + W

  • Undo: Ctrl/⌘ + Z

  • Redo: Ctrl + Y / Cmd + Shift + Z

  • Cut: Ctrl/⌘ + X

  • Copy: Ctrl/⌘ + C

  • Paste: Ctrl/⌘ + V

  • Select All: Ctrl/⌘ + A

  • Find: Ctrl/⌘ + F

  • Replace: Ctrl/⌘ + H


Navigation:

  • Move to Next Cell: Arrow Keys

  • Move to the Last Cell in Data Region: Ctrl + Arrow Keys / Cmd + Arrow Keys

  • Go to First Cell (A1): Ctrl + Home / Cmd + Home

  • Go to Last Cell with Data: Ctrl + End / Cmd + End

  • Move Between Worksheets: Ctrl + Page Up/Page Down / Option + Up/Down Arrow

  • Move to Next Worksheet: Ctrl + Shift + Page Down / Cmd + Shift + Down Arrow

  • Move to Previous Worksheet: Ctrl + Shift + Page Up / Cmd + Shift + Up Arrow


Selection Shortcuts:

  • Select Entire Worksheet: Ctrl/⌘ + A

  • Select Row: Shift + Space

  • Select Column: Ctrl + Space / Cmd + Space

  • Select to the End of Data: Ctrl + Shift + Arrow Keys / Cmd + Shift + Arrow Keys

  • Select a Range: Shift + Arrow Keys

  • Select Non-Adjacent Cells: Ctrl + Click / Cmd + Click


Editing:

  • Edit Active Cell: F2 / Ctrl + U

  • Fill Down: Ctrl + D / Cmd + D

  • Fill Right: Ctrl + R / Cmd + R

  • Insert Row: Ctrl + Shift + “+” / Cmd + Shift + “+”

  • Delete Row: Ctrl + “-” / Cmd + “-”

  • Insert Comment: Shift + F2 / Cmd + Shift + A


Formatting Shortcuts:

  • Bold: Ctrl/⌘ + B

  • Italic: Ctrl/⌘ + I

  • Underline: Ctrl/⌘ + U

  • Open Format Cells Dialog: Ctrl + 1 / Cmd + 1

  • Increase Font Size: Ctrl/⌘ + Shift + >

  • Decrease Font Size: Ctrl/⌘ + Shift + <

  • Center Align: Ctrl/⌘ + E

  • Left Align: Ctrl/⌘ + L

  • Right Align: Ctrl/⌘ + R

  • Add Border: Ctrl + Shift + & / Cmd + Option + 0


Formulas:

  • Start a Formula: Equals (=)

  • AutoSum: Alt + = / Cmd + Shift + T

  • Show Formulas: Ctrl + / Cmd +

  • Insert Function: Shift + F3 / Cmd + Shift + A

  • Absolute References (Toggle $): F4 / Cmd + T

  • Calculate Workbook: F9 / Cmd + =


Data Handling:

  • Apply Filter: Ctrl + Shift + L / Cmd + Shift + F

  • Remove Filter: Ctrl + Shift + L / Cmd + Shift + F

  • Sort Ascending: Alt + A + S + A / Cmd + Shift + A

  • Sort Descending: Alt + A + S + D / Cmd + Shift + D

  • Insert Table: Ctrl + T / Cmd + T


Viewing and Reviewing:

  • Zoom In: Ctrl + Plus (+) / Cmd + Option + Plus (+)

  • Zoom Out: Ctrl + Minus (-) / Cmd + Option + Minus (-)

  • Freeze Panes: Alt + W + F + F / Cmd + Shift + U

  • Switch to Full-Screen View: Ctrl + F1 / Cmd + Option + R


Mini review Logitech MX Keys S Wireless Keyboard the best keyboard I ever owned here.

2 views0 comments

Recent Posts

See All

Comments


bottom of page