Excel for Mac: Keyboard Shortcuts on a Small Keyboard

This week in our series about Microsoft Excel for Mac, we provide a list of keyboard shortcuts that are very helpful to know, especially if you’re using the keyboard on a MacBook.

When you’re using a MacBook, or any laptop, your keyboard is likely compact compared to a full desktop keyboard, so you may not have the keys for some well-known shortcuts, such as the Home, End and Page Up / Down keys.  We’ve compiled the list below to help you in that case.

Shortcuts for Editing:

• Delete the character to the right:  Fn + Delete or the “forward delete” key on extended keyboard
• Delete text to the end of the line:  CTRL + Fn + Delete or Control + the “forward delete” key

• Move to the beginning of the line of text:  Home or Fn + Left Arrow

Shortcuts for navigating:

• Move to the beginning of the row:  Home or Cmd + Left Arrow or Fn + Left Arrow
• Move to the end of the row: End or Cmd + Right Arrow or Fn + Right Arrow then Right Arrow (by itself)
• Move to A1 (first cell): CTRL + Home or CTRL + Fn + Left Arrow
• Move to the “Last Cell”: CTRL + End or CTRL + Fn + Right Arrow
• Move down one screen: Page Down or Fn + Down Arrow
• Move up one screen:  Page Up or Fn + Up Arrow
• Move one screen to the right: Option + Page Down or Fn + Option + Down Arrow
• Move one screen to the left: Option + Page Up or Fn + Option + Up Arrow
• Move to the next sheet in the workbook:  CTRL + Page Down or Option + Right Arrow
• Move to the previous sheet in the workbook:  CTRL + Page Down or Option + Left Arrow.

We hope you find this topic helpful.  Check back for more details about Excel for Mac and how it’s different to Excel for Windows.