Shortcut Keys For Excel Mac
2021年2月5日Download here: http://gg.gg/o74rd
Shortcut Keys For Excel Mac
If you switched to the Mac from a PC, check out the Apple Support article Mac tips for Windows switchers for a list of Mac keyboard shortcuts and the differences between Mac and Windows keyboards. For more keyboard shortcuts, see the Apple Support article Mac keyboard shortcuts. One way to get up to speed on this fast is to use a keyboard cover such as which overlays the shortcut keys onto your laptop keyboard. All the Best Microsoft Excel Keyboard Shortcuts Amelia Griggs @howtogeek August 10, 2018, 11:23am EDT Even if you’re familiar with Microsoft Excel, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.
Finding your mac address. Keyboard shortcuts listed in this topic refer to the U.S. keyboard layout. Keys on other keyboard layouts might not correspond to the keys on a U.S. keyboard. Keyboard shortcuts for laptop computers might also differ.
Some function key shortcuts conflict with default key assignments in Mac OS X version 10.3 or later. To use them, you must change the settings for your function keys. On the Apple menu, go to System Preferences. Under Hardware, click Keyboard > Keyboard and then check Use all F1, F2, etc. as standard function keys.
Custom Keyboard Shortcuts: In the Mac versions of Excel, you have to go to the Tools menu (it may be under File and then Options depending on the Excel version) and then select Customize Keyboard there to create these shortcuts. These shortcuts work the same way mechanically as on Windows, but the dialog box to create them looks different and you have to access that dialog box differently.
Tip: To quickly find your search term on this page, press CtrlF or ⌘F (Mac) and use the find bar.Shortcut Keys For Excel MacroGeneralWindowsMacOpen Excel helpF1⌘/Undo last actionCtrlZ⌘ZRedo last actionCtrlY⌘YCopy selected cellsCtrlC⌘CCut selected cellsCtrlX⌘XPaste content from clipboardCtrlV⌘VDisplay the Paste Special dialog boxCtrlAltVControl⌘VDisplay find and replaceCtrlF⌘FDisplay find and replace, replace selectedCtrlHControlHFind next matchShiftF4⌘GFind previous matchCtrlShiftF4⌘ShiftGCreate embedded chartAltF1FnOptionF1Create chart in new chart sheetF11FnF11Toggle AutofilterCtrlShiftL⌘ShiftFActivate filterAlt↓Option↓Create tableCtrlTControlTSelect an entire rowShiftSpacebarShiftSpacebarSelect an entire columnCtrlSpacebarControlSpacebarSelect the entire worksheetCtrlA or
CtrlShiftSpacebar⌘AFileWindowsMacCreate new workbookCtrlN⌘NOpen workbookCtrlO⌘OSave workbookCtrlS⌘SDisplays the Save As dialogF12⌘ShiftSPrint preview and printCtrlP or CtrlF2⌘PClose current workbookCtrlF4⌘WClose ExcelAltF4⌘QRibbonWindowsMacExpand or collapse ribbonCtrlF1⌘OptionRActivate access keysAltMove to next ribbon controlTabTabActivate or open selected controlSpacebarSpacebarConfirm control changeEnterReturnGet help on selected controlF1Drag and DropWindowsMacDrag and cutdragdragDrag and copyCtrldragOptiondragDrag and insertShiftdragShiftdragDrag and insert copyCtrlShiftdragOptionShiftdragDrag to worksheetAltdrag⌘dragDrag to duplicate worksheetCtrldragOptiondragNavigationWindowsMacMove one cell right→→Move one cell left←←Move one cell up↑↑Move one cell down↓↓Move one screen rightAltPgDnFnOption↑Move one screen leftAltPgUpFnOption↓Move one screen upPgUpFn↑Move one screen downPgDnFn↓Move to right edge of data regionCtrl→Control→Move to left edge of data regionCtrl←Control←Move to top edge of data regionCtrl↑Control↑Move to bottom edge of data regionCtrl↓Control↓Move to beginning of rowHomeFn←Move to last cell in worksheetCtrlEndFnControl→Move to first cell in worksheetCtrlHomeFnControl←Turn End mode onEndFn→SelectionWindowsMacSelect entire rowShiftSpacebarShiftSpacebarSelect entire columnCtrlSpacebarControlSpacebarSelect entire worksheetCtrlA⌘AAdd non-adjacent cells to selectionCtrlClickControlClickMove right between non-adjacent selectionsCtrlAlt→ControlOption→Move left between non-adjacent selectionsCtrlAlt←ControlOption←Toggle add to selection modeShiftF8FnShiftF8Cancel selectionEscEscExtend SelectionWindowsMacExtend selection by one cell rightShift→Shift→Extend selection by one cell leftShift←Shift←Extend selection by one cell upShift↑Shift↑Extend selection by one cell downShift↓Shift↓Extend the selection to the last cell rightCtrlShift→ControlShift→Extend the selection to the last cell leftCtrlShift←ControlShift←Extend the selection to the last cell upCtrlShift↑ControlShift↑Extend the selection to the last cell downCtrlShift↓ControlShift↓Extend selection up one screenShiftPgUpFnShift↑Extend selection down one screenShiftPgDnFnShift↓Extend selection to start of rowShiftHomeFnShift←Extend selection to first cell in worksheetCtrlShiftHomeFnControlShift←Extend selection to last cell in worksheetCtrlShiftEndFnControlShift→Toggle extend selection modeF8FnF8Active CellWindowsMacSelect active cell onlyShiftBackspaceShiftDeleteShow the active cell on worksheetCtrlBackspace⌘DeleteMove active cell clockwise in selectionCtrl.Control.Move active cell down in selectionEnterReturnMove active cell up in selectionShiftEnterShiftReturnMove active cell right in a selectionTabTabMove active cell left in a selectionShiftTabShiftTabSelect SpecialWindowsMacDisplay ‘Go To’ dialog boxCtrlGControlGSelect cells with commentsCtrlShiftOFnControlShiftOSelect current region around active cellCtrlShift*ControlShiftSpacebarSelect current regionCtrlA⌘ASelect current arrayCtrl/Control/Select row differencesCtrlControlSelect column differencesCtrlShift|ControlShift|Select direct precedentsCtrl[Control[Select all precedentsCtrlShift{ControlShift{Select direct dependentsCtrl]Control]Select all dependentsCtrlShift}ControlShift}Select visible cells onlyAlt;⌘ShiftZCell Edit ModeWindowsMacEdit the active cellF2ControlUInsert or edit commentShiftF2ShiftF2Cancel entryEscEscSelect one character rightShift→Shift→Select one character leftShift←Shift←Move one word rightCtrl→Control→Move one word leftCtrl←Control←Select one word rightCtrlShift→ControlShift→Select one word leftCtrlShift←ControlShift←Select to beginning of cellShiftHomeFnShift←Select to end of cellShiftEndFnShift→Delete to end of lineCtrlDeleteControlDeleteDelete character to the left of cursorBackspaceDeleteDelete character to the right of cursorDeleteFnDeleteStart a new line in the same cellAltEnterControlOptionReturnEntering DataWindowsMacEnter and move downEnterReturnEnter and move upShiftEnterShiftReturnEnter and move rightTabTabEnter and move leftShiftTabShiftTabComplete entry and stay in same cellCtrlEnterControlReturnEnter same data in multiple cellsCtrlEnterControlReturnInsert current dateCtrl;Control;Insert current timeCtrlShift:ControlShift:Fill down from cell aboveCtrlDControlDFill right from cell leftCtrlRControlRCopy formula from cell aboveCtrl`Control`Copy value from cell aboveCtrlShift’ControlShift’Add hyperlinkCtrlK⌘KDisplay AutoComplete listAlt↓Option↓FormattingWindowsMacFormat (almost) anythingCtrl1⌘1Display Format Cells with Font tab selectedCtrlShiftFApply format againF4ControlYApply or remove bold formattingCtrlB⌘BApply or remove italic formattingCtrlI⌘IApply or remove underscoringCtrlU⌘UApply or remove strikethrough formattingCtrl5⌘ShiftXAdd or remove the shadow font style⌘ShiftWAdd or remove the outline font style⌘ShiftDAlign centerAltHAC⌘EAlign leftAltHAL⌘LAlign rightAltHAR⌘RIndent⌘MRemove indent⌘ShiftMIncrease font size one step⌘Shift>Decrease font size one step⌘Shift<Number FormattingWindowsMacApply general formatCtrlShift~ControlShift~Apply currency formatCtrlShift$ControlShift$Apply percentage formatCtrlShift%ControlShift%Apply scientific formatCtrlShift^ControlShift^Apply date formatCtrlShift#ControlShift#Apply time formatCtrlShift@ControlShift@Apply number formatCtrlShift!ControlShift!BordersWindowsMacAdd border outlineCtrlShift&⌘Option0Add or remove border rightAltR⌘Option→Add or remove border leftAltL⌘Option←Add or remove border topAltT⌘Option↑Add or remove border bottomAltB⌘Option↓Add or remove border upward diagonalAltDAdd or remove border horizontal interiorAltHAdd or remove border vertical interiorAltVRemove bordersCtrlShift_⌘Option_FormulasWindowsMacToggle absolute and relative referencesF4⌘TOpen the Insert Function Dialog BoxShiftF3FnShiftF3Autosum selected cellsAlt=⌘ShiftTToggle formulas on and offCtrl`Control`Insert function argumentsCtrlShiftAControlShiftAEnter array formulaCtrlShiftEnterControlShiftReturnCalculate worksheetsF9F9Calculate active worksheetShiftF9FnShiftF9Force calculate all worksheetsCtrlAltF9Evaluate part of a formulaF9FnF9Expand or collapse the formula barCtrlShiftUControlShiftUDisplay function arguments dialog boxCtrlAControlAName ManagerCtrlF3ControlLDefine name using row and column labelsCtrlShiftF3ControlShiftF3Paste name into formulaF3Accept function with autocompleteTab↓TabPivot TablesWindowsMacSelect entire pivot tableCtrlA⌘AToggle pivot table field checkboxSpacebarSpacebarGroup pivot table itemsAltShift→⌘ShiftKUngroup pivot table itemsAltShift←⌘ShiftJHide pivot table itemCtrl-Ctrl-Create pivot chart on same worksheetAltF1Create pivot chart on new worksheetF11FnF11WorkbookWindowsMacInsert new worksheetShiftF11ShiftF11Go to next worksheetCtrlPgDnFnControl↓Go to previous worksheetCtrlPgUpFnControl↑Move to next paneF6F6Move to previous paneShiftF6ShiftF6Go to next workbookCtrlTabControlTabGo to previous workbookCtrlShiftTabControlShiftTabDisplay control menuAltSpacebarMinimize current workbook windowCtrlF9⌘MMaximize current workbook windowCtrlF10Dialog BoxesWindowsMacMove to next controlTabTabMove to previous controlShiftTabShiftTabMove to next tabCtrlTabControlTabMove to previous tabCtrlShiftTabControlShiftTabAccept and applyEnterReturnCheck and uncheck boxSpacebarSpacebarCancel and close the dialog boxEscEscGrid OperationsWindowsMacDisplay Insert Dialog boxCtrlShift+ControlIInsert rowsCtrlShift+ControlIInsert columnsCtrlShift+ControlIDisplay Delete dialog boxCtrl-Control-Delete rowsCtrl-Control-Delete columnsCtrl-Control-Delete cellsCtrl-Control-Delete contents of selected cellsDeleteFnDeleteHide columnsCtrl0Control0Hide rowsCtrl9Control9Unhide rowsCtrlShift9ControlShift9Unhide columnsCtrlShift0ControlShift0Group rows or columnsAltShift→⌘ShiftKUngroup rows or columnsAltShift←⌘ShiftJOpen Group Dialog BoxAltShift→⌘ShiftKOpen Ungroup Dialog BoxAltShift←⌘ShiftJHide or show outline symbolsCtrl8Control8VBA EditorWindowsMacHelpF1Object BrowserF2Find NextF3Properies WindowF4RunF5Switch Split WindowsF6Goto Window Of ObjectF7StepF8BreakpointF9Activate Menu BarF10Toggle Insert ModeInsertDeleteDeleteBeginning Of LineHomeEnd Of LineEndPage UpPgUpPage DownPgDnLeft←Right→Up↑Down↓IndentTabNew LineEnterDelete Prev CharBackSpaceProcedure DefinitionShiftF2Find PrevShiftF3Find NextF3Procedure StepShiftF8Quick WatchShiftF9Show Right Click MenuShiftF10PasteShiftInsertSelect To Start Of LineShiftHomeSelect To End Of LineShiftEndSelect To Top Of ModuleShiftPgUpSelect To End Of ModuleShiftPgDnExtend Selection Left 1 CharShift←Extend Selection Right 1 CharShift→Extend Selection UpShift↑Extend Selection DownShift↓Un-indentShiftTabFocus To Object BoxCtrlF2Close WindowCtrlF4Run To CursorCtrlF8Activate Menu BarCtrlF10Select All TextCtrlBCopyCtrlCExport ModuleCtrlEFindCtrlFImmediate WindowCtrlGReplaceCtrlHTurn On Quick InfoCtrlIList MembersCtrlJShow Call StackCtrlLImport FileCtrlMNew LineCtrlNPrintCtrlPProject WindowCtrlRSaveCtrlSShow Available ComponentsCtrlTPasteCtrlVCutCtrlXCut Entire LineCtrlYUndoCtrlZCopyCtrlInsertDelete To End Of WordCtrlDeleteTop Of ModuleCtrlHomeEnd Of ModuleCtrlEndTop Of Current ProcedureCtrlPage UpEnd Of Current ProcedureCtrlPage DownLeft WordCtrlLeft ArrowRight WordCtrlRight ArrowPrevious ProcedureCtrlUp ArrowNext ProcedureCtrlDown ArrowTurn On Complete WordCtrlSpacebarCycle WindowsCtrlTabDelete To Start Of WordCtrlBackSpaceClose VBEAltF4Run Error HandlerAltF5Switch Between Last 2 WindowsAltF6Step Error HandlerAltF7Return To ApplicationAltF11Add-Ins MenuAltADebug MenuAltDEdit MenuAltEFile MenuAltFHelp MenuAltHInsert MenuAltJFormat MenuAltOClose & ReturnAltQRun MenuAltRTools MenuAltTView MenuAltVWindow MenuAltWSystem MenuAltSpacebarCycle ApplicationsAltTabUndoAltBackSpacePrevious PositionCtrlShiftF2Clear All BreakpointsCtrlShiftF9Turn On Param InfoCtrlShiftITurn On List PropertiesCtrlShiftJOtherWindowsMacOpen Spelling dialog boxF7F7Open Thesaurus dialog boxShiftF7ShiftF7Open Macro dialog boxAltF8FnOptionF8Open VBA EditorAltF11FnOptionF11Duplicate objectCtrlD⌘DSnap to gridAlt⌘Hide or show objectsCtrl6Control6Display Modify Cell Style dialog boxAlt’⌘ShiftL
Download here: http://gg.gg/o74rd
https://diarynote.indered.space
Shortcut Keys For Excel Mac
If you switched to the Mac from a PC, check out the Apple Support article Mac tips for Windows switchers for a list of Mac keyboard shortcuts and the differences between Mac and Windows keyboards. For more keyboard shortcuts, see the Apple Support article Mac keyboard shortcuts. One way to get up to speed on this fast is to use a keyboard cover such as which overlays the shortcut keys onto your laptop keyboard. All the Best Microsoft Excel Keyboard Shortcuts Amelia Griggs @howtogeek August 10, 2018, 11:23am EDT Even if you’re familiar with Microsoft Excel, you might be surprised by the number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.
Finding your mac address. Keyboard shortcuts listed in this topic refer to the U.S. keyboard layout. Keys on other keyboard layouts might not correspond to the keys on a U.S. keyboard. Keyboard shortcuts for laptop computers might also differ.
Some function key shortcuts conflict with default key assignments in Mac OS X version 10.3 or later. To use them, you must change the settings for your function keys. On the Apple menu, go to System Preferences. Under Hardware, click Keyboard > Keyboard and then check Use all F1, F2, etc. as standard function keys.
Custom Keyboard Shortcuts: In the Mac versions of Excel, you have to go to the Tools menu (it may be under File and then Options depending on the Excel version) and then select Customize Keyboard there to create these shortcuts. These shortcuts work the same way mechanically as on Windows, but the dialog box to create them looks different and you have to access that dialog box differently.
Tip: To quickly find your search term on this page, press CtrlF or ⌘F (Mac) and use the find bar.Shortcut Keys For Excel MacroGeneralWindowsMacOpen Excel helpF1⌘/Undo last actionCtrlZ⌘ZRedo last actionCtrlY⌘YCopy selected cellsCtrlC⌘CCut selected cellsCtrlX⌘XPaste content from clipboardCtrlV⌘VDisplay the Paste Special dialog boxCtrlAltVControl⌘VDisplay find and replaceCtrlF⌘FDisplay find and replace, replace selectedCtrlHControlHFind next matchShiftF4⌘GFind previous matchCtrlShiftF4⌘ShiftGCreate embedded chartAltF1FnOptionF1Create chart in new chart sheetF11FnF11Toggle AutofilterCtrlShiftL⌘ShiftFActivate filterAlt↓Option↓Create tableCtrlTControlTSelect an entire rowShiftSpacebarShiftSpacebarSelect an entire columnCtrlSpacebarControlSpacebarSelect the entire worksheetCtrlA or
CtrlShiftSpacebar⌘AFileWindowsMacCreate new workbookCtrlN⌘NOpen workbookCtrlO⌘OSave workbookCtrlS⌘SDisplays the Save As dialogF12⌘ShiftSPrint preview and printCtrlP or CtrlF2⌘PClose current workbookCtrlF4⌘WClose ExcelAltF4⌘QRibbonWindowsMacExpand or collapse ribbonCtrlF1⌘OptionRActivate access keysAltMove to next ribbon controlTabTabActivate or open selected controlSpacebarSpacebarConfirm control changeEnterReturnGet help on selected controlF1Drag and DropWindowsMacDrag and cutdragdragDrag and copyCtrldragOptiondragDrag and insertShiftdragShiftdragDrag and insert copyCtrlShiftdragOptionShiftdragDrag to worksheetAltdrag⌘dragDrag to duplicate worksheetCtrldragOptiondragNavigationWindowsMacMove one cell right→→Move one cell left←←Move one cell up↑↑Move one cell down↓↓Move one screen rightAltPgDnFnOption↑Move one screen leftAltPgUpFnOption↓Move one screen upPgUpFn↑Move one screen downPgDnFn↓Move to right edge of data regionCtrl→Control→Move to left edge of data regionCtrl←Control←Move to top edge of data regionCtrl↑Control↑Move to bottom edge of data regionCtrl↓Control↓Move to beginning of rowHomeFn←Move to last cell in worksheetCtrlEndFnControl→Move to first cell in worksheetCtrlHomeFnControl←Turn End mode onEndFn→SelectionWindowsMacSelect entire rowShiftSpacebarShiftSpacebarSelect entire columnCtrlSpacebarControlSpacebarSelect entire worksheetCtrlA⌘AAdd non-adjacent cells to selectionCtrlClickControlClickMove right between non-adjacent selectionsCtrlAlt→ControlOption→Move left between non-adjacent selectionsCtrlAlt←ControlOption←Toggle add to selection modeShiftF8FnShiftF8Cancel selectionEscEscExtend SelectionWindowsMacExtend selection by one cell rightShift→Shift→Extend selection by one cell leftShift←Shift←Extend selection by one cell upShift↑Shift↑Extend selection by one cell downShift↓Shift↓Extend the selection to the last cell rightCtrlShift→ControlShift→Extend the selection to the last cell leftCtrlShift←ControlShift←Extend the selection to the last cell upCtrlShift↑ControlShift↑Extend the selection to the last cell downCtrlShift↓ControlShift↓Extend selection up one screenShiftPgUpFnShift↑Extend selection down one screenShiftPgDnFnShift↓Extend selection to start of rowShiftHomeFnShift←Extend selection to first cell in worksheetCtrlShiftHomeFnControlShift←Extend selection to last cell in worksheetCtrlShiftEndFnControlShift→Toggle extend selection modeF8FnF8Active CellWindowsMacSelect active cell onlyShiftBackspaceShiftDeleteShow the active cell on worksheetCtrlBackspace⌘DeleteMove active cell clockwise in selectionCtrl.Control.Move active cell down in selectionEnterReturnMove active cell up in selectionShiftEnterShiftReturnMove active cell right in a selectionTabTabMove active cell left in a selectionShiftTabShiftTabSelect SpecialWindowsMacDisplay ‘Go To’ dialog boxCtrlGControlGSelect cells with commentsCtrlShiftOFnControlShiftOSelect current region around active cellCtrlShift*ControlShiftSpacebarSelect current regionCtrlA⌘ASelect current arrayCtrl/Control/Select row differencesCtrlControlSelect column differencesCtrlShift|ControlShift|Select direct precedentsCtrl[Control[Select all precedentsCtrlShift{ControlShift{Select direct dependentsCtrl]Control]Select all dependentsCtrlShift}ControlShift}Select visible cells onlyAlt;⌘ShiftZCell Edit ModeWindowsMacEdit the active cellF2ControlUInsert or edit commentShiftF2ShiftF2Cancel entryEscEscSelect one character rightShift→Shift→Select one character leftShift←Shift←Move one word rightCtrl→Control→Move one word leftCtrl←Control←Select one word rightCtrlShift→ControlShift→Select one word leftCtrlShift←ControlShift←Select to beginning of cellShiftHomeFnShift←Select to end of cellShiftEndFnShift→Delete to end of lineCtrlDeleteControlDeleteDelete character to the left of cursorBackspaceDeleteDelete character to the right of cursorDeleteFnDeleteStart a new line in the same cellAltEnterControlOptionReturnEntering DataWindowsMacEnter and move downEnterReturnEnter and move upShiftEnterShiftReturnEnter and move rightTabTabEnter and move leftShiftTabShiftTabComplete entry and stay in same cellCtrlEnterControlReturnEnter same data in multiple cellsCtrlEnterControlReturnInsert current dateCtrl;Control;Insert current timeCtrlShift:ControlShift:Fill down from cell aboveCtrlDControlDFill right from cell leftCtrlRControlRCopy formula from cell aboveCtrl`Control`Copy value from cell aboveCtrlShift’ControlShift’Add hyperlinkCtrlK⌘KDisplay AutoComplete listAlt↓Option↓FormattingWindowsMacFormat (almost) anythingCtrl1⌘1Display Format Cells with Font tab selectedCtrlShiftFApply format againF4ControlYApply or remove bold formattingCtrlB⌘BApply or remove italic formattingCtrlI⌘IApply or remove underscoringCtrlU⌘UApply or remove strikethrough formattingCtrl5⌘ShiftXAdd or remove the shadow font style⌘ShiftWAdd or remove the outline font style⌘ShiftDAlign centerAltHAC⌘EAlign leftAltHAL⌘LAlign rightAltHAR⌘RIndent⌘MRemove indent⌘ShiftMIncrease font size one step⌘Shift>Decrease font size one step⌘Shift<Number FormattingWindowsMacApply general formatCtrlShift~ControlShift~Apply currency formatCtrlShift$ControlShift$Apply percentage formatCtrlShift%ControlShift%Apply scientific formatCtrlShift^ControlShift^Apply date formatCtrlShift#ControlShift#Apply time formatCtrlShift@ControlShift@Apply number formatCtrlShift!ControlShift!BordersWindowsMacAdd border outlineCtrlShift&⌘Option0Add or remove border rightAltR⌘Option→Add or remove border leftAltL⌘Option←Add or remove border topAltT⌘Option↑Add or remove border bottomAltB⌘Option↓Add or remove border upward diagonalAltDAdd or remove border horizontal interiorAltHAdd or remove border vertical interiorAltVRemove bordersCtrlShift_⌘Option_FormulasWindowsMacToggle absolute and relative referencesF4⌘TOpen the Insert Function Dialog BoxShiftF3FnShiftF3Autosum selected cellsAlt=⌘ShiftTToggle formulas on and offCtrl`Control`Insert function argumentsCtrlShiftAControlShiftAEnter array formulaCtrlShiftEnterControlShiftReturnCalculate worksheetsF9F9Calculate active worksheetShiftF9FnShiftF9Force calculate all worksheetsCtrlAltF9Evaluate part of a formulaF9FnF9Expand or collapse the formula barCtrlShiftUControlShiftUDisplay function arguments dialog boxCtrlAControlAName ManagerCtrlF3ControlLDefine name using row and column labelsCtrlShiftF3ControlShiftF3Paste name into formulaF3Accept function with autocompleteTab↓TabPivot TablesWindowsMacSelect entire pivot tableCtrlA⌘AToggle pivot table field checkboxSpacebarSpacebarGroup pivot table itemsAltShift→⌘ShiftKUngroup pivot table itemsAltShift←⌘ShiftJHide pivot table itemCtrl-Ctrl-Create pivot chart on same worksheetAltF1Create pivot chart on new worksheetF11FnF11WorkbookWindowsMacInsert new worksheetShiftF11ShiftF11Go to next worksheetCtrlPgDnFnControl↓Go to previous worksheetCtrlPgUpFnControl↑Move to next paneF6F6Move to previous paneShiftF6ShiftF6Go to next workbookCtrlTabControlTabGo to previous workbookCtrlShiftTabControlShiftTabDisplay control menuAltSpacebarMinimize current workbook windowCtrlF9⌘MMaximize current workbook windowCtrlF10Dialog BoxesWindowsMacMove to next controlTabTabMove to previous controlShiftTabShiftTabMove to next tabCtrlTabControlTabMove to previous tabCtrlShiftTabControlShiftTabAccept and applyEnterReturnCheck and uncheck boxSpacebarSpacebarCancel and close the dialog boxEscEscGrid OperationsWindowsMacDisplay Insert Dialog boxCtrlShift+ControlIInsert rowsCtrlShift+ControlIInsert columnsCtrlShift+ControlIDisplay Delete dialog boxCtrl-Control-Delete rowsCtrl-Control-Delete columnsCtrl-Control-Delete cellsCtrl-Control-Delete contents of selected cellsDeleteFnDeleteHide columnsCtrl0Control0Hide rowsCtrl9Control9Unhide rowsCtrlShift9ControlShift9Unhide columnsCtrlShift0ControlShift0Group rows or columnsAltShift→⌘ShiftKUngroup rows or columnsAltShift←⌘ShiftJOpen Group Dialog BoxAltShift→⌘ShiftKOpen Ungroup Dialog BoxAltShift←⌘ShiftJHide or show outline symbolsCtrl8Control8VBA EditorWindowsMacHelpF1Object BrowserF2Find NextF3Properies WindowF4RunF5Switch Split WindowsF6Goto Window Of ObjectF7StepF8BreakpointF9Activate Menu BarF10Toggle Insert ModeInsertDeleteDeleteBeginning Of LineHomeEnd Of LineEndPage UpPgUpPage DownPgDnLeft←Right→Up↑Down↓IndentTabNew LineEnterDelete Prev CharBackSpaceProcedure DefinitionShiftF2Find PrevShiftF3Find NextF3Procedure StepShiftF8Quick WatchShiftF9Show Right Click MenuShiftF10PasteShiftInsertSelect To Start Of LineShiftHomeSelect To End Of LineShiftEndSelect To Top Of ModuleShiftPgUpSelect To End Of ModuleShiftPgDnExtend Selection Left 1 CharShift←Extend Selection Right 1 CharShift→Extend Selection UpShift↑Extend Selection DownShift↓Un-indentShiftTabFocus To Object BoxCtrlF2Close WindowCtrlF4Run To CursorCtrlF8Activate Menu BarCtrlF10Select All TextCtrlBCopyCtrlCExport ModuleCtrlEFindCtrlFImmediate WindowCtrlGReplaceCtrlHTurn On Quick InfoCtrlIList MembersCtrlJShow Call StackCtrlLImport FileCtrlMNew LineCtrlNPrintCtrlPProject WindowCtrlRSaveCtrlSShow Available ComponentsCtrlTPasteCtrlVCutCtrlXCut Entire LineCtrlYUndoCtrlZCopyCtrlInsertDelete To End Of WordCtrlDeleteTop Of ModuleCtrlHomeEnd Of ModuleCtrlEndTop Of Current ProcedureCtrlPage UpEnd Of Current ProcedureCtrlPage DownLeft WordCtrlLeft ArrowRight WordCtrlRight ArrowPrevious ProcedureCtrlUp ArrowNext ProcedureCtrlDown ArrowTurn On Complete WordCtrlSpacebarCycle WindowsCtrlTabDelete To Start Of WordCtrlBackSpaceClose VBEAltF4Run Error HandlerAltF5Switch Between Last 2 WindowsAltF6Step Error HandlerAltF7Return To ApplicationAltF11Add-Ins MenuAltADebug MenuAltDEdit MenuAltEFile MenuAltFHelp MenuAltHInsert MenuAltJFormat MenuAltOClose & ReturnAltQRun MenuAltRTools MenuAltTView MenuAltVWindow MenuAltWSystem MenuAltSpacebarCycle ApplicationsAltTabUndoAltBackSpacePrevious PositionCtrlShiftF2Clear All BreakpointsCtrlShiftF9Turn On Param InfoCtrlShiftITurn On List PropertiesCtrlShiftJOtherWindowsMacOpen Spelling dialog boxF7F7Open Thesaurus dialog boxShiftF7ShiftF7Open Macro dialog boxAltF8FnOptionF8Open VBA EditorAltF11FnOptionF11Duplicate objectCtrlD⌘DSnap to gridAlt⌘Hide or show objectsCtrl6Control6Display Modify Cell Style dialog boxAlt’⌘ShiftL
Download here: http://gg.gg/o74rd
https://diarynote.indered.space
コメント