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 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Īccess search (when in a cell or when a cell is selected) Move to the last cell in use on the sheet Move to the edge of the current data region Perform the action assigned to the default command button (the button with the bold outline, often the OK button) Move to the previous box, option, control, or command Move to the next box, option, control, or command Work in windows and dialogsĬopy the image of the screen and save it to a Screen Shot file on your desktop. In the Press new shortcut key box, type a key combination that includes at least one modifier key (, CONTROL, OPTION, SHIFT ) and an additional key, such as + F11. On the Tools menu, click Customize Keyboard.
Create a keyboard shortcut in Excel for Mac. Tutorial Formulas Examples VBA Functions Shortcuts.
Excel shortcut keys for mac mac#
To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key. This topic flags such shortcuts with an asterisk ( * ).
Excel shortcut keys for mac mac os#
*Some Windows keyboard shortcuts conflict with the corresponding default Mac OS keyboard shortcuts.
0 kommentar(er)
