Keyboard shortcuts for mac excel 2016 windows#

Then select the check box for Use all F1, F2, etc. Insert special characters like symbols, including Emoji

Keyboard shortcuts for mac excel 2016 windows#

Discover 242 Excel Keyboard Shortcuts for Windows and Mac. Toggle the formula reference style between absolute, relative, and mixedĬopy the value from the cell above the active cell into the cell or the formula barĪlternate between displaying cell values and displaying cell formulasĬopy a formula from the cell above the active cell into the cell or the formula bar Users of Mac Excel 2016 can use the ALT shortcut used on Windows.

Move one character up, down, left, or rightĮdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsĬancel an entry in the cell or formula barĭisplay the Formula Builder after you type a valid function name in a formulaĮdit the active cell and position the insertion point at the end of the line Note: Some smaller keyboards do not have this key Move between unlocked cells on a protected sheetĬomplete a cell entry and move forward in the selectionįill the selected cell range with the text that you typeĬomplete a cell entry and move up in the selectionĬomplete a cell entry and move to the right in the selectionĬomplete a cell entry and move to the left in the selectionĭelete the character to the left of the insertion point, or delete the selectionĭelete the character to the right of the insertion point, or delete the selection Move to the previous sheet in the workbook Move to the last cell in use on the sheet

New Perspectives Excel 2016 Module 3: SAM Project 1a. Move to the edge of the current data region Everything in this tutorial with the exception of keyboard shortcuts will work in Excel for Mac. as standard function keys.ĭisplay a contextual menu, or 'right click' menu Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel 2016 for Mac. If you don't want to press the FN key each time, you can change your system preferences: Go to Apple > System Preferences > Keyboard. Note: If a function key doesn't work as you expect it to, press the FN key in addition to the function key.