top of page
Writer's pictureCasper Andersen

Essential Numbers keyboard shortcuts

I made a quick overview of the most essential Numbers keyboard shortcuts It is part of my series of productivity enhancement keyboard shortcuts for productivity software.


Numbers keyboard shortcuts




Numbers keyboard shortcuts pdf

Click download pdf version to print.



General Shortcuts

  • New Spreadsheet: Cmd + N

  • Open Spreadsheet: Cmd + O

  • Save Spreadsheet: Cmd + S

  • Save As: Cmd + Shift + S

  • Close Spreadsheet: Cmd + W

  • Print Spreadsheet: Cmd + P

  • Undo: Cmd + Z

  • Redo: Cmd + Shift + Z

  • Cut: Cmd + X

  • Copy: Cmd + C

  • Paste: Cmd + V

  • Duplicate: Cmd + D

  • Select All: Cmd + A

  • Find: Cmd + F

  • Replace: Cmd + Shift + H


Navigation

  • Move to Next Cell: Tab

  • Move to Previous Cell: Shift + Tab

  • Move to Beginning of Row: Cmd + Left Arrow

  • Move to End of Row: Cmd + Right Arrow

  • Move to Beginning of Column: Cmd + Up Arrow

  • Move to End of Column: Cmd + Down Arrow

  • Jump to First Cell: Cmd + Home

  • Jump to Last Cell: Cmd + End

Editing and Formatting Cells

  • Edit Cell: Return or Enter

  • Add New Line in Cell: Option + Return

  • Bold Text: Cmd + B

  • Italic Text: Cmd + I

  • Underline Text: Cmd + U

  • Increase Font Size: Cmd + +

  • Decrease Font Size: Cmd + -

  • Format as Currency: Cmd + Shift + $

  • Format as Percentage: Cmd + Shift + %


Working with Rows and Columns

  • Add Row: Option + Cmd + Down Arrow

  • Add Column: Option + Cmd + Right Arrow

  • Delete Row: Cmd + Delete

  • Delete Column: Cmd + Delete (when a column is selected)

  • Select Entire Row: Shift + Space

  • Select Entire Column: Cmd + Space

  • Hide Row: Cmd + Option + –

  • Hide Column: Cmd + Option + ]

  • Unhide Rows/Columns: Cmd + Option + [ or Cmd + Option + ]


Formulas and Calculations

  • Insert Formula: = (starts typing a formula)

  • Sum Function: Cmd + Shift + T

  • Auto-Fill: Cmd + Shift + Y

  • Expand Selection to Next Non-Empty Cell: Shift + Arrow Keys

  • Quick Fill Down: Cmd + D

  • Quick Fill Right: Cmd + R


View and Zoom

  • Zoom In: Cmd + +

  • Zoom Out: Cmd + -

  • Fit to Window: Cmd + 0

  • Full-Screen Mode: Ctrl + Cmd + F

  • Show/Hide Sidebar: Cmd + Option + S


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

1 view0 comments

Recent Posts

See All

Comments


bottom of page