Excel



00ExcelShorcuts for MAC en PC’sDaniel DEVEAUX avec l’aide de Greta DERIEUWBasé sur la documentation de Microsoft?100000100000ExcelShorcuts for MAC en PC’sDaniel DEVEAUX avec l’aide de Greta DERIEUWBasé sur la documentation de Microsoft? TOC \o "1-3" \h \z \u 1Préambule PAGEREF _Toc459896904 \h 31.1La précision PAGEREF _Toc459896905 \h 31.2L'observation. PAGEREF _Toc459896906 \h 31.3La curiosité. PAGEREF _Toc459896907 \h 4Chapitre I :Titre PAGEREF _Toc459896908 \h 52Keyboard shortcuts in Excel 2016 for Mac PAGEREF _Toc459896909 \h 62.1Frequently used shortcuts PAGEREF _Toc459896910 \h 62.2Function keys PAGEREF _Toc459896911 \h 102.3Move and scroll in a sheet or workbook PAGEREF _Toc459896912 \h 122.4Print PAGEREF _Toc459896913 \h 132.5Enter data on a sheet PAGEREF _Toc459896914 \h 142.6Work in cells or the Formula bar PAGEREF _Toc459896915 \h 152.7Format and edit data PAGEREF _Toc459896916 \h 172.8Work with a selection PAGEREF _Toc459896917 \h 212.9Select cells, columns, or rows PAGEREF _Toc459896918 \h 232.10Use charts PAGEREF _Toc459896919 \h 252.11Sort, filter, and use PivotTable reports PAGEREF _Toc459896920 \h 252.12Outline data PAGEREF _Toc459896921 \h 252.13Work in windows PAGEREF _Toc459896922 \h 262.14Work in dialog boxes PAGEREF _Toc459896923 \h 272.15Use function key shortcuts PAGEREF _Toc459896924 \h 272.16Related information PAGEREF _Toc459896925 \h 282.17Was this information helpful? PAGEREF _Toc459896926 \h 283Remerciements PAGEREF _Toc459896927 \h 294Divers PAGEREF _Toc459896928 \h 30PréambuleJe prétends qu'il faut avoir 3 qualités principales pour travailler en Windows.La précisionL'ObservationLa CuriositéLa précisionPrenons Excel en exemple. Avez-vous déjà observé le changement de forme de la trace de la souris sur l’écran à l'approche de la "case courante" (A1 à l'ouverture). Un mouvement de quelques 10ème de millimètres vous provoque l'apparition de 3 traces différentes.Qui dit changement de forme dit changement de r?le. Voyez les illustrations ci-dessusSoyons donc précisL'observation.Il y a tellement d'informations sur l'écran qu'il est parfois difficile de distinguer l'essentiel de l'accessoire. Observer permet de voir certaines choses insoup?onnables Dans l'exemple ci-dessous vous constaterez que des cases contenant des chiffres sont sélectionnées. Observer bien la barre d'état en bas de votre écran, vous verrez le total des éléments sélectionnés.Soyons donc observateur.La curiosité.La curiosité est la qualité majeure permettant d'améliorer son savoir. L'on peut assouvir sa curiosité en généralisant l'usage intensif du bouton droit de la souris.Tout objet, chose ou zone est presque toujours manipulable par le bouton droit de la souris.Dans votre feuille Excel, cliquez avec le bouton droit de la souris sur la zone où la somme de vos éléments sélectionnés est indiquée. Sans cette curiosité, vous n'auriez peut-être jamais découvert que vous pouviez obtenir la moyenne de vos valeurs.Keyboard shortcuts in Excel 2016 for MacApplies To:?Excel 2016 for MacExcel 2016 for Mac keyboard shortcuts are listed here. If you use Excel on a Windows computer, many of the shortcuts that use the CTRL key also work in Excel 2016 for Mac. However, not all do. When in doubt, consult this list. Please note that the shortcuts listed in this topic refer to the U.S. keyboard layout.Frequently used shortcutsTo do thisPressPaste?+ V?orCONTROL + VCopy?+ CorCONTROL + CClearDELETESave?+ SorCONTROL + SUndo?+ Z?or?CONTROL + ZRedo?+ Y?orCONTROL + Y or?+ SHIFT+ ZCut?+ X?or?CONTROL + XBold?+ B?or?CONTROL + BPrint?+ P?or?CONTROL + POpen Visual BasicOPTION + F11Fill Down?+ Dor?CONTROL + DFill Right?+ RorCONTROL + RInsert cellsCONTROL + SHIFT + =Delete cells?+ HYPHENor?CONTROL + HYPHENCalculate all open workbooks?+ =or?F9Close window?+ W?orCONTROL + WQuit Excel?+ QDisplay the?Go To?dialog boxCONTROL + Gor?F5Display the?Format Cells?dialog box?+ 1?orCONTROL + 1Display the?Replace?dialog boxCONTROL + Hor??+ SHIFT + HPaste Special?+ CONTROL + V?orCONTROL + OPTION + Vor??+ OPTION + VUnderline?+ UItalic?+ IorCONTROL + INew blank workbook?+ NorCONTROL + NNew workbook from template?+ SHIFT + PDisplay the?Save As?dialog box?+ SHIFT + Sor?F12Display the?Help?windowF1?or??+ /Select All?+ Aor??+ SHIFT + SPACEBARAdd or remove a filter?+ SHIFT + F?orCONTROL + SHIFT + LMinimize or maximize the ribbon tabs?+ OPTION + RDisplay the?Open?dialog box?+ O?or?CONTROL + OCheck spellingF7Open the thesaurusSHIFT + F7Display the?Formula BuilderSHIFT + F3Open the?Define Name?dialog box?+ F3Open the?Create names?dialog box?+ SHIFT + F3Insert a new sheet. **SHIFT + F11** This shortcut conflicts with a default Mac OS key assignment. To use this shortcut, you must change your Mac keyboard settings. Go to?Apple?>?System Preferences?>?Keyboard?>?Shortcuts. Click?Mission Control, and then click to deselect theShow Desktop?option.Function keysNOTE:?If a function key doesn't work as you expect it to, press the?FN?key in addition to the function key. If you don't want to press the FN key each time, you can change your system preferences: Go to?Apple?>?System Preferences?>?Keyboard. Then select the check box for?Use all F1, F2, etc. as standard function ressDisplay the?Help?windowF1Edit the selected cellF2Insert or edit a cell commentSHIFT + F2Open the?Save?dialog boxOPTION + F2Open the Formula BuilderSHIFT + F3Open the?Define Name?dialog box?+ F3Close?+ F4Display the?Go To?dialog boxF5Display the?Find?dialog boxSHIFT + F5Move to the?Search Sheet?boxCONTROL + F5Check spellingF7Open thesaurusSHIFT + F7Extend the selectionF8Add to the selectionSHIFT + F8Display the?Macro?dialog boxOPTION + F8Calculate all open workbooks.F9Calculate the active sheetSHIFT + F9Minimize the active windowCONTROL + F9Display a contextual menu, or "right click" menuSHIFT + F10Maximize or restore the active windowCONTROL + F10?or?+ F10Insert a new chart sheet. **F11Insert a new sheet **SHIFT + F11Insert an Excel 4.0 macro sheet?+ F11Open Visual BasicOPTION + F11Display the?Save As?dialog boxF12Display the?Open?dialog box?+ F12** This shortcut conflicts with a default Mac OS key assignment. To use this shortcut, you must change your Mac keyboard settings. Go to?Apple?>?System Preferences?>?Keyboard?>?Shortcuts. Click?Mission Control, and then click to deselect theShow Desktop?option.Move and scroll in a sheet or workbookTo do thisPressMove one cell up, down, left, or rightAn arrow keyMove to the edge of the current data region?+ arrow keyMove to the beginning of the rowHOMEMove to the beginning of the sheetCONTROL + HOMEMove to the last cell in use on the sheetCONTROL + ENDMove down one screenPAGE DOWNOn a MacBook, press FN + DOWN ARROWMove up one screenPAGE UPOn a MacBook, press FN + UP ARROWMove one screen to the rightOPTION + PAGE DOWNMove one screen to the leftOPTION + PAGE UPMove to the next sheet in the workbookCONTROL + PAGE DOWN?orOPTION + RIGHT ARROWMove to the previous sheet in the workbookCONTROL + PAGE DOWN?orOPTION + LEFT ARROWScroll to display the active cellCONTROL + DELETEDisplay the?Go To?dialog boxCONTROL + GDisplay the?Find?dialog boxCONTROL + ForSHIFT + F5Access the?Search Sheet?box?+ FMove between unlocked cells on a protected sheetTABPrintToPressPrint?+ P?or?CONTROL + PPrint preview?+ P?or?CONTROL + PEnter data on a sheetIf a function key doesn't work as you expect it to, press the?FN?key in addition to the function key. If you don't want to press the FN key each time, you can change your system preferences: Go to?Apple?>?System Preferences?>?Keyboard. Then select the check box for?Use all F1, F2, etc. as standard function keys.To do thisPressEdit the selected cellF2Complete a cell entry and move forward in the selectionRETURNStart a new line in the same cellCONTROL + OPTION + RETURNFill the selected cell range with the text that you type?+ RETURNorCONTROL + RETURNComplete a cell entry and move up in the selectionSHIFT + RETURNComplete a cell entry and move to the right in the selectionTABComplete a cell entry and move to the left in the selectionSHIFT + TABCancel a cell entryESCDelete the character to the left of the insertion point, or delete the selectionDELETEDelete the character to the right of the insertion point, or delete the selectionNote: Some smaller keyboards do not have this keyDelete text to the end of the lineNote: Some smaller keyboards do not have this keyCONTROL +?Move one character up, down, left, or rightAn arrow keyMove to the beginning of the lineHOMEInsert a commentSHIFT + F2Open and edit a cell commentSHIFT + F2Fill downCONTROL + Dor?+ DFill to the rightCONTROL + Ror?+ RDefine a nameCONTROL + LWork in cells or the Formula barNOTE:?If a function key doesn't work as you expect it to, press the?FN?key in addition to the function key. If you don't want to press the FN key each time, you can change your system preferences: Go to?Apple?>?System Preferences?>?Keyboard. Then select the check box for?Use all F1, F2, etc. as standard function ressEdit the selected cellF2Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsDELETEComplete a cell entryRETURNEnter a formula as an array formula?+ SHIFT + RETURN orCONTROL + SHIFT + RETURNCancel an entry in the cell or formula barESCDisplay the Formula Builder after you type a valid function name in a formulaCONTROL + AInsert a hyperlink?+ K?orCONTROL + KEdit the active cell and position the insertion point at the end of the lineCONTROL + UOpen the Formula BuilderSHIFT + F3Calculate the active sheetSHIFT + F9Display a contextual menuSHIFT + F10Start a formula=Toggle the formula reference style between absolute, relative, and mixed?+ TorF4Insert the AutoSum formula?+ SHIFT + TEnter the dateCONTROL + SEMICOLON ()Enter the time?+ SEMICOLON ()Copy the value from the cell above the active cell into the cell or the formula barCONTROL + SHIFT + INCH MARK (")Alternate between displaying cell values and displaying cell formulasCONTROL + GRAVE ACCENT (`)Copy a formula from the cell above the active cell into the cell or the formula barCONTROL + APOSTROPHE (')Display the AutoComplete listCONTROL + OPTION + DOWN ARROWDefine a nameCONTROL + LOpen the?Smart Lookup?paneCONTROL + OPTION +??+ LFormat and edit dataToPressEdit the selected cellF2Create a table?+ T?orCONTROL + TInsert a line break in a cell?+ OPTION + RETURN orCONTROL + OPTION + RETURNInsert special characters like symbols, including EmojiCONTROL +??+ SPACEBARIncrease font size?+ SHIFT + >Decrease font size?+ SHIFT + <Align center?+ EAlign left?+ LDisplay the?Modify Cell Style?dialog box?+ SHIFT + LDisplay the?Format Cells?dialog box?+ 1Apply the general number formatCONTROL + SHIFT + ~Apply the currency format with two decimal places (negative numbers appear in red with parentheses)CONTROL + SHIFT + $Apply the percentage format with no decimal placesCONTROL + SHIFT + %Apply the exponential number format with two decimal placesCONTROL + SHIFT + ^Apply the date format with the day, month, and yearCONTROL + SHIFT + #Apply the time format with the hour and minute, and indicate A.M. or P.M.CONTROL + SHIFT + @Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative valuesCONTROL + SHIFT + !Apply the outline border around the selected cells?+ OPTION + ZEROAdd an outline border to the right of the selection?+ OPTION + RIGHT ARROWAdd an outline border to the left of the selection?+ OPTION + LEFT ARROWAdd an outline border to the top of the selection?+ OPTION + UP ARROWAdd an outline border to the bottom of the selection?+ OPTION + DOWN ARROWRemove outline borders?+ OPTION + HYPHENApply or remove bold formatting?+ BApply or remove italic formatting?+ IApply or remove underscoring?+ UApply or remove strikethrough formatting?+ SHIFT + XHide a column?+ )orCONTROL + )Unhide a column?+ SHIFT + )orCONTROL + SHIFT + )Hide a row?+ (orCONTROL + (Unhide a row?+ SHIFT + (orCONTROL + SHIFT + (Edit the active cellCONTROL + UCancel an entry in the cell or the formula barESCEdit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contentsDELETEPaste text into the active cell?+ VComplete a cell entryRETURNGive selected cells the current cell's entry?+ RETURN orCONTROL + RETURNEnter a formula as an array formula?+ SHIFT + RETURN orCONTROL + SHIFT + RETURNDisplay the Formula Builder after you type a valid function name in a formulaCONTROL + AWork with a selectionTo do thisPressCopy?+ CorCONTROL + VPaste?+ V?orCONTROL + VCut?+ XorCONTROL + XClearDELETEDelete the selectionCONTROL + HYPHENUndo the last action?+ ZHide a column?+ )orCONTROL + )Unhide a column?+ SHIFT + )orCONTROL + SHIFT + )Hide a row?+ (orCONTROL + (Unhide a row?+ SHIFT + (orCONTROL + SHIFT + (Move from top to bottom within the selection (down) *RETURNMove from bottom to top within the selection (up) *SHIFT + RETURNMove from left to right within the selection,or move down one cell if only one column is selectedTABMove from right to left within the selection,or move up one cell if only one column is selectedSHIFT + TABMove clockwise to the next corner of the selectionCONTROL + PERIODGroup selected cells?+ SHIFT + KUngroup selected cells?+ SHIFT + J* These shortcuts may move in another direction other than down or up. If you'd like to change the direction of these shortcuts, click the?Excel?menu, and then click?Preferences. Click?Edit. Then change the direction for?After pressing Return, move selection.Select cells, columns, or rowsIf a function key doesn't work as you expect it to, press the?FN?key in addition to the function key. If you don't want to press the FN key each time, you can change your system preferences: Go to?Apple?>?System Preferences?>?Keyboard. Then select the check box for?Use all F1, F2, etc. as standard function keys.To do thisPressExtend the selection by one cellSHIFT + arrow keyExtend the selection to the last nonblank cellin the same column or row as the active cell?+ SHIFT + arrow keyExtend the selection to the beginning of the rowSHIFT + HOMEExtend the selection to the beginning of the sheetCONTROL + SHIFT + HOMEExtend the selection to the last cell usedon the sheet (lower-right corner)CONTROL + SHIFT + ENDSelect the entire columnCONTROL + SPACEBARSelect the entire rowSHIFT + SPACEBARSelect the entire sheet?+ ASelect only visible cells?+ SHIFT + * (asterisk)Select only the active cell when multiple cells are selectedSHIFT + DELETEExtend the selection down one screenSHIFT + PAGE DOWNExtend the selection up one screenSHIFT + PAGE UPAlternate between hiding objects, displaying objects,and displaying placeholders for objectsCONTROL + 6Turn on the capability to extend a selectionby using the arrow keysF8Add another range of cells to the selectionSHIFT + F8Select the current array, which is the array that the?active cell belongs toCONTROL + /Select cells in a row that don't match the valuein the active cell in that row.?You must select the row starting with the active cellCONTROL + \Select only cells that are directly referred to by formulas in the selectionCONTROL + SHIFT + [Select all cells that are directly or indirectly referred to by formulas in the selectionCONTROL + SHIFT + {Select only cells with formulas that refer directly to the active cellCONTROL + ]Select all cells with formulas that refer directly or indirectly to the active cellCONTROL + SHIFT + }Use chartsIf a function key doesn't work as you expect it to, press the?FN?key in addition to the function key. If you don't want to press the FN key each time, you can change your system preferences: Go to?Apple?>?System Preferences?>?Keyboard. Then select the check box for?Use all F1, F2, etc. as standard function keys.To do thisPressInsert a new chart sheet. **F11Cycle through chart object selectionAn arrow key** This shortcut conflicts with a default Mac OS key assignment. To use this shortcut, you must change your Mac keyboard settings. Go to?Apple?>?System Preferences?>?Keyboard?>?Shortcuts. Click?Mission Control, and then click to deselect theShow Desktop?option.Sort, filter, and use PivotTable reportsTo do thisPressOpen the?Sort?dialog box?+ SHIFT + RAdd or remove a filter?+ SHIFT + F?orCONTROL + SHIFT + LDisplay the Filter list or PivotTable pagefield pop-up menu for the selected cellOPTION + DOWN ARROWOutline dataTo do thisPressDisplay or hide outline symbolsCONTROL + 8Hide selected rowsCONTROL + 9Unhide selected rowsCONTROL + SHIFT + (Hide selected columnsCONTROL + ZEROUnhide selected columnsCONTROL + SHIFT + )Work in windowsNOTE:?If a function key doesn't work as you expect it to, press the?FN?key in addition to the function key. If you don't want to press the FN key each time, you can change your system preferences: Go to?Apple?>?System Preferences?>?Keyboard. Then select the check box for?Use all F1, F2, etc. as standard function ressExpand or minimize the ribbon?+ OPTION + RSwitch to full screen view?+ CONTROL + FSwitch to the next application?+ TABSwitch to the previous application?+ SHIFT + TABClose the active workbook window?+ WCopy the image of the screen and save it toa Screen Shot file on your desktop.?+ SHIFT + 3Minimize the active windowCONTROL + F9Maximize or restore the active windowCONTROL + F10?or?+ F10Hide Excel.?+ HWork in dialog boxesTo do thisPressMove to the next text boxTABMove to the previous box, option, control, or commandSHIFT + TABExit a dialog box or cancel an actionESCPerform the action assigned to the default command button(the button with the bold outline, often the?OK?button)RETURNCancel the command and closeESCUse function key shortcutsExcel for Mac 2016 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 shortcutChanging system function key preferences affects how the function keys work for your Mac, not just Excel. After changing this setting, you can still perform the special features printed on a function key. Just press the Fn key. For example, to use the F12 key to change your volume, you would press Fn+F12.If a function key doesn't work as you expect it to, press the?FN?key in addition to the function key. If you don't want to press the FN key each time, you can change your Apple system preferences:Change function key preferences with the mouseOn the?Apple?menu, press?System Preferences.Select?Keyboard.On the?Keyboard?tab, select the check box for?Use all F1, F2, etc. keys as standard function keys.If you need to perform this procedure with the keyboard only, please see the topic Accessibility in Office 2016 for Mac.RemerciementsCes informations sont compilées depuis le site de Microsoft consacré au produit.DiversCe produit est entièrement gratuit. Si vous l'avez apprécié, soyez assez sympa que de verser une contribution que vous estimerez à l'association caritative de votre choixVisitez notre site cadacom.be, tout y est gratuit… ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download