Excel Shortcuts
excel shortcut key query
query
Excel Shortcuts Introduction
About Excel shortcuts:1. Excel is a spreadsheet software developed by Microsoft, which is part of the Microsoft Office suite of productivity software.
2. Excel is mainly used for data calculation, data analysis, chart making and data visualization.
3, proficient in Excel shortcut keys, you can use Excel spreadsheet software, save a lot of time.
4, you can use this tool to search for the corresponding shortcut keys.
commonly used shortcut keys for excel
| function | shortcut key |
|---|---|
| close the workbook | Ctrl+W |
| open a workbook | Ctrl+O |
| go to the home tab | Alt+H |
| save the workbook | Ctrl+S |
| copy | Ctrl+C |
| paste | Ctrl+V |
| undo | Ctrl+Z |
| delete cell content | delete key |
| select the fill color | Alt+H, H |
| cut | Ctrl+X |
| go to the insert tab | Alt+N |
| bold | Ctrl+B |
| center aligning cell contents | Alt + H、A、C |
| go to the page layout tab | Alt+P |
| go to the data tab | Alt+A |
| go to the view tab | Alt+W |
| open the context menu | shift+f10 or context key |
| add borders | Alt+H, B |
| delete columns | Alt + H、D、C |
| go to the formulas tab | Alt+M |
| hide selected rows | Ctrl+9 |
| hide selected columns | Ctrl+0 |
ribbon tab
| function | shortcut key |
|---|---|
| operation instructions search box | Alt + Q |
| open the "file" page | Alt+F |
| open the home page 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 ribbon
| function | shortcut key |
|---|---|
| select the active tab of the ribbon and activate the access key. | alt or f10 |
| command to move focus to the ribbon. | tab or shift+tab |
| move down, up, left or right between items on the functional area respectively. | down, up, left or right arrow keys |
| activate the selected button. | spacebar or enter |
| opens a list of selected commands. | down arrow key |
| opens the menu for the selected button. | alt+down arrow key |
| when the menu or submenu is open, move to the next command. | down arrow key |
| expand or collapse the ribbon. | Ctrl+F1 |
| open the context menu. | Shift+F10 |
| when the main menu is open or selected, move to the submenu. | left arrow |
cell navigation
| function | shortcut key |
|---|---|
| move to previous cell in the worksheet or previous option in the dialog box | Shift+Tab |
| move a cell upward in the worksheet. | up arrow |
| move a cell downward in the worksheet. | down arrow key |
| move a cell to the left in the worksheet. | left arrow |
| move a cell to the right in the worksheet. | right arrow key |
| move to the edge of the current data area in the worksheet. | ctrl + arrow key |
| move to the last cell on the worksheet, the bottom row of the rightmost column you are using. | Ctrl+End |
| expand the cell selected area to the last used cell on the worksheet (bottom right corner). | Ctrl+Shift+End |
| when scroll lock is on, move to the cell in the upper left corner of the window. | Home+Scroll Lock |
| move to the beginning of the worksheet. | Ctrl+Home |
| move one screen down 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 one screen upwards 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 |
| move a cell to the right in the worksheet. alternatively, in a protected worksheet, move between unlocked cells. | Tab |
| open the list of validation options on the cell where the data validation options are applied. | alt+down arrow key |
| surround floating shapes such as text boxes or images. | press ctrl + alt + 5, and then repeat the tab key |
| exit floating shape navigation and return to normal navigation. | Esc |
cell formatting
| function | shortcut key |
|---|---|
| open the format cell dialog box. | Ctrl+1 |
| set the font format in the format cell dialog box. | ctrl+shift+f or ctrl+shift+p |
| edit the active cell and place the insertion point at the end of its content. alternatively, if the cell's editing is closed, move the insertion point to the edit bar. if you edit a formula, turn off or turn on dot mode so that you can use the arrow keys to create references. | F2 |
| add or edit cell annotations. | Shift+F2 |
| opens the insert dialog box for inserting blank cells. | ctrl+shift+plus(+) |
| opens the delete dialog box for deleting the selected cell. | ctrl+minus sign (-) |
| enter the current time. | ctrl+shift+colon(:) |
| enter the current date. | ctrl+semi-colon(;) |
| in the worksheet, switch between displaying cell values or formulas. | ctrl+accent notes (`) |
| copy the formula from the cell above the active cell to the cell or edit bar. | ctrl+apostrophe(') |
| move the selected cell. | Ctrl+X |
| copy the selected cell. | Ctrl+C |
| paste content at the insertion point and replace any selected content. | Ctrl+V |
| opens the paste special dialog box. | Ctrl+Alt+V |
| set the text to italics or remove the tilt format. | ctrl+i or ctrl+3 |
| set text to bold or delete bold format. | ctrl+b or ctrl+2 |
| add or remove underscores to text. | ctrl+u or ctrl+4 |
| apply or delete strikethrough format. | Ctrl+5 |
| switch between hidden objects, display objects, and display objects placeholders. | Ctrl+6 |
| applies an outline border to the selected cell. | ctrl+shift+&sign(&) |
| remove the outline border from the selected cell. | ctrl+shift+underscore(_) |
| show or hide outline symbols. | Ctrl+8 |
| use the fill down command to copy the content and format of the topmost cell in the selected range to the following cells. | Ctrl+D |
| apply "regular" digital format. | ctrl+shift+wave symbol(~) |
| apply the "currency" format with two decimals (negative numbers are placed in brackets). | ctrl+shift+dollar sign ($) |
| apply "percentage" format without decimal places. | ctrl+shift+percent(%) |
| apply a scientific counting format with two decimals. | ctrl+shift+font size(^) |
| apply the "date" format with day, month, and year. | ctrl+shift+number symbol(#) |
| apply the "time" format with hours and minutes and am or pm. | ctrl+shift+@ symbol (@) |
| apply a "numeric" format with two decimals, thousands of decimals, and minus sign (-) (for negative values). | ctrl+shift+exclamation mark(!) |
| open the insert hyperlink dialog box | Ctrl+K |
| check spellings in the activity sheet or selected range. | F7 |
| displays the quick analysis option for selected cells containing data. | Ctrl+Q |
| the create table dialog box is displayed. | ctrl+l or ctrl+t |
select and perform an action
| function | shortcut key |
|---|---|
| select the entire worksheet. | ctrl+a or ctrl+shift+space |
| select the current and next worksheets in the workbook. | Ctrl+Shift+Page Down |
| select the current and previous worksheets in the workbook. | Ctrl+Shift+Page Up |
| expands the selected range of the cell by one cell. | shift+arrow keys |
| extends the selected range of the cell to the last non-empty cell in the column or row where the active cell is located, or to the next non-empty cell if the next cell is empty. | ctrl + shift + arrow keys |
| turn on expand mode and use the arrow keys to expand the selected range. press again to close. | F8 |
| add non-neighboring cells or ranges to the selected range of a cell by using the arrow keys. | Shift+F8 |
| start a new row in the same cell. | Alt+Enter |
| use the current input to fill the selected cell area. | Ctrl+Enter |
| complete cell input and select the above cell. | Shift+Enter |
| select the entire column in the worksheet. | ctrl+space key |
| select the entire row in the worksheet. | shift+space bar |
| when an object is in a selected state, select all objects on the worksheet. | ctrl+shift+space |
| extends the selected range of the cell to the beginning of the worksheet. | Ctrl+Shift+Home |
| if the worksheet contains data, select the current region. press again to select the current region and its summary row. pressing the third time will select the entire worksheet. | ctrl+a or ctrl+shift+space |
| select the current area surrounding the active cell or select the entire pivot table. | ctrl+shift+asterisk(*) |
| when the menu or submenu is visible, select the first command on the menu. | Home |
| repeat the previous command or action (if possible). | Ctrl+Y |
| undo the last action. | Ctrl+Z |
process data, functions and editing bars
| function | shortcut key |
|---|---|
| type a formula | = (equal sign) |
| enter formula as array formula | Ctrl+Shift+Enter |
| insert "automatic sum" formula with sum function | alt+=(equal sign) |
| select the entire pivot table. | ctrl+shift+asterisk(*) |
| edit the active cell and place the insertion point at the end of its content. alternatively, if the cell's editing is closed, move the insertion point to the edit bar. if you edit a formula, turn off or turn on dot mode so that you can use the arrow keys to create references. | F2 |
| expand or collapse the edit bar. | Ctrl+Shift+U |
| cancel input in the cell or edit bar. | Esc |
| complete the input in the edit bar and select the cell below. | Enter |
| when in the edit bar, move the cursor to the end of the text. | Ctrl+End |
| select all text in the edit bar from where the cursor is located to the end. | Ctrl+Shift+End |
| calculates all worksheets in all open workbooks. | F9 |
| calculate activity worksheets. | Shift+F9 |
| calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | Ctrl+Alt+F9 |
| check the subordinate formula and then calculate all cells in all open workbooks, including cells that are not marked as to need to be calculated. | Ctrl+Alt+Shift+F9 |
| a menu or message that displays the error check button. | Alt+Shift+F10 |
| when the insertion point is to the right of a function name in the formula, the function parameters dialog box appears. | Ctrl+A |
| when the insertion point is to the right of a function name in the formula, the parameter name and brackets are inserted. | Ctrl+Shift+A |
| call quick fill to automatically identify patterns in adjacent columns and fill the current column | Ctrl+E |
| if a cell reference or range is selected, it switches loop between all various combinations of absolute and relative references in the formula. | F4 |
| insert function. | Shift+F3 |
| copy the value of the cell above the active cell to the cell or edit bar. | ctrl+shift+straight double quotes (") |
| create an embedded chart of data in the current scope. | Alt+F1 |
| create a chart of the data in the current range in a separate chart sheet. | F11 |
| define a name for use in a reference. | Alt+M, M, D |
| paste the name from the paste name dialog box (if the name has been defined in the workbook) | F3 |
| move to the first field in the next record in the data form. | Enter |
| create, run, edit, or delete macros. | Alt+F8 |
| open microsoft visual basic for applications editor. | Alt+F11 |
function keys
| function | shortcut key |
|---|---|
| the excel help task pane displays. | F1 |
| show or hide the ribbon. | Ctrl+F1 |
| create an embedded chart of data in the current area. | Alt+F1 |
| insert a new worksheet. | Alt+Shift+F1 |
| edit the active cell and place the insertion point at the end of its content. alternatively, if the cell's editing is closed, move the insertion point to the edit bar. if you edit a formula, turn off or turn on dot mode so that you can use the arrow keys to create references. | F2 |
| add or edit cell annotations. | Shift+F2 |
| displays the print preview area on the print tab in backstage view. | Ctrl+F2 |
| the paste name dialog box appears. only applicable to cases where names have been defined in the workbook. | F3 |
| the insert function dialog box is displayed. | Shift+F3 |
| repeat the previous command or action (if possible). when a cell reference or region is selected in the formula, press f4 to switch loops across all various combinations of absolute and relative references. | 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 |
| switch between worksheets, ribbons, task panes, and zoom controls. in a split worksheet, press f6 to include the split pane when switching between the pane and the ribbon area. | F6 |
| switch between worksheets, zoom controls, task panes, and ribbons. | Shift+F6 |
| if multiple workbook windows are opened, press ctrl+f6 to switch to the next workbook window. | Ctrl+F6 |
| opens the spell check dialog box to check spellings in the active worksheet or selected range. | F7 |
| if the workbook window is not maximized, press ctrl+f7 to execute the "move" command on the window. use the arrow keys to move the window and press enter when finished, or press esc to cancel. | Ctrl+F7 |
| turns the extended mode on or off. in extended mode, extended selection appears in the status line and press the arrow key to expand the selected range. | F8 |
| allows you to use arrow keys to add non-neighboring cells or ranges to the selected range of a cell. | Shift + F8 |
| when the workbook is not maximized, execute the size command. | Ctrl+F8 |
| displays the macro dialog box to create, run, edit, or delete macros. | Alt+F8 |
| calculates all worksheets in all open workbooks. | F9 |
| calculate activity worksheets. | Shift+F9 |
| calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. | Ctrl+Alt+F9 |
| recheck the subordinate formula and calculate all cells in all open workbooks, including cells that are not marked as to need to be calculated. | Ctrl+Alt+Shift+F9 |
| minimize the workbook window to an icon. | Ctrl+F9 |
| turn the shortcut key prompt on or off. (click alt to achieve the same purpose.) | F10 |
| displays the shortcut menu for the selected item. | Shift+F10 |
| a menu or message that displays the error check button. | Alt+Shift+F10 |
| maximize or restore the selected workbook window. | Ctrl+F10 |
| create a chart of the data in the current range in a separate chart sheet. | F11 |
| insert a new worksheet. | Shift+F11 |
| open the microsoft visual basic for applications editor where you can create macros by using visual basic for applications (vba). | Alt+F11 |
| the save as dialog box appears. | F12 |
Internet Business Promoter
![baby eye color prediction]()
baby eye color prediction
online prediction of baby's eyes
![Online Elliptical Area Calculator]()
Online Elliptical Area Calculator
Small tool for calculating ellipse area online
![Density unit conversion]()
Density unit conversion
Density Unit Online Conversion Tool
![Two color mixer]()
Two color mixer
Mix the two colors to get a new color!
![Color Matching Calculator]()
Color Matching Calculator
Accurately calculate the degree of matching between colors to help users easily obtain aesthetic matching schemes.
![Excel function summary]()
Excel function summary
Common Excel function online search
![HSV/CMYK conversion]()
HSV/CMYK conversion
HSV format color and CMYK format color conversion tool
![HTML/SWS Interconversion tool]()
HTML/SWS Interconversion tool
Online HTML and SWS code interconversion tool
![Martian Conversion Tool]()
Martian Conversion Tool
Entertainment tool Mars Online conversion tool
![Currency Exchange Rate conversion Tool]()
Currency Exchange Rate conversion Tool
International Currency Exchange rate online conversion tool
![Chinese ID card information query]()
Chinese ID card information query
Resident ID card, Hong Kong, Macao and Taiwan resident permit, foreigner permanent residence ID card parsing tool
![JSON/GET request string translation]()
JSON/GET request string translation
Online JSON and GET request string conversion tool
![Online Screen recording tool]()
Online Screen recording tool
Online screen recording tool can record the screen without downloading
![Chinese Name Generator]()
Chinese Name Generator
A small tool that can randomly generate the names of boys and girls
![Cardio (fat burning) Heart Rate Calculator]()
Cardio (fat burning) Heart Rate Calculator
Calculate the optimal heart rate for aerobic exercise (fat burning)
![Shake encryption]()
Shake encryption
online string Shake encryption tool
![Online countdown timer]()
Online countdown timer
An online time countdown gadget
![Retirement Time and Date Calculator]()
Retirement Time and Date Calculator
Help you calculate retirement date, how many days to work
![Text to binary conversion tool]()
Text to binary conversion tool
online text and binary interconversion tool
![Online text deduplication tool]()
Online text deduplication tool
online text reprocessing tool
![Camera test]()
Camera test
Online mobile phone/computer camera test tool
![Temperature unit conversion]()
Temperature unit conversion
Temperature unit Online conversion tool
![Wedge Volume Calculator]()
Wedge Volume Calculator
Calculate the volume of the wedge from known data
![Save and retrieve calculator]()
Save and retrieve calculator
Online bank deposit and withdrawal calculator
