Tasti di scelta rapida di Excel
FavExcel shortcut key query
consult (a document etc)
Introduzione alle scorciatoie da tastiera di Excel:
1. Excel è un software per fogli di calcolo sviluppato da Microsoft e fa parte della suite di applicazioni Microsoft Office.
2. Excel viene utilizzato principalmente per il calcolo e l'analisi dei dati, la creazione di grafici e la visualizzazione dei dati.
3. Padroneggiare le scorciatoie da tastiera di Excel consente di risparmiare molto tempo durante l'utilizzo del programma.
4. È possibile utilizzare questo strumento per cercare i tasti di scelta rapida corrispondenti alle varie funzioni.
Excel common shortcut keys
| functionality | (computer) shortcut key |
|---|---|
| Closing a workbook | Ctrl+W |
| Open a workbook | Ctrl+O |
| Go to the Home tab | Alt+H |
| Saving a workbook | Ctrl+S |
| make a copy of | Ctrl+C |
| paste (as in "copy and paste") | Ctrl+V |
| undo | Ctrl+Z |
| Delete cell contents | Delete key |
| Select Fill Color | Alt+H, H |
| shearing (force) | Ctrl+X |
| Go to the Insert tab | Alt+N |
| thicken | Ctrl+B |
| Center-aligning cell contents | Alt + H、A、C |
| 转至“页面布局 ”选项卡 | Alt+P |
| Go to the "Data" tab | Alt+A |
| Go to the View tab | Alt+W |
| Open context menu | Shift+F10 or context key |
| Adding Borders | Alt+H, B |
| Delete column | Alt + H、D、C |
| Go to the Formulas tab | Alt+M |
| Hide selected rows | Ctrl+9 |
| Hide selected columns | Ctrl+0 |
ribbon tab
| functionality | (computer) shortcut key |
|---|---|
| Operating Instructions Search Box | Alt + Q |
| Open the Documents page. | Alt+F |
| Open the Home tab | Alt+H |
| Open the Insert tab | Alt+N |
| Open the Page Layout tab | Alt+P |
| Open the Formulas tab | Alt+M |
| Open the "Data" tab | Alt+A |
| Open the "Review" tab | Alt+R |
| Open the View tab | Alt+W |
Keyboard Control Function Area
| functionality | (computer) shortcut key |
|---|---|
| Select the Active tab of the ribbon and activate the access key. | Alt or F10 |
| Command to move the focus to the ribbon. | Tab or Shift+Tab |
| Move down, up, left or right between items on the ribbon, respectively. | Down, Up, Left or Right Arrow Keys |
| Activates the selected button. | Space bar or Enter |
| Opens a list of selected commands. | down arrow key (on keyboard) |
| Opens the menu for the selected button. | Alt+down arrow key |
| Moves to the next command when the menu or submenu is open. | down arrow key (on keyboard) |
| Expand or collapse functional areas. | Ctrl+F1 |
| Open the context menu. | Shift+F10 |
| Moves to the submenu when the main menu is open or selected. | left click |
Cell Navigation
| functionality | (computer) shortcut key |
|---|---|
| Move to the previous cell in the worksheet or the previous option in the dialog box | Shift+Tab |
| Moves up one cell in the worksheet. | up button |
| Moves down one cell in the worksheet. | down arrow key (on keyboard) |
| Moves one cell to the left in the worksheet. | left click |
| Move one cell to the right in the worksheet. | right click |
| Move to the edge of the current data area in the worksheet. | Ctrl + arrow keys |
| Move to the last cell on the worksheet, the bottom row of the rightmost column used. | Ctrl+End |
| Extends the cell selection area to the last cell used on the worksheet (lower right corner). | Ctrl+Shift+End |
| Moves to the cell in the upper-left corner of the window when Scroll Lock is on. | Home+Scroll Lock |
| Move to the beginning of the worksheet. | Ctrl+Home |
| Move down one screen in the worksheet. | Page Down |
| Move to the next worksheet in the workbook. | Ctrl+Page Down |
| Move one screen to the right in the worksheet. | Alt+Page Down |
| Move up one screen in the worksheet. | Page Up |
| Move one screen to the left in the worksheet. | Alt+Page Up |
| Move to the previous worksheet in the workbook. | Ctrl+Page Up |
| Moves one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. | Tab |
| Open the list of validation options on the cell where the data validation option is applied. | Alt+down arrow key |
| Wrap around floating shapes such as text boxes or images. | Press Ctrl + Alt + 5, then press Tab repeatedly. |
| Exits the floating shape navigation and returns to the normal navigation. | Esc |
Cell Formatting
| functionality | (computer) shortcut key |
|---|---|
| Open the Set Cell Formatting dialog box. | Ctrl+1 |
| Set the font formatting in the Set Cell Formatting dialog box. | Ctrl+Shift+F or Ctrl+Shift+P |
| 编辑活动单元格，并将插入点放在其内容的末尾。或者，如果单元格的编辑已关闭，则将插入点移到编辑栏中。如果编辑公式，请关闭或打开点模式，以便你可以使用箭头键创建引用。 | F2 |
| Add or edit cell annotations. | Shift+F2 |
| Open the "Insert" dialog box for inserting blank cells. | Ctrl+Shift+Plus (+) |
| Open the Delete dialog box for deleting selected cells. | Ctrl+minus sign (-) |
| Enter the current time. | Ctrl+Shift+Colon (:) |
| Enter the current date. | Ctrl+Semicolon (;) |
| Toggle between displaying cell values or formulas in a worksheet. | Ctrl + Accent (`) |
| Copies the formula from the cell above the active cell to the cell or edit field. | Ctrl+Apostrophe (') |
| Moves the selected cell. | Ctrl+X |
| Duplicate the selected cells. | Ctrl+C |
| Paste the content at the insertion point and replace any selected content. | Ctrl+V |
| Open the Selective Paste dialog box. | Ctrl+Alt+V |
| Set text to italic or remove slant formatting. | Ctrl+I or Ctrl+3 |
| Set text to bold or remove bold formatting. | Ctrl+B or Ctrl+2 |
| Adds an underline to text or removes an underline. | Ctrl+U or Ctrl+4 |
| Applies or removes strikethrough formatting. | Ctrl+5 |
| Toggles between hiding objects, showing objects, and showing placeholders for objects. | Ctrl+6 |
| Applies an outline border to the selected cells. | Ctrl+Shift+与号 (&) |
| Removes the outline border from the selected cells. | Ctrl+Shift+Underline (_) |
| Shows or hides the outline symbol. | Ctrl+8 |
| Use the "Fill Down" command to copy the contents and formatting of the top cell in the selected range to the cell below. | Ctrl+D |
| Apply the "normal" numeric format. | Ctrl+Shift+Waveform Symbol (~) |
| Apply the "currency" format with two decimals (negative numbers in parentheses). | Ctrl+Shift+美元符号 ($) |
| Apply the "percentage" format without decimal places. | Ctrl+Shift+Percentage (%) |
| Apply the scientific notation format with two decimal places. | Ctrl+Shift+Descriptor (^) |
| Apply the "date" format with day, month and year. | Ctrl+Shift+Numeric Symbol (#) |
| Apply the Time format with hours and minutes and AM or PM. | Ctrl+Shift+@ Symbol (@) |
| Applies the Numeric format with two decimals, a thousandths separator, and a minus sign (-) (for negative values). | Ctrl+Shift+Exclamation Point (!) |
| Open the Insert Hyperlink dialog box. | Ctrl+K |
| Check spelling in the activity worksheet or selected range. | F7 |
| Displays the Quick Analyze option for the selected cell containing the data. | Ctrl+Q |
| The Create Table dialog box is displayed. | Ctrl+L or Ctrl+T |
Selecting and executing an action
| functionality | (computer) shortcut key |
|---|---|
| Select the entire worksheet. | Ctrl+A or Ctrl+Shift+Spacebar |
| Selects the current and next worksheet in the workbook. | Ctrl+Shift+Page Down |
| Selects the current and previous worksheet in the workbook. | Ctrl+Shift+Page Up |
| Expands the selected range of a cell by one cell. | Shift+arrow keys |
| 将单元格的选定范围扩展到活动单元格所在列或行中的最后一个非空单元格，或者如果下一个单元格为空，则扩展到下一个非空单元格。 | Ctrl + Shift + Arrow Keys |
| Turn on Extended Mode and use the arrow keys to extend the selected range. Press again to close. | F8 |
| Add non-neighboring cells or regions to the selected range of cells by using the arrow keys. | Shift+F8 |
| Starts a new row in the same cell. | Alt+Enter |
| Fills the selected cell area with the current input. | Ctrl+Enter |
| Complete the cell entry and select the cell above. | Shift+Enter |
| Selects an entire column in the worksheet. | Ctrl+Spacebar |
| Selects an entire row in the worksheet. | Shift+Spacebar |
| Selects all objects on the worksheet when an object is selected. | Ctrl+Shift+Spacebar |
| Extends the selected range of cells to the beginning of the worksheet. | Ctrl+Shift+Home |
| If the worksheet contains data, the current region is selected. Pressing again will select the current area and its summary row. Pressing a third time will select the entire worksheet. | Ctrl+A or Ctrl+Shift+Spacebar |
| Select the current area surrounding the active cell or select the entire pivot table. | Ctrl+Shift+Asterisk (*) |
| When a menu or submenu is visible, select the first command on the menu. | Home |
| Repeat the previous command or operation (if possible). | Ctrl+Y |
| Undo the last operation. | Ctrl+Z |
Handling data, functions and edit fields
| functionality | (computer) shortcut key |
|---|---|
| Type the formula | = (equals sign) |
| Enter formulas as array formulas | Ctrl+Shift+Enter |
| SUM function to insert the "auto-sum" formula | Alt+= (equal sign) |
| Select the entire pivot table. | Ctrl+Shift+Asterisk (*) |
| 编辑活动单元格，并将插入点放在其内容的末尾。或者，如果单元格的编辑已关闭，则将插入点移到编辑栏中。如果编辑公式，请关闭或打开点模式，以便你可以使用箭头键创建引用。 | F2 |
| Expand or collapse the edit field. | Ctrl+Shift+U |
| Cancel input in a cell or edit field. | Esc |
| Complete the entry in the edit field and select the cell below. | Enter |
| When in the edit field, move the cursor to the end of the text. | Ctrl+End |
| Selects all the text in the edit field from the position of the cursor to the end. | Ctrl+Shift+End |
| Calculates all worksheets in all open workbooks. | F9 |
| Calculation Activity Worksheet. | Shift+F9 |
| Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | Ctrl+Alt+F9 |
| Checks the dependent formula and then calculates all cells in all open workbooks, including cells that are not marked as needing to be calculated. | Ctrl+Alt+Shift+F9 |
| Displays the menu or message of the "Error Check" button. | Alt+Shift+F10 |
| When the insertion point is to the right of a function name in a formula, the Function Arguments dialog box is displayed. | Ctrl+A |
| When the insertion point is to the right of a function name in a formula, the parameter name and parentheses are inserted. | Ctrl+Shift+A |
| Call Quick Fill to automatically recognize patterns in neighboring columns and fill the current column. | Ctrl+E |
| If cell references or ranges are selected, it will cycle through all the various combinations of absolute and relative references in the formula. | F4 |
| Insert function. | Shift+F3 |
| Copies the value of the cell above the active cell into the cell or edit field. | Ctrl+Shift+Straight Double Quotes (") |
| Creates an embedded chart of the data in the current range. | Alt+F1 |
| Create a chart of the current range of data in a separate chart worksheet. | F11 |
| Define names to use in references. | Alt+M, M, D |
| Paste a name from the Paste Name dialog box (in case the name is already defined in the workbook) | F3 |
| Moves to the first field in the next record of the data form. | Enter |
| Create, run, edit, or delete macros. | Alt+F8 |
| 打开 Microsoft Visual Basic For Applications Editor。 | Alt+F11 |
function key
| functionality | (computer) shortcut key |
|---|---|
| The Excel Help task pane is displayed. | F1 |
| Show or hide the ribbon. | Ctrl+F1 |
| Creates an embedded chart of the data in the current area. | Alt+F1 |
| Insert a new worksheet. | Alt+Shift+F1 |
| 编辑活动单元格，并将插入点放在其内容的末尾。或者，如果单元格的编辑已关闭，则将插入点移到编辑栏中。如果编辑公式，请关闭或打开点模式，以便你可以使用箭头键创建引用。 | F2 |
| Add or edit cell annotations. | Shift+F2 |
| Displays the Print Preview area on the Print tab in Backstage view. | Ctrl+F2 |
| Displays the Paste Name dialog box. This only applies if the name is already defined in the workbook. | F3 |
| The Insert Function dialog box is displayed. | Shift+F3 |
| Repeat the previous command or operation (if possible).当公式中选定单元格引用或区域时，按 F4 可在绝对和相对引用的所有各种组合中循环切换。 | F4 |
| Closes the selected workbook window. | Ctrl+F4 |
| Close Excel. | Alt+F4 |
| The Positioning dialog box is displayed. | F5 |
| Restores the window size of the selected workbook window. | Ctrl+F5 |
| 在工作表、functionality区、任务窗格和缩放控件之间切换。在已拆分的工作表中，在窗格和functionality区区域之间切换时，按 F6 可包括已拆分的窗格。 | F6 |
| Switch between worksheets, zoom controls, task panes, and ribbons. | Shift+F6 |
| If more than one workbook window is open, press Ctrl+F6 to switch to the next workbook window. | Ctrl+F6 |
| Opens the Spell Check dialog box for checking spelling in the active worksheet or selected range. | F7 |
| 如果工作簿窗口未最大化，则按 Ctrl+F7 可对该窗口执行“移动”命令。使用箭头键移动窗口，并在完成时按 Enter，或按 Esc 取消。 | Ctrl+F7 |
| Turns extended mode on or off. In Expanded Mode, "Expanded Selected" will appear in the status line, and pressing the arrow keys will expand the selection. | F8 |
| Allows you to use the arrow keys to add non-neighboring cells or regions to the selected range of cells. | Shift + F8 |
| When the workbook is not maximized, execute the "Size" command. | Ctrl+F8 |
| Displays the Macro dialog box for creating, running, editing, or deleting macros. | Alt+F8 |
| Calculates all worksheets in all open workbooks. | F9 |
| Calculation Activity Worksheet. | Shift+F9 |
| Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | Ctrl+Alt+F9 |
| Recheck the dependent formulas and then calculate all cells in all open workbooks, including cells that are not marked as needing to be calculated. | Ctrl+Alt+Shift+F9 |
| Minimizes the workbook window to an icon. | Ctrl+F9 |
| Turns the shortcut prompt on or off. (Pressing Alt accomplishes the same thing.) | F10 |
| Displays a shortcut menu for the selected item. | Shift+F10 |
| Displays the menu or message of the "Error Check" button. | Alt+Shift+F10 |
| Maximizes or restores the selected workbook window. | Ctrl+F10 |
| Create a chart of the current range of data in a separate chart worksheet. | F11 |
| Insert a new worksheet. | Shift+F11 |
| 打开 Microsoft Visual Basic For Applications 编辑器，你可以在该编辑器中通过使用 Visual Basic for Applications (VBA) 来创建宏。 | Alt+F11 |
| The Save As dialog box is displayed. | F12 |
Recommended Tools
![Calcolatore online dell'area dell'ellisse]()
Calcolatore online dell'area dell'ellisse
Widget per il calcolo dell'area di un'ellisse online
![Miglior calcolatore della distanza di visione per TV a schermo piatto]()
Miglior calcolatore della distanza di visione per TV a schermo piatto
Calcolare la distanza di visione ottimale in base alle dimensioni del televisore o dello schermo piatto.
![Calcolatrice online dell'area circolare]()
Calcolatrice online dell'area circolare
Widget per il calcolo dell'area di un cerchio online
![Calcolo della superficie cilindrica]()
Calcolo della superficie cilindrica
Calcolare la superficie di un cilindro online
![Conversione del colore CMYK/esadecimale]()
Conversione del colore CMYK/esadecimale
Strumento di conversione del colore tra il formato CMYK e il formato HEX.
![L'elenco completo dei corali]()
L'elenco completo dei corali
Un'ampia raccolta di distici con query ricercabili
![Previsioni di febbre auricolare]()
Previsioni di febbre auricolare
Widget di previsione online
![Calcolatore del sonno per bambini]()
Calcolatore del sonno per bambini
Calcolo del tempo di sonno per i bambini di tutte le età
![Strumenti di formazione alla visione]()
Strumenti di formazione alla visione
Strumenti online per l'allenamento della vista e il rilassamento degli occhi
![Calcolatore del tasso di prestito inverso]()
Calcolatore del tasso di prestito inverso
Calcolare il tasso di interesse del prestito utilizzando l'importo del rimborso mensile e l'importo del prestito.
![Modalità da colore a bianco e nero]()
Modalità da colore a bianco e nero
Strumento per la conversione di immagini a colori in bianco e nero
![Da JSON a cookie online]()
Da JSON a cookie online
Convertire i dati in formato JSONS in dati cookie online
![Crittografia dell'offuscamento del codice JS]()
Crittografia dell'offuscamento del codice JS
Strumento di crittografia online per l'offuscamento del codice jsJS
![Generatore di scritte vuote]()
Generatore di scritte vuote
Generare online manifesti vuoti da stampare
![Tasti di scelta rapida VSCode]()
Tasti di scelta rapida VSCode
Query online vscode code editor tasti di scelta rapida elenco completo
![Imitazione della fotocamera del telefono cellulare Xiaomi Strumento filigrana Laika]()
Imitazione della fotocamera del telefono cellulare Xiaomi Strumento filigrana Laika
Strumento online per aggiungere watermark simili a quelli di Lycra alle immagini
![conversione dell'unità di lunghezza]()
conversione dell'unità di lunghezza
Strumento di conversione della lunghezza online
![Promemoria sulla sedentarietà]()
Promemoria sulla sedentarietà
Widget di promemoria online sulla sedentarietà basato sul web
![Fusione di file PDF]()
Fusione di file PDF
Combinare più file PDF in un unico file PDF online
![Conversione del calendario lunare/solare]()
Conversione del calendario lunare/solare
Strumento di conversione data lunare/data solare online
![il Libro della Poesia]()
il Libro della Poesia
Apprezzamento del testo integrale dei Salmi online
![Visualizza la fonte della pagina]()
Visualizza la fonte della pagina
Visualizzare il codice sorgente della pagina web online
![Tabella di riferimento della durezza]()
Tabella di riferimento della durezza
Tabella di confronto della durezza online
![Ruota della fortuna]()
Ruota della fortuna
Strumento di lotteria online Lucky Roulette con estrazioni personalizzabili.
粤ICP备2021116614号