Combinazioni di tasti per velocizzare l’uso di Excel.
| Categoria | Descrizione | Combinazione |
|---|---|---|
| File | Create new workbook | Ctrl + N |
| File | Open workbook | Ctrl + O |
| File | Save workbook | Ctrl + S |
| File | Save as | F12 |
| File | Print file | Ctrl + P |
| File | Open print preview window | Ctrl + F2 |
| File | Close current workbook | Ctrl + F4 |
| File | Close Excel | Alt + F4 |
| Ribbon | Expand or collapse ribbon | Ctrl + F1 |
| Ribbon | Activate access keys | Alt |
| Ribbon | Move to next ribbon control | Tab |
| Ribbon | Activate or open selected control | Space |
| Ribbon | Confirm control change | Enter |
| Ribbon | Get help on selected control | F1 |
| General | Open help | F1 |
| General | Undo last action | Ctrl + Z |
| General | Redo last action | Ctrl + Y |
| General | Repeat last action | F4 |
| General | Copy selected cells | Ctrl + C |
| General | Cut selected cells | Ctrl + X |
| General | Paste content from clipboard | Ctrl + V |
| General | Display the Paste Special dialog box | Ctrl + Alt + V |
| General | Display find and replace | Ctrl + F |
| General | Display find and replace, replace selected | Ctrl + H |
| General | Find next match | Shift + F4 |
| General | Find previous match | Ctrl + Shift + F4 |
| General | Create embedded chart | Alt + F1 |
| General | Create chart in new worksheet | F11 |
| General | Toggle Autofilter | Ctrl + Shift + L |
| General | Activate filter | Alt + DownArrow |
| General | Insert table | Ctrl + T |
| General | Select table row | Shift + Space |
| General | Select table column | Ctrl + Space |
| General | Select table | Ctrl + A |
| Drag and Drop | Drag and cut | drag |
| Drag and Drop | Drag and copy | Ctrl + drag |
| Drag and Drop | Drag and insert | Shift + drag |
| Drag and Drop | Drag and insert copy | Ctrl + Shift + drag |
| Drag and Drop | Drag to worksheet | Alt + drag |
| Drag and Drop | Drag to duplicate worksheet | Ctrl + drag |
| Navigation | Move one cell right | RightArrow |
| Navigation | Move one cell left | LeftArrow |
| Navigation | Move one cell up | UpArrow |
| Navigation | Move one cell down | DownArrow |
| Navigation | Move one screen right | Alt + PgDn |
| Navigation | Move one screen left | Alt + PgUp |
| Navigation | Move one screen up | PgUp |
| Navigation | Move one screen down | PgDn |
| Navigation | Move to right edge of data region | Ctrl + RightArrow |
| Navigation | Move to left edge of data region | Ctrl + LeftArrow |
| Navigation | Move to top edge of data region | Ctrl + UpArrow |
| Navigation | Move to bottom edge of data region | Ctrl + DownArrow |
| Navigation | Move to beginning of row | Home |
| Navigation | Move to last cell in worksheet | Ctrl + End |
| Navigation | Move to first cell in worksheet | Ctrl + Home |
| Navigation | Turn End mode on | End |
| Selection | Select entire row | Shift + Space |
| Selection | Select entire column | Ctrl + Space |
| Selection | Select entire worksheet | Ctrl + A |
| Selection | Add adjacent cells to selection | Shift + Click |
| Selection | Add non-adjacent cells to selection | Ctrl + Click |
| Selection | Move right between non-adjacent selections | Ctrl + Alt + RightArrow |
| Selection | Move left between non-adjacent selections | Ctrl + Alt + LeftArrow |
| Selection | Toggle add to selection mode | Shift + F8 |
| Selection | Cancel selection | Esc |
| Active Cell | Select active cell only | Shift + Backspace |
| Active Cell | Show the active cell on worksheet | Ctrl + Backspace |
| Active Cell | Move active cell clockwise in selection | Ctrl + . |
| Active Cell | Move active cell down in selection | Enter |
| Active Cell | Move active cell up in selection | Shift + Enter |
| Active Cell | Move active cell right in a selection | Tab |
| Active Cell | Move active cell left in a selection | Shift + Tab |
| Extend Selection | Extend selection by one cell right | Shift + RightArrow |
| Extend Selection | Extend selection by one cell left | Shift + LeftArrow |
| Extend Selection | Extend selection by one cell up | Shift + UpArrow |
| Extend Selection | Extend selection by one cell down | Shift + DownArrow |
| Extend Selection | Extend the selection to the last cell right | Ctrl + Shift + RightArrow |
| Extend Selection | Extend the selection to the last cell left | Ctrl + Shift + LeftArrow |
| Extend Selection | Extend the selection to the last cell up | Ctrl + Shift + UpArrow |
| Extend Selection | Extend the selection to the last cell down | Ctrl + Shift + DownArrow |
| Extend Selection | Extend selection up one screen | Shift + PgUp |
| Extend Selection | Extend selection down one screen | Shift + PgDn |
| Extend Selection | Extend selection right one screen | Alt + Shift + PgDn |
| Extend Selection | Extend selection left one screen | Alt + Shift + PgUp |
| Extend Selection | Extend selection to start of row | Shift + Home |
| Extend Selection | Extend selection to first cell in worksheet | Ctrl + Shift + Home |
| Extend Selection | Extend selection to last cell in worksheet | Ctrl + Shift + End |
| Extend Selection | Toggle extend selection mode | F8 |
| Select Special | Display 'Go To' dialog box | Ctrl + G |
| Select Special | Select cells with comments | Ctrl + Shift + O |
| Select Special | Select current region around active cell | Ctrl + Shift + * |
| Select Special | Select current region | Ctrl + A |
| Select Special | Select current array | Ctrl + / |
| Select Special | Select row differences | Ctrl + \ |
| Select Special | Select column differences | Ctrl + Shift + | |
| Select Special | Select direct precedents | Ctrl + [ |
| Select Special | Select all precedents | Ctrl + Shift + { |
| Select Special | Select direct dependents | Ctrl + ] |
| Select Special | Select all dependents | Ctrl + Shift + } |
| Select Special | Select visible cells only | Alt + ; |
| Cell edit mode | Edit the active cell | F2 |
| Cell edit mode | Insert or edit comment | Shift + F2 |
| Cell edit mode | Cancel entry | Esc |
| Cell edit mode | Select one character right | Shift + RightArrow |
| Cell edit mode | Select one character left | Shift + LeftArrow |
| Cell edit mode | Move one word right | Ctrl + RightArrow |
| Cell edit mode | Move one word left | Ctrl + LeftArrow |
| Cell edit mode | Select one word right | Ctrl + Shift + RightArrow |
| Cell edit mode | Select one word left | Ctrl + Shift + LeftArrow |
| Cell edit mode | Select to beginning of cell | Shift + Home |
| Cell edit mode | Select to end of cell | Shift + End |
| Cell edit mode | Delete to end of line | Ctrl + Delete |
| Cell edit mode | Delete character to the left of cursor | Backspace |
| Cell edit mode | Delete character to the right of cursor | Delete |
| Cell edit mode | Start a new line in the same cell | Alt + Enter |
| Entering data | Enter and move down | Enter |
| Entering data | Enter and move up | Shift + Enter |
| Entering data | Enter and move right | Tab |
| Entering data | Enter and move left | Shift + Tab |
| Entering data | Complete entry and stay in same cell | Ctrl + Enter |
| Entering data | Enter same data in multiple cells | Ctrl + Enter |
| Entering data | Insert current date | Ctrl + ; |
| Entering data | Insert current time | Ctrl + Shift + : |
| Entering data | Fill down from cell above | Ctrl + D |
| Entering data | Fill right from cell left | Ctrl + R |
| Entering data | Copy formula from cell above | Ctrl + ' |
| Entering data | Copy value from cell above | Ctrl + Shift + " |
| Entering data | Add hyperlink | Ctrl + K |
| Entering data | Display AutoComplete list | Alt + DownArrow |
| Entering data | Flash fill | Ctrl + E |
| Formatting | Format (almost) anything | Ctrl + 1 |
| Formatting | Display Format Cells with Font tab selected | Ctrl + Shift + F |
| Formatting | Apply or remove bold formatting | Ctrl + B |
| Formatting | Apply or remove italic formatting | Ctrl + I |
| Formatting | Apply or remove underscoring | Ctrl + U |
| Formatting | Apply or remove strikethrough formatting | Ctrl + 5 |
| Formatting | Align center | Alt + H + A + C |
| Formatting | Align left | Alt + H + A + L |
| Formatting | Align right | Alt + H + A + R |
| Formatting | Indent | Alt + H + 6 |
| Formatting | Remove indent | Alt + H + 5 |
| Formatting | Increase font size one step | Alt + H + F + G |
| Formatting | Decrease font size one step | Alt + H + F + K |
| Number Formatting | Apply general format | Ctrl + Shift + ~ |
| Number Formatting | Apply currency format | Ctrl + Shift + $ |
| Number Formatting | Apply percentage format | Ctrl + Shift + % |
| Number Formatting | Apply scientific format | Ctrl + Shift + ^ |
| Number Formatting | Apply date format | Ctrl + Shift + # |
| Number Formatting | Apply time format | Ctrl + Shift + @ |
| Number Formatting | Apply number format | Ctrl + Shift + ! |
| Borders | Add border outline | Ctrl + Shift + & |
| Borders | Add or remove border right | Alt + R |
| Borders | Add or remove border left | Alt + L |
| Borders | Add or remove border top | Alt + T |
| Borders | Add or remove border bottom | Alt + B |
| Borders | Add or remove border upward diagonal | Alt + D |
| Borders | Add or remove border horizontal interior | Alt + H |
| Borders | Add or remove border vertical interior | Alt + V |
| Borders | Remove borders | Ctrl + Shift + _ |
| Formulas | Toggle absolute and relative references | F4 |
| Formulas | Open the Insert Function Dialog Box | Shift + F3 |
| Formulas | Autosum selected cells | Alt + = |
| Formulas | Toggle formulas on and off | Ctrl + ' |
| Formulas | Insert function arguments | Ctrl + Shift + A |
| Formulas | Enter array formula | Ctrl + Shift + Enter |
| Formulas | Calculate worksheets | F9 |
| Formulas | Calculate active worksheet | Shift + F9 |
| Formulas | Force calculate all worksheets | Ctrl + Alt + F9 |
| Formulas | Evaluate part of a formula | F9 |
| Formulas | Expand or collapse the formula bar | Ctrl + Shift + U |
| Formulas | Display function arguments dialog box | Ctrl + A |
| Formulas | Define name | Ctrl + F3 |
| Formulas | Define name using row and column labels | Ctrl + Shift + F3 |
| Formulas | Paste name into formula | F3 |
| Formulas | Accept function with autocomplete | Tab |
| Grid Operations | Display Insert Dialog box | Ctrl + Shift + + |
| Grid Operations | Insert rows | Ctrl + Shift + + |
| Grid Operations | Insert columns | Ctrl + Shift + + |
| Grid Operations | Display Delete dialog box | Ctrl + - |
| Grid Operations | Delete rows | Ctrl + - |
| Grid Operations | Delete columns | Ctrl + - |
| Grid Operations | Delete cells | Ctrl + - |
| Grid Operations | Delete contents of selected cells | Delete |
| Grid Operations | Hide columns | Ctrl + 0 |
| Grid Operations | Hide rows | Ctrl + 9 |
| Grid Operations | Unhide rows | Ctrl + Shift + 9 |
| Grid Operations | Unhide columns | Ctrl + Shift + 0 |
| Grid Operations | Group rows or columns | Alt + Shift + RightArrow |
| Grid Operations | Ungroup rows or columns | Alt + Shift + LeftArrow |
| Grid Operations | Open Group Dialog Box | Alt + Shift + RightArrow |
| Grid Operations | Open Ungroup Dialog Box | Alt + Shift + LeftArrow |
| Grid Operations | Hide or show outline symbols | Ctrl + 8 |
| Pivot Tables | Select entire pivot table | Ctrl + A |
| Pivot Tables | Toggle pivot table field checkbox | Space |
| Pivot Tables | Group pivot table items | Alt + Shift + RightArrow |
| Pivot Tables | Ungroup pivot table items | Alt + Shift + LeftArrow |
| Pivot Tables | Hide pivot table item | Ctrl + - |
| Pivot Tables | Create pivot chart on same worksheet | Alt + F1 |
| Pivot Tables | Create pivot chart on new worksheet | F11 |
| Pivot Tables | Open pivot table wizard | Alt + D + P |
| Workbook | Insert new worksheet | Shift + F11 |
| Workbook | Go to next worksheet | Ctrl + PgDn |
| Workbook | Go to previous worksheet | Ctrl + PgUp |
| Workbook | Move to next pane | F6 |
| Workbook | Move to previous pane | Shift + F6 |
| Workbook | Go to next workbook | Ctrl + Tab |
| Workbook | Go to previous workbook | Ctrl + Shift + Tab |
| Workbook | Minimize current workbook window | Ctrl + F9 |
| Workbook | Maximize current workbook window | Ctrl + F10 |
| Workbook | Select adjacent worksheets | Shift + Click |
| Workbook | Select non-adjacent worksheets | Ctrl + Click |
| Workbook | Toggle scroll lock | ScrLk |
| Dialog boxes | Move to next control | Tab |
| Dialog boxes | Move to previous control | Shift + Tab |
| Dialog boxes | Move to next tab | Ctrl + Tab |
| Dialog boxes | Move to previous tab | Ctrl + Shift + Tab |
| Dialog boxes | Accept and apply | Enter |
| Dialog boxes | Check and uncheck box | Space |
| Dialog boxes | Cancel and close the dialog box | Esc |
| Other | Open Spelling dialog box | F7 |
| Other | Open Thesaurus dialog box | Shift + F7 |
| Other | Open Macro dialog box | Alt + F8 |
| Other | Open VBA Editor | Alt + F11 |
| Other | Duplicate object | Ctrl + D |
| Other | Snap to grid | Alt |
| Other | Hide or show objects | Ctrl + 6 |
| Other | Display Modify Cell Style dialog box | Alt + ' |
| Other | Display shortcut menu | Shift + F10 |
| Other | Display control menu | Alt + Space |