Hotkey Excel For Mac
2021年2月10日Download here: http://gg.gg/o9o35
1. Frequently used shortcuts⌘+V or Ctrl+VPaste⌘+C or Ctrl+CCopyDeleteClear⌘+S or Ctrl+SSave⌘+Z or Ctrl+ZUndo⌘+Y or Ctrl+YRedo⌘+X or Ctrl+XCut⌘+B or Ctrl+BBold⌘+P or Ctrl+PPrintOption+F11Open Visual Basic⌘+D or Ctrl+DFill Down⌘+R or Ctrl+RFill RightCtrl+Shift+=Insert cells⌘+- or Ctrl+- (hyphen)Delete cells⌘+= or F9Calculate all open workbooks⌘+W or Ctrl+WClose window⌘+QQuit ExcelCtrl+G or F5Display the Go To dialog box⌘+1 or Ctrl+1Display the Format Cells dialog boxCtrl+H or ⌘+Shift+HDisplay the Replace dialog box⌘+Ctrl+V or Ctrl+Option+VPaste Special⌘+UUnderline⌘+I or Ctrl+IItalic⌘+N or Ctrl+NNew blank workbook⌘+Shift+PNew workbook from template⌘+Shift+S or F12Display the Save As dialog boxF1 or ⌘+/Display the Help window⌘+A or ⌘+Shift+SpaceSelect All⌘+Shift+F or Ctrl+Shift+LAdd or remove a filter⌘+Option+R or Ctrl+OMinimize or maximize the ribbon tabs⌘+ODisplay the Open dialog boxF7Check spellingShift+F7Open the thesaurusShift+F3Display the Formula Builder⌘+F3Open the Define Name dialog box⌘+Shift+F3Open the Create names dialog boxShift+F11Insert a new sheet *⌘+P or Ctrl+PPrint⌘+P or Ctrl+PPrint preview*Some Windows keyboard shortcuts conflict with the corresponding default Mac OS keyboard shortcuts. This topic flags such shortcuts with an asterisk ( * ). To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.
▲ up
Using the Approximately Equal Alt Code for Windows. The Approximately Equal to symbol alt code. 7 Little-Known But Super Useful Excel Shortcuts For Windows and Mac Written by co-founder Kasper Langmann, Microsoft Office Specialist. Keyboard shortcuts help save time and increase productivity. Unfortunately, most people only know the holy trinity of shortcuts — COPY, PASTE, and UNDO. Increase/Decrease Font Size – SHIFT+COMMAND+. (increase) SHIFT+COMMAND+, (decrease) The. .Excel 2016 for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don’t have to press the FN key every time you use a function key shortcut.
Excel keyboard shortcuts (Windows and Mac) File. Create new workbook.2. Work in windows and dialogs⌘+Option+RExpand or minimize the ribbon⌘+Ctrl+FSwitch to full screen view⌘+TabSwitch to the next application⌘+Shift+TabSwitch to the previous application⌘+WClose the active workbook window⌘+Shift+3Copy the image of the screen and save it to a Screen Shot file on your desktop.Ctrl+F9Minimize the active windowCtrl+F10 or ⌘+F10Maximize or restore the active window⌘+HHide Excel.TabMove to the next box, option, control, or commandShift+TabMove to the previous box, option, control, or commandEscExit a dialog or cancel an actionEnterPerform the action assigned to the default command button (the button with the bold outline, often the OK button)EscCancel the command and close
▲ up3. Move and scroll in a sheet or workbookArrow KeysMove one cell up, down, left, or right⌘+Arrow KeyMove to the edge of the current data regionHomeMove to the beginning of the rowCtrl+HomeMove to the beginning of the sheetCtrl+EndMove to the last cell in use on the sheetPage DownMove down one screenPage UpMove up one screenOption+Page DownMove one screen to the rightOption+Page UpMove one screen to the leftCtrl+Page Down or Option+Arrow RightMove to the next sheet in the workbookCtrl+Page Down or Option+Arrow LeftMove to the previous sheet in the workbookCtrl+DeleteScroll to display the active cellCtrl+GDisplay the Go To dialog boxCtrl+F or Shift+F5Display the Find dialog box⌘+FAccess search (when in a cell or when a cell is selected)TabMove between unlocked cells on a protected sheet
▲ up4. Enter data on a sheetF2Edit the selected cellEnterComplete a cell entry and move forward in the selectionCtrl+Option+EnterStart a new line in the same cell⌘+Return or Ctrl+EnterFill the selected cell range with the text that you typeShift+EnterComplete a cell entry and move up in the selectionTabComplete a cell entry and move to the right in the selectionShift+TabComplete a cell entry and move to the left in the selectionEscCancel a cell entryDeleteDelete the character to the left of the insertion point, or delete the selectionDelete the character to the right of the insertion point, or delete the selectionOn a MacBook, pressFn+DeleteNote: Some smaller keyboards do not have this keyNote: Some smaller keyboards do not have this keyArrow KeysMove one character up, down, left, or rightHomeMove to the beginning of the lineShift+F2Insert a commentShift+F2Open and edit a cell commentCtrl+D or ⌘+DFill downCtrl+R or ⌘+RFill to the rightCtrl+LDefine a name
▲ up5. Work in cells or the Formula barF2Edit the selected cellDeleteEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsEnterComplete a cell entry⌘+Shift+Return or Ctrl+Shift+EnterEnter a formula as an array formulaEscCancel an entry in the cell or formula barCtrl+ADisplay the Formula Builder after you type a valid function name in a formula⌘+K or Ctrl+KInsert a hyperlinkCtrl+UEdit the active cell and position the insertion point at the end of the lineShift+F3Open the Formula BuilderShift+F9Calculate the active sheetShift+F10Display a contextual menu=Start a formula⌘+T or F4Toggle the formula reference style between absolute, relative, and mixed⌘+Shift+TInsert the AutoSum formulaCtrl+; (semicolon)Enter the date⌘+; (semicolon)Enter the timeCtrl+Shift+’ (inchmark)Copy the value from the cell above the active cell into the cell or the formula barCtrl+` (grave accent)Alternate between displaying cell values and displaying cell formulasCtrl+’ (apostrophe))Copy a formula from the cell above the active cell into the cell or the formula barCtrl+Option+Arrow DownDisplay the AutoComplete listCtrl+LDefine a nameCtrl+Option+⌘+LOpen the Smart Lookup pane
▲ up6. Format and edit dataF2Edit the selected cell⌘+T or Ctrl+TCreate a table⌘+Option+Return or Ctrl+Option+EnterInsert a line break in a cellCtrl+Spacebar or ⌘+SpaceInsert special characters like symbols, including emoji⌘+Shift+>Increase font size⌘+Shift+<Decrease font size⌘+EAlign center⌘+LAlign left⌘+Shift+LDisplay the Modify Cell Style dialog box⌘+1Display the Format Cells dialog boxCtrl+Shift+~Apply the general number formatCtrl+Shift+$Apply the currency format with two decimal places (negative numbers appear in red with parentheses)Ctrl+Shift+%Apply the percentage format with no decimal placesCtrl+Shift+^Apply the exponential number format with two decimal placesCtrl+Shift+#Apply the date format with the day, month, and yearCtrl+Shift+@Apply the time format with the hour and minute, and indicate AM or PMCtrl+Shift+!Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values⌘+Option+0Apply the outline border around the selected cells⌘+Option+Arrow RightAdd an outline border to the right of the selection⌘+Option+Arrow LeftAdd an outline border to the left of the selection⌘+Option+Arrow UpAdd an outline border to the top of the selection⌘+Option+Arrow DownAdd an outline border to the bottom of the selection⌘+Option+- (hyphen)Remove outline borders⌘+BApply or remove bold formatting⌘+IApply or remove italic formatting⌘+UApply or remove underscoring⌘+Shift+XApply or remove strikethrough formatting⌘+) or Ctrl+)Hide a column⌘+Shift+) or Ctrl+Shift+)Unhide a column⌘+( or Ctrl+(Hide a row⌘+Shift+( or Ctrl+Shift+(Unhide a rowCtrl+UEdit the active cellEscCancel an entry in the cell or the formula barDeleteEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents⌘+VPaste text into the active cellEnterComplete a cell entry⌘+Return or Ctrl+EnterGive selected cells the current cell’s entry⌘+Shift+Return or Ctrl+Shift+EnterEnter a formula as an array formulaCtrl+ADisplay the Formula Builder after you type a valid function name in a formula
▲ up7. Select cells, columns, or rowsShift+Arrow KeyExtend the selection by one cell⌘+Shift+Arrow KeyExtend the selection to the last nonblank cell in the same column or row as the active cellShift+HomeExtend the selection to the beginning of the rowCtrl+Shift+HomeExtend the selection to the beginning of the sheetCtrl+Shift+EndExtend the selection to the last cell used on the sheet (lower-right corner)Ctrl+SpaceSelect the entire columnShift+SpaceSelect the entire row⌘+ASelect the entire sheet⌘+Shift+* (asterisk)Select only visible cellsShift+DeleteSelect only the active cell when multiple cells are selectedShift+Page DownExtend the selection down one screenShift+Page UpExtend the selection up one screenCtrl+6Alternate between hiding objects, displaying objects, and displaying placeholders for objectsF8Turn on the capability to extend a selection by using the arrow keysShift+F8Add another range of cells to the selectionCtrl+/Select the current array, which is the array that the active cell belongs to.Ctrl+Select cells in a row that don’t match the value in the active cell in that row. You must select the row starting with the active cell.Ctrl+Shift+[Select only cells that are directly referred to by formulas in the selectionCtrl+Shift+{Select all cells that are directly or indirectly referred to by formulas in the selectionCtrl+]Select only cells with formulas that refer directly to the active cellCtrl+Shift+}Select all cells with formulas that refer directly or indirectly to the active cell
▲ up8. Work with a selection⌘+C or Ctrl+CCopy⌘+V or Ctrl+VPaste⌘+X or Ctrl+XCutDeleteClearCtrl+- (hyphen)Delete the selection⌘+ZUndo the last action⌘+) or Ctrl+)Hide a column⌘+Shift+) or Ctrl+Shift+)Unhide a column⌘+( or Ctrl+(Hide a row⌘+Shift+( or Ctrl+Shift+(Unhide a rowEnterMove from top to bottom within the selection (down)*Shift+EnterMove from bottom to top within the selection (up)*TabMove from left to right within the selection, or move down one cell if only one column is selectedShift+TabMove from right to left within the selection, or move down one cell if only one column is selectedCtrl+. (period)Move clockwise to the next corner of the selection⌘+Shift+KGroup selected cells⌘+Shift+JUngroup selected cells*These shortcuts may move in another direction other than down or up. If you’d like to change the direction of these shortcuts using the mouse, on the Excel menu, click Preferences, click Edit, and then, under. After pressing Return, move selection, select the direction you want to move in.
▲ up9. Use chartsF11Insert a new chart sheet.ArrowKeysCycle through chart object selection
▲ up10. Sort, filter, and use PivotTable reports⌘+Shift+ROpen the Sort dialog box⌘+Shift+F or Ctrl+Shift+LAdd or remove a filterOption+Arrow DownDisplay the Filter list or PivotTable page field pop-up menu for the selected cell
▲ up11. Outline dataCtrl+8Display or hide outline symbolsCtrl+9Hide selected rowsCtrl+Shift+( (opening parenthesis)Unhide selected rowsCtrl+0 (zero)Hide selected columnsCtrl+Shift+) (closing parenthesis)Unhide selected columns
▲ up12. The following table provides the function key shortcuts for Excel 2016 for Mac*F1Display the Help windowF2Edit the selected cellShift+F2Insert or edit a cell commentOption+F2Open the Save dialogShift+F3Open the Formula Builder⌘+F3Open the Define Name dialog⌘+F4CloseF5Display the Go To dialogShift+F5Display the Find dialogCtrl+F5Move to the Search Sheet dialogF7Check spellingShift+F7 or Ctrl+Option+⌘+ROpen the thesaurusF8Extend the selectionShift+F8Add to the selectionOption+F8Display the Macro dialogF9Calculate all open workbooksShift+F9Calculate the active sheetCtrl+F9Minimize the active windowShift+F10Display a contextual menu, or ’right click’ menuCtrl+F10 or ⌘+F10Maximize or restore the active windowF11Insert a new chart sheet*Shift+F11Insert a new sheet*⌘+F11Insert an Excel 4.0 macro sheetOption+F11Open Visual BasicF12Display the Save As dialog⌘+F12Display the Open dialog*Excel 2016 for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don’t have to press the FN key every time you use a function key shortcut
▲ upMac Hotkeys Pdf
To use a keyboard shortcut, press and hold one or more modifier keys and then press the last key of the shortcut. For example, to use Command-C (copy), press and hold the Command key, then the C key, then release both keys. Mac menus and keyboards often use symbols for certain keys, including modifier keys:
On keyboards made for Windows PCs, use the Alt key instead of Option, and the Windows logo key instead of Command.
Some keys on some Apple keyboards have special symbols and functions, such as for display brightness , keyboard brightness , Mission Control, and more. If these functions aren’t available on your keyboard, you might be able to reproduce some of them by creating your own keyboard shortcuts. To use these keys as F1, F2, F3, or other standard function keys, combine them with the Fn key.Cut, copy, paste, and other common shortcuts
*Command-X: Cut the selected item and copy it to the Clipboard.
*Command-C: Copy the selected item to the Clipboard. This also works for files in the Finder.
*Command-V: Paste the contents of the Clipboard into the current document or app. This also works for files in the Finder.
*Command-Z: Undo the previous command. You can then press Shift-Command-Z to Redo, reversing the undo command. In some apps, you can undo and redo multiple commands.
*Command-A: Select All items.
*Command-F: Find items in a document or open a Find window.
*Command-G: Find Again: Find the next occurrence of the item previously found. To find the previous occurrence, press Shift-Command-G.
*Command-H: Hide the windows of the front app. To view the front app but hide all other apps, press Option-Command-H.
*Command-M: Minimize the front window to the Dock. To minimize all windows of the front app, press Option-Command-M.
*Command-O: Open the selected item, or open a dialog to select a file to open.
*Command-P: Print the current document.
*Command-S: Save the current document.
*Command-T: Open a new tab.
*Command-W: Close the front window. To close all windows of the app, press Option-Command-W.
*Option-Command-Esc: Force quit an app.
*Command–Space bar: Show or hide the Spotlight search field. To perform a Spotlight search from a Finder window, press Command–Option–Space bar. (If you use multiple input sources to type in different languages, these shortcuts change input sources instead of showing Spotlight. Learn how to change a conflicting keyboard shortcut.)
*Control–Command–Space bar: Show the Character Viewer, from which you can choose emoji and other symbols.
*Control-Command-F: Use the app in full screen, if supported by the app.
*Space bar: Use Quick Look to preview the selected item.
*Command-Tab: Switch to the next most recently used app among your open apps.
*Shift-Command-5: In macOS Mojave or later, take a screenshot or make a screen recording. Or use Shift-Command-3 or Shift-Command-4 for screenshots. Learn more about screenshots.
*Shift-Command-N: Create a new folder in the Finder.
*Command-Comma (,): Open preferences for the front app.Sleep, log out, and shut down shortcuts
You might need to press and hold some of these shortcuts for slightly longer than other shortcuts. This helps you to avoid using them unintentionally.
*Power button: Press to turn on your Mac or wake it from sleep. Press and hold for 1.5 seconds to put your Mac to sleep.* Continue holding to force your Mac to turn off.
*Option–Command–Power button* or Option–Command–Media Eject : Put your Mac to sleep.
*Control–Shift–Power button* or Control–Shift–Media Eject : Put your displays to sleep.
*Control–Power button* or Control–Media Eject : Display a dialog asking whether you want to restart, sleep, or shut down.
*Control–Command–Power button:* Force your Mac to restart, without prompting to save any open and unsaved documents.
*Control–Command–Media Eject : Quit all apps, then restart your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
*Control–Option–Command–Power button* or Control–Option–Command–Media Eject : Quit all apps, then shut down your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
*Control-Command-Q: Immediately lock your screen.
*Shift-Command-Q: Log out of your macOS user account. You will be asked to confirm. To log out immediately without confirming, press Option-Shift-Command-Q.
* Does not apply to the Touch ID sensor.Finder and system shortcuts
*Command-D: Duplicate the selected files.
*Command-E: Eject the selected disk or volume.
*Command-F: Start a Spotlight search in the Finder window.
*Command-I: Show the Get Info window for a selected file.
*Command-R: (1) When an alias is selected in the Finder: show the original file for the selected alias. (2) In some apps, such as Calendar or Safari, refresh or reload the page. (3) In Software Update preferences, check for software updates again.
*Shift-Command-C: Open the Computer window.
*Shift-Command-D: Open the desktop folder.
*Shift-Command-F: Open the Recents window, showing all of the files you viewed or changed recently.
*Shift-Command-G: Open a Go to Folder window.
*Shift-Command-H: Open the Home folder of the current macOS user account.
*Shift-Command-I: Open iCloud Drive.
*Shift-Command-K: Open the Network window.
*Option-Command-L: Open the Downloads folder.
*Shift-Command-N: Create a new folder.
*Shift-Command-O: Open the Documents folder.
*Shift-Command-P: Show or hide the Preview pane in Finder windows.
*Shift-Command-R: Open the AirDrop window.
*Shift-Command-T: Show or hide the tab bar in Finder windows.
*Control-Shift-Command-T: Add selected Finder item to the Dock (OS X Mavericks or later)
*Shift-Command-U: Open the Utilities folder.
*Option-Command-D: Show or hide the Dock.
*Control-Command-T: Add the selected item to the sidebar (OS X Mavericks or later).
*Option-Command-P: Hide or show the path bar in Finder windows.
*Option-Command-S: Hide or show the Sidebar in Finder windows.
*Command–Slash (/): Hide or show the status bar in Finder windows.
*Command-J: Show View Options.
*Command-K: Open the Connect to Server window.
*Control-Command-A: Make an alias of the selected item.
*Command-N: Open a new Finder window.
*Option-Command-N: Create a new Smart Folder.
*Command-T: Show or hide the tab bar when a single tab is open in the current Finder window.
*Option-Command-T: Show or hide the toolbar when a single tab is open in the current Finder window.
*Option-Command-V: Move the files in the Clipboard from their original location to the current location.
*Command-Y: Use Quick Look to preview the selected files.
*Option-Command-Y: View a Quick Look slideshow of the selected files.
*Command-1: View the items in the Finder window as icons.
https://diarynote.indered.space
1. Frequently used shortcuts⌘+V or Ctrl+VPaste⌘+C or Ctrl+CCopyDeleteClear⌘+S or Ctrl+SSave⌘+Z or Ctrl+ZUndo⌘+Y or Ctrl+YRedo⌘+X or Ctrl+XCut⌘+B or Ctrl+BBold⌘+P or Ctrl+PPrintOption+F11Open Visual Basic⌘+D or Ctrl+DFill Down⌘+R or Ctrl+RFill RightCtrl+Shift+=Insert cells⌘+- or Ctrl+- (hyphen)Delete cells⌘+= or F9Calculate all open workbooks⌘+W or Ctrl+WClose window⌘+QQuit ExcelCtrl+G or F5Display the Go To dialog box⌘+1 or Ctrl+1Display the Format Cells dialog boxCtrl+H or ⌘+Shift+HDisplay the Replace dialog box⌘+Ctrl+V or Ctrl+Option+VPaste Special⌘+UUnderline⌘+I or Ctrl+IItalic⌘+N or Ctrl+NNew blank workbook⌘+Shift+PNew workbook from template⌘+Shift+S or F12Display the Save As dialog boxF1 or ⌘+/Display the Help window⌘+A or ⌘+Shift+SpaceSelect All⌘+Shift+F or Ctrl+Shift+LAdd or remove a filter⌘+Option+R or Ctrl+OMinimize or maximize the ribbon tabs⌘+ODisplay the Open dialog boxF7Check spellingShift+F7Open the thesaurusShift+F3Display the Formula Builder⌘+F3Open the Define Name dialog box⌘+Shift+F3Open the Create names dialog boxShift+F11Insert a new sheet *⌘+P or Ctrl+PPrint⌘+P or Ctrl+PPrint preview*Some Windows keyboard shortcuts conflict with the corresponding default Mac OS keyboard shortcuts. This topic flags such shortcuts with an asterisk ( * ). To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.
▲ up
Using the Approximately Equal Alt Code for Windows. The Approximately Equal to symbol alt code. 7 Little-Known But Super Useful Excel Shortcuts For Windows and Mac Written by co-founder Kasper Langmann, Microsoft Office Specialist. Keyboard shortcuts help save time and increase productivity. Unfortunately, most people only know the holy trinity of shortcuts — COPY, PASTE, and UNDO. Increase/Decrease Font Size – SHIFT+COMMAND+. (increase) SHIFT+COMMAND+, (decrease) The. .Excel 2016 for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don’t have to press the FN key every time you use a function key shortcut.
Excel keyboard shortcuts (Windows and Mac) File. Create new workbook.2. Work in windows and dialogs⌘+Option+RExpand or minimize the ribbon⌘+Ctrl+FSwitch to full screen view⌘+TabSwitch to the next application⌘+Shift+TabSwitch to the previous application⌘+WClose the active workbook window⌘+Shift+3Copy the image of the screen and save it to a Screen Shot file on your desktop.Ctrl+F9Minimize the active windowCtrl+F10 or ⌘+F10Maximize or restore the active window⌘+HHide Excel.TabMove to the next box, option, control, or commandShift+TabMove to the previous box, option, control, or commandEscExit a dialog or cancel an actionEnterPerform the action assigned to the default command button (the button with the bold outline, often the OK button)EscCancel the command and close
▲ up3. Move and scroll in a sheet or workbookArrow KeysMove one cell up, down, left, or right⌘+Arrow KeyMove to the edge of the current data regionHomeMove to the beginning of the rowCtrl+HomeMove to the beginning of the sheetCtrl+EndMove to the last cell in use on the sheetPage DownMove down one screenPage UpMove up one screenOption+Page DownMove one screen to the rightOption+Page UpMove one screen to the leftCtrl+Page Down or Option+Arrow RightMove to the next sheet in the workbookCtrl+Page Down or Option+Arrow LeftMove to the previous sheet in the workbookCtrl+DeleteScroll to display the active cellCtrl+GDisplay the Go To dialog boxCtrl+F or Shift+F5Display the Find dialog box⌘+FAccess search (when in a cell or when a cell is selected)TabMove between unlocked cells on a protected sheet
▲ up4. Enter data on a sheetF2Edit the selected cellEnterComplete a cell entry and move forward in the selectionCtrl+Option+EnterStart a new line in the same cell⌘+Return or Ctrl+EnterFill the selected cell range with the text that you typeShift+EnterComplete a cell entry and move up in the selectionTabComplete a cell entry and move to the right in the selectionShift+TabComplete a cell entry and move to the left in the selectionEscCancel a cell entryDeleteDelete the character to the left of the insertion point, or delete the selectionDelete the character to the right of the insertion point, or delete the selectionOn a MacBook, pressFn+DeleteNote: Some smaller keyboards do not have this keyNote: Some smaller keyboards do not have this keyArrow KeysMove one character up, down, left, or rightHomeMove to the beginning of the lineShift+F2Insert a commentShift+F2Open and edit a cell commentCtrl+D or ⌘+DFill downCtrl+R or ⌘+RFill to the rightCtrl+LDefine a name
▲ up5. Work in cells or the Formula barF2Edit the selected cellDeleteEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsEnterComplete a cell entry⌘+Shift+Return or Ctrl+Shift+EnterEnter a formula as an array formulaEscCancel an entry in the cell or formula barCtrl+ADisplay the Formula Builder after you type a valid function name in a formula⌘+K or Ctrl+KInsert a hyperlinkCtrl+UEdit the active cell and position the insertion point at the end of the lineShift+F3Open the Formula BuilderShift+F9Calculate the active sheetShift+F10Display a contextual menu=Start a formula⌘+T or F4Toggle the formula reference style between absolute, relative, and mixed⌘+Shift+TInsert the AutoSum formulaCtrl+; (semicolon)Enter the date⌘+; (semicolon)Enter the timeCtrl+Shift+’ (inchmark)Copy the value from the cell above the active cell into the cell or the formula barCtrl+` (grave accent)Alternate between displaying cell values and displaying cell formulasCtrl+’ (apostrophe))Copy a formula from the cell above the active cell into the cell or the formula barCtrl+Option+Arrow DownDisplay the AutoComplete listCtrl+LDefine a nameCtrl+Option+⌘+LOpen the Smart Lookup pane
▲ up6. Format and edit dataF2Edit the selected cell⌘+T or Ctrl+TCreate a table⌘+Option+Return or Ctrl+Option+EnterInsert a line break in a cellCtrl+Spacebar or ⌘+SpaceInsert special characters like symbols, including emoji⌘+Shift+>Increase font size⌘+Shift+<Decrease font size⌘+EAlign center⌘+LAlign left⌘+Shift+LDisplay the Modify Cell Style dialog box⌘+1Display the Format Cells dialog boxCtrl+Shift+~Apply the general number formatCtrl+Shift+$Apply the currency format with two decimal places (negative numbers appear in red with parentheses)Ctrl+Shift+%Apply the percentage format with no decimal placesCtrl+Shift+^Apply the exponential number format with two decimal placesCtrl+Shift+#Apply the date format with the day, month, and yearCtrl+Shift+@Apply the time format with the hour and minute, and indicate AM or PMCtrl+Shift+!Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values⌘+Option+0Apply the outline border around the selected cells⌘+Option+Arrow RightAdd an outline border to the right of the selection⌘+Option+Arrow LeftAdd an outline border to the left of the selection⌘+Option+Arrow UpAdd an outline border to the top of the selection⌘+Option+Arrow DownAdd an outline border to the bottom of the selection⌘+Option+- (hyphen)Remove outline borders⌘+BApply or remove bold formatting⌘+IApply or remove italic formatting⌘+UApply or remove underscoring⌘+Shift+XApply or remove strikethrough formatting⌘+) or Ctrl+)Hide a column⌘+Shift+) or Ctrl+Shift+)Unhide a column⌘+( or Ctrl+(Hide a row⌘+Shift+( or Ctrl+Shift+(Unhide a rowCtrl+UEdit the active cellEscCancel an entry in the cell or the formula barDeleteEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents⌘+VPaste text into the active cellEnterComplete a cell entry⌘+Return or Ctrl+EnterGive selected cells the current cell’s entry⌘+Shift+Return or Ctrl+Shift+EnterEnter a formula as an array formulaCtrl+ADisplay the Formula Builder after you type a valid function name in a formula
▲ up7. Select cells, columns, or rowsShift+Arrow KeyExtend the selection by one cell⌘+Shift+Arrow KeyExtend the selection to the last nonblank cell in the same column or row as the active cellShift+HomeExtend the selection to the beginning of the rowCtrl+Shift+HomeExtend the selection to the beginning of the sheetCtrl+Shift+EndExtend the selection to the last cell used on the sheet (lower-right corner)Ctrl+SpaceSelect the entire columnShift+SpaceSelect the entire row⌘+ASelect the entire sheet⌘+Shift+* (asterisk)Select only visible cellsShift+DeleteSelect only the active cell when multiple cells are selectedShift+Page DownExtend the selection down one screenShift+Page UpExtend the selection up one screenCtrl+6Alternate between hiding objects, displaying objects, and displaying placeholders for objectsF8Turn on the capability to extend a selection by using the arrow keysShift+F8Add another range of cells to the selectionCtrl+/Select the current array, which is the array that the active cell belongs to.Ctrl+Select cells in a row that don’t match the value in the active cell in that row. You must select the row starting with the active cell.Ctrl+Shift+[Select only cells that are directly referred to by formulas in the selectionCtrl+Shift+{Select all cells that are directly or indirectly referred to by formulas in the selectionCtrl+]Select only cells with formulas that refer directly to the active cellCtrl+Shift+}Select all cells with formulas that refer directly or indirectly to the active cell
▲ up8. Work with a selection⌘+C or Ctrl+CCopy⌘+V or Ctrl+VPaste⌘+X or Ctrl+XCutDeleteClearCtrl+- (hyphen)Delete the selection⌘+ZUndo the last action⌘+) or Ctrl+)Hide a column⌘+Shift+) or Ctrl+Shift+)Unhide a column⌘+( or Ctrl+(Hide a row⌘+Shift+( or Ctrl+Shift+(Unhide a rowEnterMove from top to bottom within the selection (down)*Shift+EnterMove from bottom to top within the selection (up)*TabMove from left to right within the selection, or move down one cell if only one column is selectedShift+TabMove from right to left within the selection, or move down one cell if only one column is selectedCtrl+. (period)Move clockwise to the next corner of the selection⌘+Shift+KGroup selected cells⌘+Shift+JUngroup selected cells*These shortcuts may move in another direction other than down or up. If you’d like to change the direction of these shortcuts using the mouse, on the Excel menu, click Preferences, click Edit, and then, under. After pressing Return, move selection, select the direction you want to move in.
▲ up9. Use chartsF11Insert a new chart sheet.ArrowKeysCycle through chart object selection
▲ up10. Sort, filter, and use PivotTable reports⌘+Shift+ROpen the Sort dialog box⌘+Shift+F or Ctrl+Shift+LAdd or remove a filterOption+Arrow DownDisplay the Filter list or PivotTable page field pop-up menu for the selected cell
▲ up11. Outline dataCtrl+8Display or hide outline symbolsCtrl+9Hide selected rowsCtrl+Shift+( (opening parenthesis)Unhide selected rowsCtrl+0 (zero)Hide selected columnsCtrl+Shift+) (closing parenthesis)Unhide selected columns
▲ up12. The following table provides the function key shortcuts for Excel 2016 for Mac*F1Display the Help windowF2Edit the selected cellShift+F2Insert or edit a cell commentOption+F2Open the Save dialogShift+F3Open the Formula Builder⌘+F3Open the Define Name dialog⌘+F4CloseF5Display the Go To dialogShift+F5Display the Find dialogCtrl+F5Move to the Search Sheet dialogF7Check spellingShift+F7 or Ctrl+Option+⌘+ROpen the thesaurusF8Extend the selectionShift+F8Add to the selectionOption+F8Display the Macro dialogF9Calculate all open workbooksShift+F9Calculate the active sheetCtrl+F9Minimize the active windowShift+F10Display a contextual menu, or ’right click’ menuCtrl+F10 or ⌘+F10Maximize or restore the active windowF11Insert a new chart sheet*Shift+F11Insert a new sheet*⌘+F11Insert an Excel 4.0 macro sheetOption+F11Open Visual BasicF12Display the Save As dialog⌘+F12Display the Open dialog*Excel 2016 for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don’t have to press the FN key every time you use a function key shortcut
▲ upMac Hotkeys Pdf
To use a keyboard shortcut, press and hold one or more modifier keys and then press the last key of the shortcut. For example, to use Command-C (copy), press and hold the Command key, then the C key, then release both keys. Mac menus and keyboards often use symbols for certain keys, including modifier keys:
On keyboards made for Windows PCs, use the Alt key instead of Option, and the Windows logo key instead of Command.
Some keys on some Apple keyboards have special symbols and functions, such as for display brightness , keyboard brightness , Mission Control, and more. If these functions aren’t available on your keyboard, you might be able to reproduce some of them by creating your own keyboard shortcuts. To use these keys as F1, F2, F3, or other standard function keys, combine them with the Fn key.Cut, copy, paste, and other common shortcuts
*Command-X: Cut the selected item and copy it to the Clipboard.
*Command-C: Copy the selected item to the Clipboard. This also works for files in the Finder.
*Command-V: Paste the contents of the Clipboard into the current document or app. This also works for files in the Finder.
*Command-Z: Undo the previous command. You can then press Shift-Command-Z to Redo, reversing the undo command. In some apps, you can undo and redo multiple commands.
*Command-A: Select All items.
*Command-F: Find items in a document or open a Find window.
*Command-G: Find Again: Find the next occurrence of the item previously found. To find the previous occurrence, press Shift-Command-G.
*Command-H: Hide the windows of the front app. To view the front app but hide all other apps, press Option-Command-H.
*Command-M: Minimize the front window to the Dock. To minimize all windows of the front app, press Option-Command-M.
*Command-O: Open the selected item, or open a dialog to select a file to open.
*Command-P: Print the current document.
*Command-S: Save the current document.
*Command-T: Open a new tab.
*Command-W: Close the front window. To close all windows of the app, press Option-Command-W.
*Option-Command-Esc: Force quit an app.
*Command–Space bar: Show or hide the Spotlight search field. To perform a Spotlight search from a Finder window, press Command–Option–Space bar. (If you use multiple input sources to type in different languages, these shortcuts change input sources instead of showing Spotlight. Learn how to change a conflicting keyboard shortcut.)
*Control–Command–Space bar: Show the Character Viewer, from which you can choose emoji and other symbols.
*Control-Command-F: Use the app in full screen, if supported by the app.
*Space bar: Use Quick Look to preview the selected item.
*Command-Tab: Switch to the next most recently used app among your open apps.
*Shift-Command-5: In macOS Mojave or later, take a screenshot or make a screen recording. Or use Shift-Command-3 or Shift-Command-4 for screenshots. Learn more about screenshots.
*Shift-Command-N: Create a new folder in the Finder.
*Command-Comma (,): Open preferences for the front app.Sleep, log out, and shut down shortcuts
You might need to press and hold some of these shortcuts for slightly longer than other shortcuts. This helps you to avoid using them unintentionally.
*Power button: Press to turn on your Mac or wake it from sleep. Press and hold for 1.5 seconds to put your Mac to sleep.* Continue holding to force your Mac to turn off.
*Option–Command–Power button* or Option–Command–Media Eject : Put your Mac to sleep.
*Control–Shift–Power button* or Control–Shift–Media Eject : Put your displays to sleep.
*Control–Power button* or Control–Media Eject : Display a dialog asking whether you want to restart, sleep, or shut down.
*Control–Command–Power button:* Force your Mac to restart, without prompting to save any open and unsaved documents.
*Control–Command–Media Eject : Quit all apps, then restart your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
*Control–Option–Command–Power button* or Control–Option–Command–Media Eject : Quit all apps, then shut down your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
*Control-Command-Q: Immediately lock your screen.
*Shift-Command-Q: Log out of your macOS user account. You will be asked to confirm. To log out immediately without confirming, press Option-Shift-Command-Q.
* Does not apply to the Touch ID sensor.Finder and system shortcuts
*Command-D: Duplicate the selected files.
*Command-E: Eject the selected disk or volume.
*Command-F: Start a Spotlight search in the Finder window.
*Command-I: Show the Get Info window for a selected file.
*Command-R: (1) When an alias is selected in the Finder: show the original file for the selected alias. (2) In some apps, such as Calendar or Safari, refresh or reload the page. (3) In Software Update preferences, check for software updates again.
*Shift-Command-C: Open the Computer window.
*Shift-Command-D: Open the desktop folder.
*Shift-Command-F: Open the Recents window, showing all of the files you viewed or changed recently.
*Shift-Command-G: Open a Go to Folder window.
*Shift-Command-H: Open the Home folder of the current macOS user account.
*Shift-Command-I: Open iCloud Drive.
*Shift-Command-K: Open the Network window.
*Option-Command-L: Open the Downloads folder.
*Shift-Command-N: Create a new folder.
*Shift-Command-O: Open the Documents folder.
*Shift-Command-P: Show or hide the Preview pane in Finder windows.
*Shift-Command-R: Open the AirDrop window.
*Shift-Command-T: Show or hide the tab bar in Finder windows.
*Control-Shift-Command-T: Add selected Finder item to the Dock (OS X Mavericks or later)
*Shift-Command-U: Open the Utilities folder.
*Option-Command-D: Show or hide the Dock.
*Control-Command-T: Add the selected item to the sidebar (OS X Mavericks or later).
*Option-Command-P: Hide or show the path bar in Finder windows.
*Option-Command-S: Hide or show the Sidebar in Finder windows.
*Command–Slash (/): Hide or show the status bar in Finder windows.
*Command-J: Show View Options.
*Command-K: Open the Connect to Server window.
*Control-Command-A: Make an alias of the selected item.
*Command-N: Open a new Finder window.
*Option-Command-N: Create a new Smart Folder.
*Command-T: Show or hide the tab bar when a single tab is open in the current Finder window.
*Option-Command-T: Show or hide the toolbar when a single tab is open in the current Finder window.
*Option-Command-V: Move the files in the Clipboard from their original location to the current location.
*Command-Y: Use Quick Look to preview the selected files.
*Option-Command-Y: View a Quick Look slideshow of the selected files.
*Command-1: View the items in the Finder window as icons.
https://diarynote.indered.space
コメント