Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

FORMATTING DATA EDITING Bold CTRL + B Fill Down CTRL + D Italic CTRL + I Fill R

FORMATTING DATA EDITING Bold CTRL + B Fill Down CTRL + D Italic CTRL + I Fill Right CTRL + R Underline CTRL + U Find CTRL + F Format Box CTRL + 1 Replace CTRL + H Copy CTRL + C Flash Fill CTRL + E Paste CTRL + V Edit Cells F2 Paste Only Formats ALT + E + S + T Autosum ALT + “+=” Paste Only Formulas ALT + E + S + F Anchor “fix” cells F4 Paste Only Values ALT + E + S + V Cancel a cell entry ESC Cut CTRL + X Increase decimal ALT + H + 0 Repeat CTRL + Y Decrease decimal ALT + H + 9 Undo CTRL + Z Delete cell contents Delete TAB NAVIGATION Delete all cell attributes ALT + H + E + A Move/Copy a tab ALT + H + O + M Delete cell comment ALT + H + E + M Change tab name ALT + H + O + R Outline border SHIFT + CTRL + & Moving within tabs CTRL + Pg Up/Down Remove border SHIFT + CTRL + _ Insert worksheet ALT + I + W Insert a comment SHIFT + F2 Merge and center ALT + H + M + C ROWS / COLUMNS Align Left ALT + H + A + L Select column CTRL + Space Select row Shift + Space BOOK NAVIGATION Delete row/column CTRL + „minus sign‟ Switch excel books CTRL + TAB Add row/column CTRL + Shift + „plus‟ Split Screen ALT + W + S Group/ungroup rows SHIFT + ALT + left/right Freeze pane ALT + W + F + F Fit column width ALT + H + O + I New workbook CTRL + N Print CTRL + P CELL NAVIGATION Open workbook CTRL + O Go to end of range CTRL + arrow keys Save workbook CTRL + S Select a cell range Shift + arrow keys Activate menu bar ALT or F10 Highlight range SHIFT + CTRL + arrow Min / Restore Ribbon CTRL + F1 Move to beginning Home Print Preview CTRL + F2 Move to cell “A1” CTRL + Home Close window CTRL + F4 Move to cell above SHIFT + ENTER Close program ALT + F4 Move to cell right TAB Show formulas CTRL + ~ OTHER USEFUL Fill selection w/ entry CTRL + Enter Excel Options ALT + F + T Recalculate all F9 EXTRA USEFUL Get inside a drop-down ALT + up/down arrow Trace Precedents ALT + T + U + T Enter array formula SHIFT + CTRL + Enter Trace Dependents ALT + T + U + D Insert pivot table ALT + N + V Remove Traces ALT + T + U + A Insert data table ALT + D + T Go to Precedent CTRL + [ Sort a table ALT + D + S Go to Dependent CTRL + ] Autofilter selection ALT + A + T Switch between menu F6 Record a Macro ALT + L + R Apply currency format CTRL + SHIFT + $ Open border menu ALT + H + B uploads/Geographie/ excel-shortcut-guide.pdf