However, if working on Excel for Mac (no Windows installed), the most important differences in shortcuts are listed below: Windows Mac SUM (a) Edit Mode Anchor Cell (in edit mode) Jump Cells (b) (a) Also applies to Excel for Mac 2016 (b) To utilize Ctrl + arrow keys, uncheck Mission Control keyboard shortcuts in System Preferences (see Mac Excel Setup Guide) Apple Keyboard Compatibility The Apple keyboard has the same functionality as a Windows keyboard, with the latter having additional dedicated keys. If working on a Mac, we highly recommend installing Windows as a virtual machine (WST recommends VMware) and installing Excel for Windows. Training recommends Excel for Windows due to keyboard shortcut Compatibility issues. Training (212) 537-6631 Mac Excel Compatibility Critical Keyboard Shortcuts Excel for Mac (2008 & 2011) Wall St. To access the same features on an Apple keyboard: Windows Mac ADVANCED Excel KEYBOARD SHORTCUTS MACINTOSHEXCEL KEYSTROKESACTIONEXCEL KEYSTROKESACTIONDATA SELECTION / NAVIGATIONFORMATTINGCtrl + Pg Up / Pg DownMove to Prior / Next Worksheetz + Shift + VPaste Special (copy first)Shift / Ctrl + SpacebarSelect Entire Row / Columnz + B / U / IToggle Bold / Underline / ItalicCtrl + * (Ctrl + Shift + 8)Select All Adjacent Cellsz + 1 Format Cellsz + ASelect Entire Worksheetz + Option + 0 Box SelectionShift + F8 AddĪDVANCED EXCEL KEYBOARD SHORTCUTS – MACINTOSH EXCEL KEYSTROKES ACTION EXCEL KEYSTROKES ACTION DATA SELECTION / NAVIGATION FORMATTING Ctrl + Pg Up / Pg Down Move to Prior / Next Worksheet z + Shift + V Paste Special (copy first)ġ Wall St.
Example: quiz answers Search Mac Excel Compatibility - Wall St.
0 kommentar(er)
