Return to site

Shortcuts For Mac Excel 2011

broken image

Shortcuts For Mac Excel 2011

shortcuts excel mac, shortcuts excel, shortcuts excel pdf, shortcuts excel not working, shortcuts excel deutsch, shortcuts excel español, shortcuts excel macbook, shortcuts excel windows, shortcuts excel 365, shortcuts excel 2013

Working in cells 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 contentsReturnComplete a cell entryCtrl Shift ReturnEnter 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⌘ kInsert a hyperlinkCtrl uEdit the active cell and position the insertion point at the end of the lineShift F3Open the Formula Builder⌘ =Calculate all sheets in all open workbooks⌘ Shift =Calculate the active sheet=Start a formula⌘ tToggle the formula reference style between absolute, relative, and mixed⌘ Shift tInsert the AutoSum formulaCtrl ; (semicolon)Enter the date⌘ ; (semicolon)Enter the timeCtrl Shift '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 name▲ up6. Click

shortcuts excel

/Ctrl EndMove to the beginning / to the end of the sheetPage Down/Page UpMove down one screen / up one screenOption Page Down/Option Page UpMove one screen to the right / to the leftCtrl Page Down/Ctrl Page UpMove to the next sheet / to the previous sheet in the workbookCtrl Tab/Ctrl Shift TabMove to the next workbook / move to the previous workbook or windowF6/Shift F6Move to the next pane / move to the previous pane in a workbook that has been splitCtrl DeleteScroll to display the active cellCtrl gDisplay the Go To dialog box fDisplay the Find dialog box gRepeat the last Find action (same as Find Next)TabMove between unlocked cells on a protected sheet up3.. Command 6 is redo (as well as repeat) in Excel 2011 for the MAC In Excel 2010 and all previous versions in Windows, its F4 or Ctrl y for redo/repeat.. Excel Shortcuts List for Mac and PC (Searchable) How to Use this Shortcut List: Indicates to hold the previous key, while pressing the next key.. Indicates to tap the previous key, releasing it before pressing the next key Find the shortcuts list below: # Description. HERE

shortcuts excel mac

up2 Moving and scrolling in a sheet or workbookArrow KeysMove one cell up, down, left, or rightCtrl Arrow KeyMove to the edge of the current data regionHomeMove to the beginning of the rowCtrl Home.. (Period)Move clockwise to the next corner of the selectionCtrl Option Arrow RightMove to the right between nonadjacent selectionsCtrl Option Arrow LeftMove to the left between nonadjacent selections Ctrl mInsert graphics using the Media Browser up.. But the redo feature on the MAC is not as comprehensive as it is in Windows Excel.. F12Display the Open dialog boxCtrl Shift F12Display the Print dialog box*Conflicts with a default Mac OS X key assignment. Click

shortcuts excel pdf

Formatting and editing data Shift lDisplay the 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 A.. Previewing and printing pDisplay the Print dialog boxArrow KeysIn print preview, move around the page when zoomed inCtrl Arrow DownIn print preview, move to the last page when zoomed outShortcuts For Mac Excel 2011 Free up4.. 1 Function keysF1UndoF2Cut text from the active cellShift F2Edit a cell commentF3Copy text from the active cellShift F3Open the Formula BuilderF4Paste text into the active cellShift F4Repeat the last Find (Find Next) F4Close the windowF5Display the Go To dialog boxShift F5Display the Find dialog box F5Restore the window size. 773a7aa168 Click

shortcuts excel not working

Shift F9Calculate the active sheet Shift F10Display a contextual menu F10Maximize or restore the workbook windowOption F10Make the first button on a floating toolbar activeF11Insert a new chart sheet.. M or P M Ctrl Shift !Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values Option 0 (zero)Apply 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 -Remove outline borders bApply or remove bold formatting iApply or remove italic formatting uApply or remove underscoring Shift xApply or remove strikethrough formattingCtrl 9Hide rowsCtrl Shift (Unhide rowsCtrl 0 (zero)Hide columnsCtrl Shift )Unhide columns Shift wAdd or remove the shadow font style Shift dAdd or remove the outline font styleCtrl 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 cellReturnComplete a cell entryCtrl Shift ReturnEnter a formula as an array formulaCtrl aDisplay the Formula Builder after you type a valid function name in a formula up7.. Shift F11Insert a new sheet F11Insert an Excel 4 0 macro sheetF12Display the Save As dialog box.. Entering data on a sheetReturnComplete a cell entry and move forward in the selectionCtrl Option ReturnStart a new line in the same cellCtrl ReturnFill the selected cell range with the text that you typeShift ReturnComplete a cell entry and move back 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 Delete the character to the right of the insertion point, or delete the selectionCtrl Delete Delete text to the end of the lineArrow KeysMove one character up, down, left, or rightHomeMove to the beginning of the line yRepeat the last actionShift F2Edit a cell commentCtrl dFill downCtrl rFill to the rightCtrl lDefine a name up5.. *F6Move to the next pane in a workbook that has been splitShift F6Move to the previous pane in a workbook that has been split F6Move to the next workbook window Shift F6Move to the previous workbook windowF7Check spellingF8Turn on extend selection mode; used with arrow keys or cursorShift F8Add to the selectionOption F8Display the Macro dialog boxF9Calculate all sheets in all open workbooks. Click