Полный список горячих клавиш Excel

Fav

Excel shortcut key query

consult (a document etc)

Введение в горячие клавиши Excel:

1. Excel — это программа для работы с электронными таблицами, разработанная компанией Microsoft и входящая в состав пакета офисных программ Microsoft Office.

2. Excel в основном используется для вычислений, анализа данных, создания диаграмм и визуализации данных.

3. Умение свободно пользоваться горячими клавишами в Excel позволит вам сэкономить много времени при работе с программой.

4. С помощью этого инструмента вы можете найти горячие клавиши, соответствующие тем или иным функциям.

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