◆ EXCEL shortcut key: If you accidentally change the composition of the formula when using the ESC key to modify the cell, you can use the ESC key to exit, so as not to destroy the formula.
◆ EXCEL shortcut key: CTRL+ arrow keys move to the edge of the current data area.
◆ EXCEL shortcut key: HOME moves to the beginning of the line.
◆ EXCEL shortcut key: CTRL+HOME moves to the beginning of the worksheet.
◆ EXCEL shortcut key: CTRL+END moves to the last cell of the worksheet, which is located at the intersection of the rightmost column and the bottom row in the data area (lower right corner); Or the cell opposite the first cell (generally A 1).
◆ EXCEL shortcut key: PAGE DOWN moves down one screen.
◆ EXCEL shortcut key: PAGE UP moves up one screen.
◆ EXCEL shortcut key: ALT+PAGE DOWN moves one screen to the right.
◆ EXCEL shortcut key: ALT+PAGE UP moves one screen to the left.
◆ EXCEL shortcut key: CTRL+F6 or CTRL+TAB moves to the next workbook or window.
◆ EXCEL shortcut key: CTRL+SHIFT+F6 or CTRL+SHIFT+TAB moves to the previous workbook or window.
◆ EXCEL shortcut key: F6 moves to the next pane of the split workbook.
◆ EXCEL shortcut key: SHIFT+F6 moves to the previous pane in the split workbook.
◆ EXCEL shortcut key: CTRL+BACKSPACE scrolls the active cell.
◆ EXCEL shortcut key: F5 displays the "Positioning" dialog box.
◆ EXCEL shortcut key: SHIFT+F5 displays the Find dialog box.
◆ EXCEL shortcut key: SHIFT+F4 repeats the last search operation (equivalent to finding the next one).
◆ EXCEL shortcut key: TAB moves between unlocked cells in the protection worksheet.
◆ EXCEL shortcut key: SCROLL LOCK turns on or off the scroll lock.
◆ EXCEL shortcut key: HOME moves to the cell in the upper left corner of the window.
◆ EXCEL shortcut key: END moves to the cell in the lower right corner of the window.
◆ EXCEL shortcut key: the up arrow key or the down arrow key scrolls up or down one line.
◆ EXCEL shortcut key: the left arrow key or the right arrow key scrolls a column left or right.
◆ EXCEL shortcut key: When previewing and printing documents, press CTRL+P or CTRL+SHIFT+F 12 to display the print dialog box.
◆ EXCEL shortcut key: When zooming in, press the arrow keys in the print preview to complete moving in the document.
◆ EXCEL shortcut key: press PAGE UP or PAGE DOWN in print preview to finish. Scroll one page at a time in the document when zooming out.
◆ EXCEL shortcut key: press CTRL+ UP ARROW or CTRL+ LEFT ARROW in print preview to finish. Scroll to the first page when zooming out.
◆ EXCEL shortcut key: press CTRL+ DOWN ARROW or CTRL+ RIGHT ARROW in print preview. Scroll to the last page when zooming out.
◆ EXCEL shortcut: press SHIFT+F 1 1 or ALT+SHIFT+F 1 to insert a new worksheet.
Excel shortcut: press F 1 1 or ALT+F 1 to create a chart using the current area.
◆ EXCEL shortcuts: used for worksheets, charts and macros. Press SHIFT+CTRL+PAGE UP to select the current workbook or the previous workbook in the workbook.
◆ EXCEL shortcut key: press Enter for data input to complete cell input and move it down in the selected area.
◆ EXCEL shortcut key: ALT+ENTER key used to input data wraps in the cell.
◆ EXCEL shortcut key: CTRL+ENTER key used to input data, filling the selected cell area with the current input item.
◆ EXCEL shortcut key: SHIFT+ENTER key used to input data to complete cell input and move it up in the selected area.
◆ EXCEL shortcut key: the key TAB used to input data completes cell input and moves to the right in the selected area.
◆ EXCEL shortcut key: SHIFT+TAB key used for data input completes cell input and moves to the left in the selected area.
◆ EXCEL shortcut key: the ESC key used to input data cancels cell input.
◆ EXCEL shortcut key: used to input data backspace key, delete the characters on the left side of the insertion point or delete the selected area.
◆ EXCEL shortcut key: used to enter data, delete, delete the characters to the right of the insertion point or delete the selected area.
◆ EXCEL shortcut key: CTRL+DELETE, which is used to input data and delete the text from the insertion point to the end of the line.
◆ EXCEL shortcut key: The key and arrow keys used to input data move one character up, down, left and right.
◆ EXCEL shortcut key: the HOME key of data input is moved to the beginning of the line.
◆ EXCEL shortcut key: press F4 or CTRL+Y to repeat the last operation when entering data.
◆ EXCEL shortcut key: SHIFT+F2 is used for data entry and editing cell comments.
◆ EXCEL shortcut key: CTRL+SHIFT+F3 keys used to input data create names through row or column markers.
◆ EXCEL shortcut key: CTRL+D key used to input data fills down.
◆ EXCEL shortcut key: CTRL+R key for data input is filled on the right.
◆ EXCEL shortcut key: CTRL+F3 key used to input data defines the name.
◆ EXCEL shortcut key: use the key BACKSPACE in the cell or edit bar to edit the active cell, and then clear the cell, or delete the previous characters in the active cell when editing the cell contents.
◆ EXCEL shortcut key: press Enter in the cell or edit bar to complete cell input.
◆ EXCEL shortcut key: use CTRL+SHIFT+ENTER key in cell or edit bar to enter formula in the form of array formula.
◆ EXCEL shortcut key: press ESC in the cell or edit bar to cancel the entry in the cell or edit bar.
Excel shortcut key: CTRL+A key used in a cell or edit bar. After typing the function name in the formula, the formula palette will be displayed.
◆ EXCEL shortcut key: CTRL+SHIFT+A key used in cell or edit bar. After typing the function name in the formula, insert the variable name and parentheses of the function.
◆ EXCEL shortcut key: use CTRL+K key to insert hyperlink in cell or edit bar.
◆ EXCEL shortcut key: press Enter in the cell or edit bar (in the cell with hyperlink) to activate the hyperlink.
◆ EXCEL shortcut key: Press F2 in the cell or edit bar to edit the active cell, and put the insertion point at the end of the line.
◆ EXCEL shortcut key: Press F3 in the cell or edit bar to paste the defined name into the formula.
◆ EXCEL shortcut key: use SHIFT+F3 key in the cell or edit bar to paste the function into the formula.
◆ EXCEL shortcut key: Press F9 in the cell or edit bar to calculate all worksheets in all open workbooks.
◆ EXCEL shortcut key: Use CTRL+ALT+F9 in the cell or edit bar to calculate all worksheets in the active workbook.
◆ EXCEL shortcut key: Use SHIFT+F9 key to calculate active sheet in cell or edit bar.
◆ EXCEL shortcut key: key = (equal sign) formula used in cell or edit bar.
◆ EXCEL shortcut key: use ALT+= (equal sign) key to insert "automatic summation" formula in the cell or edit bar.
◆ EXCEL shortcut key: CTRL+ key used in cell or edit bar; (Semicolon) Enter the date.
◆ EXCEL shortcut key: the key CTRL+SHIFT+: (colon) used to enter time in a cell or edit bar.
◆ EXCEL shortcut key: use the CTRL+SHIFT+ (double quotation marks) key in the cell or edit bar to copy the value in the cell above the current cell to the current cell or edit bar.
◆ EXCEL shortcut key: the CTRL+++` (left single quotation mark) key used in a cell or edit bar switches between displaying cell values and displaying cell formulas.
◆ EXCEL shortcut key: Press CTRL+ (apostrophe) in the cell or edit bar to copy the formula in the cell above the current cell to the current cell or edit bar.
◆ EXCEL shortcut key: press ALT+ down arrow key in the cell or edit bar to display the "Memory Typing" list.
◆ EXCEL shortcut key: press ALT+ (apostrophe) to set the data format of the display style dialog box.
◆ EXCEL shortcut key: press CTRL+ 1 to set the data format and display the cell format dialog box.
◆ EXCEL shortcut key: press CTRL+SHIFT+~ to set data format and apply "normal" number format.
◆ EXCEL shortcut key: press CTRL+SHIFT+$ to set the data format and apply the "credit currency" format with two decimal places (negative numbers in brackets).
◆ EXCEL shortcut key: press CTRL+SHIFT+% to set the data format and apply the "percentage" format without decimal places.
◆ EXCEL shortcut key: set the data format Ctrl+Shift+ the key to apply the number format with two decimal places of "scientific counting".
◆ EXCEL shortcut key: press CTRL+SHIFT+# to set the data format and apply the date format of year, month and day.
◆ EXCEL shortcut key: press CTRL+SHIFT+@ to set the data format, and apply the hour and minute "time" format to indicate morning or afternoon.
◆ EXCEL shortcut key: CTRL+SHIFT+ key for setting data format! Apply a number format with a thousand separator, and negative numbers are represented by a minus sign (-).
◆ EXCEL shortcut key: CTRL+SHIFT+ Apply the outer border to set the data format.
◆ EXCEL shortcut key: press CTRL+SHIFT+_ to set the data format and delete the outer border.
◆ EXCEL shortcut key: press CTRL+B to set data format and apply or cancel font bold format.
◆ EXCEL shortcut key: press CTRL+I to set the data format and apply or cancel the font skew format.
◆ EXCEL shortcut key: press CTRL+U to set data format and apply or cancel underline format.
◆ EXCEL shortcut key: press CTRL+5 to set the data format and apply or cancel the strikethrough format.
◆ EXCEL shortcut key: press CTRL+9 to set data format to hide lines.
◆ EXCEL shortcut key: press CTRL+SHIFT+ ((left parenthesis) to set data format and unhide lines.
◆ EXCEL shortcut key: press CTRL+0 (zero) to set the data format to hide columns.
◆ EXCEL shortcut key: press CTRL+SHIFT+ (right bracket) to set the data format to unhide the column.
◆ EXCEL shortcut key: F2 key used to edit data edits the active cell and places the insertion point at the end of the line.
◆ EXCEL shortcut key: the key to edit data ESC cancels the entry in the cell or edit bar.
◆ EXCEL shortcut key: edit data backspace key to edit the active cell and clear its original content, or delete the previous character in the active cell when editing the cell contents.
◆ EXCEL shortcut key: press F3 to edit the data and paste the defined name into the formula.
◆ EXCEL shortcut key: Enter to edit data and complete cell input.
◆ EXCEL shortcut key: press CTRL+SHIFT+ENTER to edit the data input formula into an array formula.
◆ EXCEL shortcut key: press CTRL+A to edit data. After you type the function name in the formula, the formula palette is displayed.
◆ EXCEL shortcut key: press CTRL+SHIFT+A to edit data. After typing the function name in the formula, insert the variable name and parentheses of the function.
◆ EXCEL shortcut key: Press F7 to edit the data and display the "Spelling Check" dialog box.
◆ EXCEL shortcut key: CTRL+C copies the selected area.
◆ EXCEL shortcut key: CTRL+X cuts the selected area.
◆ EXCEL shortcut key: CTRL+V paste the selected area.
◆ EXCEL shortcut key: DELETE to clear the contents of the selected area.
◆ EXCEL shortcut key: CTRL+ hyphen to delete the selected area.
◆ EXCEL shortcut key: CTRL+Z to cancel the last operation.
◆ EXCEL shortcut key: CTRL+SHIFT+ plus sign to insert a blank cell.
◆ EXCEL shortcut key: ENTER moves from top to bottom in the selected area, or moves in the selected direction in the editing tab (click Options in the Tools menu).
Excel shortcut key: SHIFT+ENTER moves in the selected area from bottom to top, or moves in the direction opposite to the direction selected in the Edit tab (click Options in the Tools menu).
◆ EXCEL shortcut key: TAB moves from left to right in the selected area. If only one column is selected, one cell is moved down.
◆ EXCEL shortcut key: SHIFT+TAB moves from right to left in the selected area. If only one column is selected, one cell is moved up.
◆ EXCEL shortcut key: CTRL+ period moves clockwise to the next corner of the selected area.
◆ EXCEL shortcut key: CTRL+ALT+ Right arrow key moves to the right to the non-adjacent selected area.
◆ EXCEL shortcut key: CTRL+ALT+ Left arrow key moves to the left to the non-adjacent selected area.
Excel shortcut key: CTRL+SHIFT+* (asterisk) selects the area around the current cell (the selected area is the data area surrounded by blank rows and columns).
◆ EXCEL shortcut key: SHIFT+ arrow keys will expand the selected area by one cell width.
◆ EXCEL shortcut key: CTRL+SHIFT+ Arrow keys expand the selected area to the last non-blank cell in the same row or column as the active cell.
◆ EXCEL shortcut key: SHIFT+HOME expands the selected area to the beginning of the line.
◆ EXCEL shortcut key: CTRL+SHIFT+HOME extends the selected area to the beginning of the worksheet.
◆ EXCEL shortcut key: CTRL+SHIFT+END expands the selected area to the last cell used in the worksheet (lower right corner).
◆ EXCEL shortcut key: CTRL+ SPACEBAR to select the whole column.
◆ EXCEL shortcut key: SHIFT+ spacebar to select the whole line.
◆ EXCEL shortcut key: CTRL+A selects the whole worksheet.
◆ EXCEL shortcut key: SHIFT+BACKSPACE If multiple cells are selected, only the active cell is selected.
◆ EXCEL shortcut key: SHIFT+PAGE DOWN enlarges the selected area by one screen.
◆ EXCEL shortcut key: SHIFT+PAGE UP enlarges the selected area by one screen.
◆ EXCEL shortcut key: When selecting an object, CTRL+SHIFT+ SPACEBAR selects all the objects on the worksheet.
◆ EXCEL shortcut key: CTRL+6 switches between hidden objects, displayed objects and object placeholders.
◆ EXCEL shortcut key: CTRL+7 shows or hides common toolbars.
◆ EXCEL shortcut key: F8 Use arrow keys to start the function of expanding the selected area.
◆ EXCEL shortcut key: SHIFT+F8 adds cells from other areas to the selected area, or use arrow keys to move to the beginning of the selected area to be added, and then press F8 and arrow keys to select the next area.
◆ EXCEL shortcut key: SCROLL LOCK, SHIFT+HOME to expand the selected area to the cell in the upper left corner of the window.
◆ EXCEL shortcut key: scroll lock, SHIFT+END to expand the selected area to the cell in the lower right corner of the window.
◆ EXCEL shortcut key: When "scroll lock" is turned off, you are prompted to use scroll keys (such as PAGEUP and PAGEDOWN), and the selected area will move accordingly. To keep the selected area when scrolling, you should first turn on the "scroll lock" function. Keys that extend the selected area in end mode.
◆ EXCEL shortcuts: used for databases and data lists. The key is ALT+ key. The key is the underlined letters in the field or command name. Select a field or command button.
◆ EXCEL shortcut key: used for databases and data lists. Press the down arrow key to move to the same field of the next record.
◆ EXCEL shortcut key: the up arrow key used for database and data list moves to the same field of the previous record.
◆ EXCEL shortcut key: the key label used for database and data list moves to the next editable field in the record.
◆ EXCEL shortcut key: SHIFT+TAB key for database and data list moves to the last editable field in the record.
◆ EXCEL shortcut key: ENTER key used for database and data list moves to the first field of the next record.
◆ EXCEL shortcut key: SHIFT+ENTER key for database and data list moves to the first field of the previous record.
◆ EXCEL shortcut key: the key PAGE DOWN used for database and data list is moved to the same field of the first 10 records.
◆ EXCEL shortcut key: CTRL+PAGE DOWN key for database and data list moves to new record.
◆ EXCEL shortcut key: the key PAGE UP used for database and data list is moved to the same field of the last 10 record.
◆ EXCEL shortcut key: the key of database and data list EXCEL shortcut key: the key of database and data list CTRL+PAGE UP moves to the first record.
◆ EXCEL shortcut key: the HOME or END key used for database and data list is moved to the beginning or end of the field.
◆ EXCEL shortcut key: Press SHIFT+END for the database and data list to extend the selected area to the end of the field.
◆ EXCEL shortcut key: SHIFT+HOME is used for databases and data lists to extend the selected area to the beginning of the field.
◆ EXCEL shortcut key: The left arrow key or right arrow key used for databases and data lists moves one character to the left or right in the field.
◆ EXCEL shortcut key: press SHIFT+ left arrow key for database and data list, and select the character on the left.
◆ EXCEL shortcut key: Press SHIFT+ right arrow key for database and data list, and select the character on the right.
◆ EXCEL shortcut key: use the Auto Filter button, use the arrow keys to select the cell containing the column label, and then press ALT+ DOWN ARROW key to display the auto filter list of the current column.
◆ EXCEL shortcut key: press the down arrow key with the auto filter key to select the next item in the auto filter list.
◆ EXCEL shortcut key: use the up arrow key of automatic filtering to select the previous item in the automatic filtering list.
◆ EXCEL shortcut key: use the automatic filter key ALT+ up arrow key to close the automatic filter list of the current column.
◆ EXCEL shortcut key: Use the auto filter button HOME to select the first item ("All") in the "auto filter" list.
◆ EXCEL shortcut key: use the automatic filter key END to select the last item in the automatic filter list.
◆ EXCEL shortcut key: use the automatic filter key ENTER to filter the current column with the selected items in the automatic filter list.
◆ EXCEL shortcut key: F 10 or ALT key used for menus and toolbars activates the menu bar or closes the visible menu and submenu at the same time.
◆ EXCEL shortcut key: the key TAB or SHIFT+TAB used for menus and toolbars (when the toolbar is activated) is used to select the next or previous button or menu on the toolbar.
◆ EXCEL shortcut key: press CTRL+TAB or CTRL+SHIFT+TAB (when the toolbar is activated) to select the next or previous toolbar.
◆ EXCEL shortcut key: ENTER key for menus and toolbars, which is used to open the selected menu or perform the operation assigned to the selected button.
◆ EXCEL shortcut key: SHIFT+F 10 key used for menus and toolbars displays shortcut menus.
◆ EXCEL shortcut key: ALT+ SPACEBAR used for menus and toolbars displays the program icon menu (in the program title bar).
◆ EXCEL shortcut key: used to press down arrow key or up arrow key (when the menu or submenu is displayed) to select the next or previous command in the menu or submenu.
◆ EXCEL shortcut key: Use the left arrow key or right arrow key of the menu and toolbar to select the left or right menu, or switch between the main menu and the submenu when the submenu is visible.
◆ EXCEL shortcut key: For menus and toolbars, press HOME or END to select the first or last command in the menu or submenu.
◆ EXCEL shortcut key: The ESC key used for menus and toolbars only closes the visible menu, or only closes the submenu when it is visible.
◆ EXCEL shortcut key: CTRL+ DOWN ARROW key for menus and toolbars displays all commands in the menu.
◆ EXCEL shortcut: The buttons on the menu and toolbar prompt you to use the keyboard to select any command in the menu or any visible toolbar. Press ALT to select the menu bar (to select toolbars with EXCEL shortcuts: menus and toolbar keys, press CTRL+TAB repeatedly until the desired toolbar is selected). Press the underlined letter in the menu name to open the menu, and then press the underlined letter in the desired command.
◆ EXCEL shortcut key: press ALT+TAB in the window, dialog box and edit box to switch to the next program.
◆ EXCEL shortcut key: press ALT+SHIFT+TAB in the window, dialog box and edit box to switch to the previous program.
◆ EXCEL shortcut key: Press CTRL+ESC in the window, dialog box and edit box to display the Windows start menu.
Excel shortcut: Press CTRL+W or CTRL+F4 in windows, dialog boxes and edit boxes to close the active workbook window.
◆ EXCEL shortcut key: Press CTRL+F5 in the window, dialog box and edit box to restore the size of the active workbook window.
◆ EXCEL shortcut key: the key F6 in the window, dialog box and edit box moves to the next pane of the split workbook.
◆ EXCEL shortcut key: SHIFT+F6 in windows, dialog boxes and edit boxes moves to the previous pane of the split workbook.
◆ EXCEL shortcut key: press CTRL+F6 in the window, dialog box and edit box to switch to the next workbook window.
◆ EXCEL shortcut key: press CTRL+SHIFT+F6 in the window, dialog box and edit box to switch to the previous workbook window.
◆ EXCEL shortcut key: Press CTRL+F7 in the window, dialog box and edit box to execute the "Move" command (the workbook icon menu in the menu bar), or use the arrow keys to move the window.
◆ EXCEL shortcut key: Press CTRL+F8 in the window, dialog box and edit box to execute the size command (the workbook icon menu in the menu bar), or use the arrow keys to adjust the window size.
◆ EXCEL shortcut key: Press CTRL+F9 in the window, dialog box and edit box to minimize the workbook window to an icon.
◆ EXCEL shortcut key: Press CTRL+F 10 in the window, dialog box and edit box to maximize or restore the workbook window.
◆ EXCEL shortcut key: Press PRTSCR in the window, dialog box and edit box to copy the screen image to the clipboard.
◆ EXCEL shortcut: Press ALT+PRINT SCREEN in the window, dialog box and edit box to copy the image of the active window to the clipboard.
◆ EXCEL shortcut key: the ALT+ 1 key used in the open and save as dialog box goes to the previous F folder ().
Excel shortcut key: the ALT+2 key used in the Open and Save As dialog boxes opens the folder at the previous level of the current folder (the "Previous Level" button).
◆ EXCEL shortcut key: ALT+3 key used in the Open and Save As dialog boxes closes the dialog box and opens the search page (the "Search Web Page" button) on the global WAN.
◆ EXCEL shortcut key: Press ALT+4 in the open and save as dialog box to delete the selected folder or file ("Delete" button).
Excel shortcut key: ALT+5 key used in the Open and Save As dialog boxes will create a new subfolder (New Folder button) in the opened folder.
Excel shortcut key: ALT+6 key used in the Open and Save As dialog boxes switches between data list, detailed data, properties and preview view.
◆ EXCEL shortcut key: ALT+7 key used in the open and save as dialog box displays the tool menu (tool button).