Hot keys are a function that, by typing a specific key combination on the keyboard, offers quick access to certain features of the operating system or a separate program. This tool is also available in Microsoft Excel. Let's find out what hotkeys are available in Excel and what you can do with them.
First of all, it should be noted that in the list of hotkeys below, the single “+” sign will serve as the symbol that represents the keyboard shortcut. If the “++” sign is indicated, this means that on the keyboard you need to press the “+” key along with the other key that is indicated. The name of the function keys is indicated as they are called on the keyboard: F1, F2, F3, etc.
Also, it should be said that you need to press the service keys first. These include Shift, Ctrl and Alt. And then, holding these keys, press the function keys, buttons with letters, numbers, and other symbols.
General settings
Microsoft's general management tools include the basic capabilities of the program: opening, saving, creating a file, etc. The hotkeys that provide access to these functions are as follows:
- Ctrl+N – create a file;
- Ctrl+S – save the book;
- F12 – select the format and location of the book to save;
- Ctrl+O – open a new book;
- Ctrl+F4 – close the book;
- Ctrl+P – print preview;
- Ctrl+A – select the entire sheet.
Navigation keys
There are also hotkeys for navigating through a sheet or book.
- Ctrl + F6 – move between several open books;
- Tab – move to the next cell;
- Shift + Tab – move to the previous cell;
- Page Up – move up by monitor size;
- Page Down – move down by monitor size;
- Ctrl + Page Up – move to the previous sheet;
- Ctrl + Page Down – move to the next sheet;
- Ctrl + End – move to the last cell;
- Ctrl + Home – move to the first cell.
Hotkeys for computing activities
The Microsoft Excel program is used not only for simple construction of tables, but also for computational operations in them by entering formulas. There are corresponding hotkeys for quick access to these actions.
- Alt+= — activation of autosum;
- Ctrl+~ - display calculation results in cells;
- F9 – recalculation of all formulas in the file;
- Shift+F9 – recalculation of formulas on the active sheet;
- Shift+F3 – call the Function Wizard.
Data editing
Hotkeys designed for editing data allow you to quickly fill the table with information.
- F2 – editing mode of the marked cell;
- Ctrl++ - adding columns or rows;
- Ctrl+- - deletes selected columns or rows on a Microsoft Excel table sheet;
- Ctrl+Delete – deleting selected text;
- Ctrl+H – “Search/Replace” window;
- Ctrl+Z – cancel the last action performed;
- Ctrl+Alt+V – special paste.
Formatting
One of the important elements of designing tables and cell ranges is formatting. In addition, formatting also affects calculation processes in Excel.
- Ctrl+Shift+% - enable percentage format;
- Ctrl+Shift+$—monetary format;
- Ctrl+Shift+# — date format;
- Ctrl+Shift+! – number format;
- Ctrl+Shift+~ - general format;
- Ctrl+1 – activation of the cell formatting window.
Other hotkeys
In addition to the hotkeys that were indicated in the above groups, the Excel application has the following important combinations of keyboard buttons for calling functions:
- Alt+’ – select a design style;
- F11 – create a chart on a new sheet;
- Shift+F2 – change a comment in a cell;
- F7 – check text for errors.
Of course, not all options for using hot keys in Microsoft Excel were presented above. However, we paid attention to the most popular, useful, and in-demand ones. Of course, using hot keys can significantly simplify and speed up work in Microsoft Excel.
Many users find that they can successfully use Excel for Windows using an external keyboard with shortcut keys. For users with disabilities or low vision, shortcut keys may be more convenient than using a touch screen or mouse. This article describes the shortcut keys available when working with Excel for Windows.
Notes:
The keyboard shortcuts in this article follow the US keyboard layout. Keyboard shortcuts for other keyboard layouts may differ from those shown here.
In combinations where several keys are pressed simultaneously, their names are separated by a plus sign (+). If the keys are pressed sequentially, they are separated by a comma (,).
Notes:
To make reference information available while working with the program, you can print this article. To do this, press CTRL+P.
Frequently used keyboard shortcuts
key hints On the ribbon, related commands are grouped into tabs. For example, the Number group on the Home tab contains a Number Format element.
This table lists the most common shortcut keys for Excel.
Action
| Keys
|
|---|
|
Closing the book
|
|
|
Opening a book
|
|
|
Go to tab home
|
|
|
Saving a book
|
|
|
Copying
|
|
|
|
|
|
Canceling an operation
|
|
|
Deleting cell contents
|
|
|
Selecting a fill color
|
|
|
Cutting
|
|
|
Go to tab Insert
|
|
|
Bold
|
|
|
Centering cell contents
|
|
|
Go to tab Page layout
|
|
|
Go to tab Data
|
|
|
Go to tab View
|
|
|
Opening the context menu
|
SHIFT+F10 or
context menu key
|
|
Adding borders
|
|
|
Delete a column
|
|
|
Go to tab Formula
|
|
|
Hiding selected rows
|
|
|
Hiding selected columns
|
Ribbon keyboard shortcuts
If you're just getting started with the Ribbon, this section will teach you how to use keyboard shortcuts to work with it.
When you press the ALT key, small images of letters called letters will appear next to the tabs and commands on the ribbon. key hints, as shown in the figure below.
When you combine these letters with the ALT key, you get shortcuts called ribbon command access keys. For example, the keyboard shortcut ALT+I opens the "Home" tab, and using the keys ALT+Y you can go to the field assistant.
Press the ALT key again to view the key hints for commands on any tab.
Ribbon tab access keys
To go to a tab on the ribbon, press one of the following access keys.
Action
| Keyboard shortcut
|
|---|
|
Field opening assistant on the ribbon and enter a search term to get help or open help.
|
ALT+Y, then enter your search term.
|
|
Open the File page and use Backstage view.
|
|
|
Open the Home tab and format text and numbers, or use the search tool.
|
|
|
Open the Insert tab and insert pivot tables, charts, add-ins, sparklines, pictures, shapes, titles, or text boxes.
|
|
|
Opens the Page Layout tab to work with themes, page settings, scale, and alignment.
|
|
|
Opens the Formulas tab to insert, track, and customize functions and calculations.
|
|
|
Open the Data tab to connect to, sort, filter, analyze, and more data.
|
|
|
Open the Review tab to check spelling, add comments, and protect sheets and workbooks.
|
|
|
Opens the View tab to view page breaks, choose view modes, show and hide gridlines and titles, change zoom, manage windows and panes, and view macros.
|
Working with ribbon tabs using the keyboard
Action
| Keyboard shortcut
|
|---|
|
Select the active ribbon tab and activate access keys.
|
ALT or F10. To move to another tab, use the access keys or arrow keys.
|
|
Move focus to commands on the ribbon.
|
TAB or SHIFT+TAB
|
|
Move down, up, left, or right between ribbon elements.
|
ARROW DOWN, UP, LEFT or RIGHT
|
|
Activate the selected button.
|
SPACEBAR or ENTER
|
|
Opens a list for the selected command.
|
DOWN ARROW key
|
|
Opens the menu for the selected button.
|
ALT+DOWN ARROW
|
|
Moves to the next command in an open menu or submenu.
|
DOWN ARROW key
|
|
Expanding or collapsing the tape.
|
|
|
Open the context menu.
|
Or on a Windows keyboard:
Context menu key (between the ALT and CTRL keys on the right)
|
|
Move to a submenu in an open or selected menu.
|
LEFT ARROW key
|
A reference to keyboard shortcuts in Excel
Keyboard shortcuts for moving through cells
Action
| Keys
|
|---|
|
Moves to the previous worksheet cell or previous option in a dialog box.
|
|
|
Move up one cell in the worksheet.
|
UP ARROW key
|
|
Move one cell down on the worksheet.
|
DOWN ARROW key
|
|
Move one cell to the left on the worksheet.
|
LEFT ARROW key
|
|
Moves one cell to the right on the worksheet.
|
RIGHT ARROW key
|
|
Moves to the edge of the current data area on the worksheet.
|
CTRL+arrow key
|
|
Enters END mode, moves to the next non-blank cell in the column or row that contains the active cell, and exits END mode. If cells are empty, move to the last cell in the row or column.
|
END, arrow key
|
|
Moves to the last cell on the worksheet in the lowest usable row in the rightmost usable column.
|
|
|
Extends the selection to the last used worksheet cell (lower right corner).
|
|
|
When SCROLL LOCK mode is enabled, move to the cell in the upper left corner of the window.
|
HOME+SCROLL LOCK
|
|
Go to the beginning of the sheet.
|
|
|
Move one screen down the sheet.
|
|
|
Move to the next sheet in the workbook.
|
|
|
Move one screen to the right on the sheet.
|
|
|
Move one screen up the sheet.
|
|
|
Move one screen to the left on the sheet.
|
|
|
Move to the previous sheet in the workbook.
|
|
|
Moves one cell to the right on the worksheet. In a protected sheet, transition between unprotected cells.
|
|
|
Opens a list of checks for a cell that has a data check option applied to it.
|
ALT+DOWN ARROW
|
|
Switch between movable shapes, such as text boxes or images.
|
CTRL+ALT+5 and then pressing the TAB key repeatedly
|
|
Exit Movable Shape Navigation mode and return to normal navigation.
|
Keyboard shortcuts for formatting cells
Action
| Keyboard shortcut
|
|---|
|
Opens the Format Cells dialog box.
|
|
|
Formatting fonts using the Format Cells dialog box.
|
CTRL+SHIFT+F or CTRL+SHIFT+P
|
|
Change the active cell and move the cursor to the end of the content. If editing is disabled for a cell, the insertion point is placed in the formula bar. When editing a formula, you can turn hint mode on or off so you can use the arrow keys to create a reference.
|
|
|
Add or change a note to a cell.
|
|
|
Opens the Add Cells dialog box to insert blank cells.
|
CTRL+SHIFT+plus sign (+)
|
|
Open the Delete Cells dialog box
|
CTRL+minus sign (-)
|
|
Insert current time.
|
CTRL+SHIFT+colon (:)
|
|
Insert the current date.
|
CTRL+SHIFT+semicolon (;)
|
|
|
CTRL+accent mark (`)
|
|
Copy a formula from the top cell to the active cell or to the formula bar.
|
CTRL+apostrophe (")
|
|
Move selected cells.
|
|
|
Copy selected cells.
|
|
|
Inserts content at the insertion point, replacing the selected content.
|
|
|
Opens the Paste Special dialog box.
|
|
|
|
CTRL+I or CTRL+3
|
|
|
CTRL+B or CTRL+2
|
|
Underline text or remove underlining.
|
CTRL+U or CTRL+4
|
|
Apply or remove strikethrough.
|
|
|
Toggle between hiding objects, showing objects, and showing object placeholders.
|
|
|
|
CTRL+SHIFT+ampersand (&)
|
|
|
CTRL+SHIFT+underscore (_)
|
|
Show or hide outline symbols.
|
|
|
Use the Fill Down command to copy the contents and format of the top cell of a selection range to all the cells below.
|
|
|
|
CTRL+SHIFT+tilde (~)
|
|
|
CTRL+SHIFT+dollar sign ($)
|
|
|
CTRL+SHIFT+percent sign (%)
|
|
|
CTRL+SHIFT+lid (^)
|
|
|
CTRL+SHIFT+number sign (#)
|
|
|
CTRL+SHIFT+"@" sign
|
|
|
CTRL+SHIFT+exclamation mark (!)
|
|
|
|
|
Check spelling on the active worksheet or in the selected range.
|
|
|
Displays express analysis options for selected cells containing data.
|
|
|
Displays the Create Table dialog box.
|
CTRL+L or CTRL+T
|
Keyboard shortcuts for actions and selections
Action
| Keys
|
|---|
|
Selecting the entire sheet.
|
CTRL+A or CTRL+SHIFT+SPACEBAR
|
|
Selecting the current and next sheets of the workbook.
|
CTRL+SHIFT+PAGE DOWN
|
|
Selecting the current and previous sheets of the book.
|
CTRL+SHIFT+PAGE UP
|
|
Extends the selected cell range by one cell.
|
SHIFT+arrow key
|
|
Extends the selected range of cells to the last non-blank cell in the same row or column as the active cell, or, if the next cell is empty, to the next non-blank cell.
|
CTRL+SHIFT+arrow key
|
|
Enable selection mode and expand the selection using the arrow keys. To turn off the mode, press the combination again.
|
|
|
Add non-adjacent cells or range to a selection using the arrow keys.
|
|
|
Move to a new line in a cell.
|
|
|
Fills the selected range of cells with the current value.
|
|
|
Complete the entry in the current cell and move to the cell above.
|
|
|
Selects an entire column in a worksheet.
|
CTRL+SPACEBAR
|
|
Selects an entire row on a sheet.
|
SHIFT+SPACEBAR
|
|
If an object is selected, selects all objects on the sheet.
|
CTRL+SHIFT+SPACEBAR
|
|
Extends the selected range of cells to the beginning of the sheet.
|
|
|
Selects the current area if the sheet contains data. Press the combination again to highlight the current area and its total rows. Press the combination a third time to select the entire sheet.
|
CTRL+A or CTRL+SHIFT+SPACEBAR
|
|
Select the current area around the active cell or select the entire PivotTable report.
|
CTRL+SHIFT+asterisk (*)
|
|
If a menu or submenu is displayed on the screen, select the first command in it.
|
|
|
|
|
|
Undo the last action.
|
Keyboard shortcuts for working with data, functions, and the formula bar
Action
| Keys
|
|---|
|
Selects the entire PivotTable report.
|
CTRL+SHIFT+asterisk (*)
|
|
Change the active cell and place the insertion point at the end of the content. If editing is disabled for a cell, the insertion point is placed in the formula bar. When editing a formula, you can turn hint mode on or off so you can use the arrow keys to create a reference.
|
|
|
Expand or collapse the formula bar.
|
|
|
|
|
|
Complete your entry in the formula bar and move to the cell below.
|
|
|
Moves the cursor to the end of text in the formula bar.
|
|
|
Selects all text in the formula bar from the cursor position to the end.
|
|
|
Recounts all sheets in all open workbooks.
|
|
|
Recalculation of the active sheet.
|
|
|
Recalculation of all sheets in all open workbooks, regardless of whether changes have been made to them since the last recalculation.
|
|
|
Checks dependent formulas and then recalculates all cells in all open workbooks, including cells not marked for calculation.
|
CTRL+ALT+SHIFT+F9
|
|
Displays a menu or message for the "Finding Errors" button.
|
|
|
When the cursor is to the right of a function name in a formula, the Function Arguments dialog box appears.
|
|
|
When the cursor is to the right of a function name in a formula, inserts the argument names and parentheses.
|
|
Function keys
|
|
Description
|
|---|
|
|
F1 separately: display task area Excel Help.
CTRL+F1: Show or hide the ribbon.
ALT+F1: Create an inline chart based on data from the current area.
ALT+SHIFT+F1: Add a new sheet to the workbook.
|
|
|
F2 alone: Change the active cell and place the cursor at the end of the content. If editing is disabled for a cell, the cursor is placed in the formula bar. When editing a formula, you can turn hint mode on or off so you can use the arrow keys to create a reference.
SHIFT+F2: Add or change a comment to a cell.
CTRL+F2: Show preview area on tab Seal in Backstage View.
|
|
|
F3 alone: display dialog box Inserting a name. Available only if names are defined in the workbook.
SHIFT+F3: Display dialog box Inserting a function.
|
|
|
F4 alone: repeat the last command or action, if possible.
CTRL+F4:
ALT+F4: Close Excel.
|
|
|
F5 alone: display dialog box Transition.
CTRL+F5: Resize the selected book window.
|
|
|
F6 alone: Switch between sheet, ribbon, task pane, and zoom controls. If the worksheet is split, when you switch between a ribbon area and other areas using the F6 key, the split areas are also included in the switching.
SHIFT+F6: Switch between worksheet, zoom controls, task pane, and ribbon.
CTRL+F6: goes to the next book window if several books are open.
|
|
|
F7 separately: opens a dialog box Spelling to check spelling on the active worksheet or in the selected range.
CTRL+F7: execute command Move in the maximized book window. Use the cursor keys to move the window and press ENTER or ESC to cancel.
|
|
|
F8 alone: Toggle selection expansion mode on and off. When highlight mode is enabled, the status bar displays Expandable selection
SHIFT+F8: Use the arrow keys to add non-adjacent cells or a range to the selection.
CTRL+F8: resizes the book window if it is not maximized.
ALT+F8: Displays the Macro dialog box, allowing you to create, run, edit, and delete macros.
|
|
|
F9 separately: recalculation of all sheets of all open books.
SHIFT+F9: Recalculate the active sheet.
CTRL+ALT+F9: Recalculates all sheets of all open workbooks, regardless of whether changes have been made to them since the last calculation.
CTRL+ALT+SHIFT+F9: Tests dependent formulas and then recalculates all cells in all open workbooks, including cells not marked for calculation.
CTRL+F9: minimize the book window to an icon.
|
|
|
F10 separately: enable or disable tooltips. (The same action is performed with the ALT key.)
SHIFT+F10: Displays the context menu for the selected item.
ALT+SHIFT+F10: Displays a menu or message for the Find Errors button.
CTRL+F10: Maximizes or restores the selected workbook window to its original size.
|
|
|
F11 separately:
SHIFT+F11: inserts a new sheet into the workbook.
ALT+F11: Opens the Microsoft Visual Basic for Applications editor, where you can create a macro in Visual Basic for Applications (VBA).
|
|
|
|
Key
| Description
|
|---|
|
|
For example:
|
|
Arrow keys
|
With the ribbon highlighted, the LEFT ARROW and RIGHT ARROW keys allow you to select a tab on the left or right. When a submenu is selected or open, these arrow keys help you navigate from the main menu to the submenu and back. When a ribbon tab is selected, these keys help you navigate through the tabs.
When a menu or submenu is open, the DOWN ARROW and UP ARROW keys move to the previous or next command. When a ribbon tab is selected, these keys move up or down tab groups.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cancel input in a cell or formula bar.
Additionally, pressing this key closes full screen mode, if it has been applied, and returns you to normal mode, which displays the ribbon and status bar.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Excel 2013
Advice:
Note: recording a macro.
If you're just getting started with the Ribbon, this section will teach you how to use keyboard shortcuts to work with it. There are new combinations available on the ribbon called key hints, which are displayed when you press the ALT key.
To display a tab on the ribbon, press its corresponding key. For example, to open the Insert tab, press N; to open the Formulas tab, press M. KeyTip indicators appear for all buttons on the ribbon, as shown in the image below. You just need to press the desired key.
Can I use keyboard shortcuts from previous versions?
Shortcuts using the CTRL key will still work in Microsoft Excel 2013. For example, you can use CTRL+C to copy to the clipboard and CTRL+V to paste from the clipboard.
Keyboard shortcuts using the CTRL key
Key
| Description
|
|---|
|
|
|
|
|
|
|
|
Inserts outer borders into selected cells.
|
|
|
Removes outer borders from selected cells.
|
|
|
Applying a common number format.
|
|
|
Use a currency format with two decimal places (negative numbers appear in parentheses).
|
|
|
Using percentage format without fractions.
|
|
|
Use exponential number format with two decimal places.
|
|
|
Apply a date format indicating the day, month, and year.
|
|
|
Use of a time format with hours and minutes display and AM or PM indexes.
|
|
|
Use a number format with two decimal places, a place separator, and a minus sign (-) for negative values.
|
|
|
|
|
|
Insert current time.
|
|
|
|
|
CTRL+SHIFT+plus sign (+)
|
Displaying a Dialog Box Adding cells to insert empty cells.
|
|
CTRL+minus sign (-)
|
Displaying a Dialog Box Removing cells to delete selected cells.
|
|
|
Insert the current date.
|
|
|
Switch between displaying cell values and formulas in the worksheet.
|
|
|
|
|
|
Displaying a Dialog Box Cell Format.
|
|
|
Apply or remove bold style.
|
|
|
Apply or remove italics.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Hiding selected rows.
|
|
|
Hiding selected columns.
|
|
|
Selecting the entire sheet.
If the worksheet contains data, CTRL+A selects the current area. Pressing CTRL+A again will select the entire sheet.
Function Arguments.
|
|
|
Apply or remove bold style.
|
|
|
Copy selected cells.
|
|
|
Using the command Fill Down
|
|
|
Function keys
Key
| Description
|
|---|
|
|
Displaying the task pane Excel Help.
The ALT+F1 shortcut creates an inline chart based on data from the current area.
|
|
|
The SHIFT+F2 shortcut adds or changes comments to a cell.
Seal in Backstage View.
|
|
|
Displaying a Dialog Box Inserting a name. Available only if names are defined in the workbook (tab Formulas, group Specific names, Assign a name).
Inserting a function.
|
|
|
Repeat the last command or action, if possible.
|
|
|
Displaying a Dialog Box Transition.
|
|
|
View, Managing this window, To fix areas, team Split window
|
|
|
Displaying a Dialog Box Spelling
Move. Use the cursor keys to move the window and press ENTER or ESC to cancel.
|
|
|
Expandable selection, and the arrow keys expand the selection area.
The SHIFT+F8 keyboard shortcut allows you to use the arrow keys to add non-adjacent cells or a range to a selection.
Size(on the menu Control element
Macro
|
|
|
The keyboard shortcut CTRL+ALT+F9 calculates all sheets of all open workbooks, regardless of whether changes have been made to them since the last calculation.
|
|
|
The keyboard shortcut ALT+SHIFT+F10 displays a menu or message for the Find Errors button.
The CTRL+F10 keyboard shortcut maximizes or restores the selected workbook window to its original size.
|
|
|
Create a chart of the data in the current range on a separate chart sheet.
|
|
|
|
Other useful keyboard shortcuts
Key
| Description
|
|---|
|
|
For example:
The ALT, O, Z keys enable page layout mode on the sheet.
The ALT, O, Y keys enable normal mode on the sheet.
The ALT, W, I keys enable page mode on the sheet.
|
|
Arrow keys
|
Move the sheet one cell up, down, left or right.
The CTRL+arrow key combination moves to the border of the current worksheet data area.
SHIFT+arrow key expands the selection by one cell.
CTRL+SHIFT+arrow key expands the selection of cells to the last non-blank cell in the same row or column as the active cell, or, if the next cell is empty, to the next non-blank cell.
With the ribbon highlighted, the LEFT ARROW and RIGHT ARROW keys allow you to select a tab on the left or right. When a submenu is selected or open, these arrow keys allow you to move from the main menu to the submenu and back. When a ribbon tab is selected, these keys allow you to navigate through the tabs.
When a menu or submenu is open, the DOWN ARROW and UP ARROW keys move to the previous or next command. When a ribbon tab is selected, these keys allow you to move up and down groups of tabs.
In a dialog box, the arrow keys move to the next or previous option in the selected drop-down list or group of options.
The DOWN ARROW key or ALT+DOWN ARROW opens the selected drop-down list.
|
|
|
Removes one character from the left in the formula bar.
Also deletes the contents of the active cell.
In cell editing mode, deletes the character to the left of the insertion location.
|
|
|
Deletes cell content (data and formulas) in the selected cell without affecting cell formatting or comments.
In cell editing mode, deletes the character to the right of the cursor.
|
|
|
Enables or disables Jump to End mode. In this mode, you can use the arrow keys to move to the next non-blank cell in the same row or column as the active cell. Skip to end mode turns off automatically when you press an arrow key. You must press the END key again before pressing the next arrow key. When this mode is enabled, it appears in the status bar.
If the cells are empty, pressing the END key and the arrow keys in succession moves to the last cell in the row or column.
Additionally, if a menu or submenu is displayed on the screen, pressing the END key selects the last command from the menu.
The CTRL+END keyboard shortcut moves to the last cell on the worksheet, located in the bottom-most usable row of the rightmost usable column. If the cursor is in the formula bar, the CTRL+END key combination moves it to the end of the text.
The keyboard shortcut CTRL+SHIFT+END expands the selected cell range to the last used worksheet cell (lower right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end of the line (this does not affect the height of the formula bar).
|
|
|
Finish entering a value in a cell in the formula bar and select the cell below (default).
The data entry form moves to the first field of the next record.
Open the selected menu (press F10 to activate the menu bar) or execute the selected command.
The dialog box performs the action assigned to the default button selected in the dialog box (this button is highlighted with a thick border, often the button OK).
ALT+ENTER starts a new line in the current cell.
The CTRL+ENTER key combination fills the selected cells with the current value.
SHIFT+ENTER ends the entry in a cell and moves the insertion point to the cell above.
|
|
|
Cancel input in a cell or formula bar.
Closes a menu or submenu, dialog box, or message box.
|
|
|
Move to the beginning of a line or sheet.
When SCROLL LOCK mode is turned on, you move to the cell in the upper left corner of the window.
Additionally, if a menu or submenu is displayed on the screen, the first command from the menu is selected.
The CTRL+HOME key combination moves to the cell at the beginning of the sheet.
The CTRL+SHIFT+HOME key combination expands the selected range of cells to the beginning of the sheet.
|
|
|
Moves one screen down the sheet.
The ALT+PAGE DOWN key combination moves one screen to the right on the sheet.
The CTRL+PAGE DOWN key combination moves to the next sheet of the book.
The CTRL+SHIFT+PAGE DOWN key combination selects the current and next sheets of the workbook.
|
|
|
Moves up one screen on the sheet.
The ALT+PAGE UP key combination moves one screen to the left on the sheet.
The CTRL+PAGE UP key combination moves to the previous sheet of the book.
The key combination CTRL+SHIFT+PAGE UP leads to the selection of the current and previous sheets of the workbook.
|
|
|
In a dialog box, click the selected button or select and clear a check box.
The keyboard shortcut CTRL+SPACEBAR selects a worksheet column.
The SHIFT+SPACE key combination selects the entire row of the worksheet.
The keyboard shortcut CTRL+SHIFT+SPACEBAR selects the entire sheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current area. Pressing CTRL+SHIFT+SPACEBAR again selects the current area and its resulting rows. The third time you press CTRL+SHIFT+SPACEBAR, the entire sheet is selected.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all sheet objects.
ALT+SPACEBAR displays menu Control element Excel windows.
|
|
|
Move one cell to the right.
Jump between unprotected cells in a protected worksheet.
Moves to the next option or group of options in the dialog box.
SHIFT+TAB moves to the previous worksheet cell or previous option in a dialog box.
The CTRL+TAB key combination moves to the next tab of the dialog box.
The keyboard shortcut CTRL+SHIFT+TAB navigates to the previous tab of the dialog box.
|
This article describes common keyboard shortcuts and function keys for Excel 2010. These include shortcuts that you can use to access the feed.
Note: If you are using Microsoft Excel Starter 2010, be aware that not all features available in Excel are supported in Excel Starter 2010.
Advice: To ensure that help information is always available while working with the program, you can print this section. To print this article, press CTRL+P.
Note: If a frequently used action doesn't have a keyboard shortcut, you can create one by recording a macro.
Can I use keyboard shortcuts from previous versions?
CTRL Keyboard Shortcuts
Function keys
Other useful keyboard shortcuts
Keyboard shortcuts to access the ribbon
If you're just getting started with the Ribbon, this section will teach you how to use keyboard shortcuts to work with it. There are new combinations available on the ribbon called key hints, which are displayed when you press the ALT key.
To display a tab on the ribbon, press its corresponding key. For example, to open the Insert tab, press C; to open the Formulas tab, press L. KeyTip indicators appear for all buttons on the ribbon, so you just press the key you want.
Can I use keyboard shortcuts from previous versions?
Shortcuts using the CTRL key will still work in Excel 2010. For example, you can use CTRL+C to copy to the clipboard and CTRL+V to paste from it.
Also, most of the ALT key combinations from previous versions of the program still work. However, you need to know these keyboard shortcuts by heart, since you won't find any on-screen reminders of the letters you need to press. For example, try pressing the ALT key and one of the old menu keys: E (Review), V (View), I (Insert), etc. A message box will appear telling you that you are using the access key from a previous version of Microsoft Office. If you know the full key sequence, feel free to use the command. If you don't remember the sequence, press the ESC key instead and follow the key hint indicators.
CTRL Keyboard Shortcuts
Key
| Description
|
|---|
|
|
Switch between worksheet tabs from left to right.
|
|
|
Switch between worksheet tabs from right to left.
|
|
|
|
|
|
Inserts outer borders into selected cells.
|
|
|
Removes outer borders from selected cells.
|
|
|
Applying a common number format.
|
|
|
Use a currency format with two decimal places (negative numbers appear in parentheses).
|
|
|
Using percentage format without fractions.
|
|
|
Use exponential number format with two decimal places.
|
|
|
Apply a date format indicating the day, month, and year.
|
|
|
Use of a time format with hours and minutes display and AM or PM indexes.
|
|
|
Use a number format with two decimal places, a place separator, and a minus sign (-) for negative values.
|
|
|
Selects the current area around the active cell (the area of data limited by empty rows and empty columns).
A PivotTable highlights the entire PivotTable report.
|
|
|
Insert current time.
|
|
|
Copies the contents of the top cell to the current cell or formula bar.
|
|
CTRL+SHIFT+plus sign (+)
|
Displaying a Dialog Box Adding cells to insert empty cells.
|
|
CTRL+minus sign (-)
|
Displaying a Dialog Box Removing cells to delete selected cells.
|
|
|
Insert the current date.
|
|
|
Switch between displaying cell values and formulas in the worksheet.
|
|
|
Copies the formula in the top cell to the current cell or formula bar.
|
|
|
Displaying a Dialog Box Cell Format.
|
|
|
Apply or remove bold style.
|
|
|
Apply or remove italics.
|
|
|
Apply or remove underlining.
|
|
|
Strikethrough text or remove strikethrough.
|
|
|
Switch between showing and hiding objects.
|
|
|
Show or hide structure signs.
|
|
|
Hiding selected rows.
|
|
|
Hiding selected columns.
|
|
|
Selecting the entire sheet.
If the worksheet contains data, CTRL+A selects the current area. Pressing CTRL+A again will select the entire table.
If the cursor is located to the right of a function name in a formula, a dialog box appears Function Arguments.
If the cursor is positioned to the right of a function name in a formula, CTRL+SHIFT+A inserts argument names and parentheses.
|
|
|
Apply or remove bold style.
|
|
|
Copy selected cells.
|
|
|
Using the command Fill Down to copy the contents and format of the top cell of the selection range to all cells below.
|
|
|
Displaying a Dialog Box Find and Replace with tab selected Find.
Find.
Cell Format with tab selected Font.
|
|
|
Displaying a Dialog Box Transition.
|
|
|
Displaying a Dialog Box Find and Replace with tab selected Replace.
|
|
|
Apply or remove italics.
|
|
|
Displaying a Dialog Box Inserting a hyperlink for new hyperlinks or Changing a hyperlink
|
|
|
Displaying a Dialog Box Creating a table.
|
|
|
Create a new empty workbook.
|
|
|
Displaying a Dialog Box Opening a document
|
|
|
Display a tab Seal in Microsoft Office Backstage View.
Cell Format with tab selected Font.
|
|
|
Using the command Fill Right
|
|
|
|
|
|
Displaying a Dialog Box Creating a table.
|
|
|
Apply or remove underlining.
|
|
|
Special insert
|
|
|
Closes the selected workbook window.
|
|
|
|
|
|
Repeat the last command or action, if possible.
|
|
|
Using the command Cancel
|
Advice: The keyboard shortcuts CTRL+E, CTRL+J, CTRL+M, and CTRL+Q do not currently have any actions assigned to them.
Function keys
Key
| Description
|
|---|
|
|
Displaying the task pane Excel Help.
The keyboard shortcut CTRL+F1 shows or hides the ribbon.
The ALT+F1 shortcut creates an inline chart based on the data in the current range.
The keyboard shortcut ALT+SHIFT+F1 adds a new sheet to the workbook.
|
|
|
Changes the active cell and places the cursor at the end of its contents. Pressing this key also moves the cursor to the formula bar if the cell's edit mode is turned off.
The keyboard shortcut CTRL+F2 displays the preview area on the tab Seal in Backstage View.
|
|
|
Displays a dialog box Inserting a name. Only available if there are names in the book.
The SHIFT+F3 key combination displays a dialog box Inserting a function.
|
|
|
Repeat the last command or action, if possible.
The CTRL+F4 key combination closes the window of the selected book.
The ALT+F4 keyboard shortcut closes Excel.
|
|
|
Displaying a Dialog Box Transition.
The CTRL+F5 key combination restores the size of the selected workbook window.
|
|
|
Switch the insertion point between the sheet, ribbon, task pane, and zoom controls. In sheets that have been divided (menu View, Managing this window, To fix areas, team Split window), when you switch between a ribbon area and other areas using the F6 key, the divided areas also participate in the switching.
SHIFT+F6 switches the insertion point between the worksheet, zoom controls, task pane, and ribbon.
If multiple workbooks are open, the CTRL+F6 key combination switches the insertion point to the next workbook window.
|
|
|
Displaying a Dialog Box Spelling to check spelling in the active worksheet or selected range.
If the workbook window is not maximized, the keyboard shortcut CTRL+F7 executes the command Move
|
|
|
Entering and exiting selection mode. When highlight mode is enabled, the status bar displays Expandable selection, and the arrow keys expand the selection area.
The keyboard shortcut CTRL+F8 executes the command Size(on the menu Control element book window) if the window is not maximized.
The ALT+F8 key combination displays a dialog box Macro, which allows you to create, run, edit, and delete macros.
|
|
|
Calculate all sheets of all open workbooks.
The SHIFT+F9 keyboard shortcut calculates the active sheet.
The keyboard shortcut CTRL+ALT+SHIFT+F9 checks dependent formulas and then recalculates cells in all open workbooks, including cells not marked for calculation.
The CTRL+F9 key combination minimizes the book window to an icon.
|
|
|
Turn key hints on or off. (The same action is performed with the ALT key.)
The SHIFT+F10 keyboard shortcut displays a context menu for the selected item.
The keyboard shortcut ALT+SHIFT+F10 displays a menu or message for the Find Errors button.
|
|
|
Create a chart of the data in the current range on a separate chart sheet.
The SHIFT+F11 key combination inserts a new sheet into the workbook.
The ALT+F11 keyboard shortcut opens the Microsoft Visual Basic for Applications editor, where you can create a macro in Visual Basic for Applications (VBA).
|
|
|
|
Other useful keyboard shortcuts
Key
| Description
|
|---|
|
|
Displays KeyTips (new keyboard shortcuts) on the Ribbon.
For example:
The ALT, O, Z keys enable page layout mode on the sheet.
The ALT, O, Y keys enable normal mode.
The ALT, O, T, 1 keys enable page mode on the sheet.
|
|
ARROW KEYS
|
Move the sheet one cell up, down, left or right.
The CTRL+arrow key combination moves to the border of the current worksheet data area.
SHIFT+arrow key expands the selection by one cell.
CTRL+SHIFT+arrow key expands the selection of cells to the last non-blank cell in the same row or column as the active cell, or, if the next cell is empty, to the next non-blank cell.
In a dialog box, the arrow keys move to the next or previous option in the selected drop-down list or group of options.
The DOWN ARROW key or ALT+DOWN ARROW opens the selected drop-down list.
|
|
|
Removes one character from the left in the formula bar.
Also deletes the contents of the active cell.
In cell editing mode, deletes the character to the left of the insertion location.
|
|
|
Deletes cell content (data and formulas) in the selected cell without affecting cell formatting or comments.
In cell editing mode, deletes the character to the right of the cursor.
|
|
|
The transition to end mode is activated. In this mode, you can move to the next non-blank cell in a column or row using the arrow keys. If the cells are empty, pressing the END key and the arrow keys in succession moves to the last cell in the row or column.
Additionally, if a menu or submenu is displayed on the screen, pressing the END key selects the last command from the menu.
The keyboard shortcut CTRL+SHIFT+END expands the selected cell range to the last used worksheet cell (lower right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end of the line (this does not affect the height of the formula bar).
|
|
|
Finish entering a value in a cell in the formula bar and select the cell below (default).
The data entry form moves to the first field of the next record.
Open the selected menu (press F10 to activate the menu bar) or execute the selected command.
The dialog box performs the action assigned to the default button selected in the dialog box (this button is highlighted with a thick border, often the button OK).
ALT+ENTER starts a new line in the current cell.
The CTRL+ENTER key combination fills the selected cells with the current value.
SHIFT+ENTER ends the entry in a cell and moves the insertion point to the cell above.
|
|
|
Cancel input in a cell or formula bar.
Closes a menu or submenu, dialog box, or message box.
Additionally, pressing this key closes full screen mode (if it was active) and restores normal mode, which displays the ribbon and status bar.
|
|
|
Move to the beginning of a line or sheet.
When SCROLL LOCK mode is turned on, you move to the cell in the upper left corner of the window.
Additionally, if a menu or submenu is displayed on the screen, the first command from the menu is selected.
The CTRL+HOME key combination moves to the cell at the beginning of the sheet.
The CTRL+SHIFT+HOME key combination expands the selected range of cells to the beginning of the sheet.
|
|
|
Moves one screen down the sheet.
The ALT+PAGE DOWN key combination moves one screen to the right on the sheet.
The CTRL+PAGE DOWN key combination moves to the next sheet of the book.
The CTRL+SHIFT+PAGE DOWN key combination selects the current and next sheets of the workbook.
|
|
|
Moves up one screen on the sheet.
The ALT+PAGE UP key combination moves one screen to the left on the sheet.
The CTRL+PAGE UP key combination moves to the previous sheet of the book.
The key combination CTRL+SHIFT+PAGE UP leads to the selection of the current and previous sheets of the workbook.
|
|
|
In a dialog box, click the selected button or select and clear a check box.
The keyboard shortcut CTRL+SPACEBAR selects a worksheet column.
The keyboard shortcut CTRL+SHIFT+SPACEBAR selects the entire sheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current area. Pressing CTRL+SHIFT+SPACEBAR again selects the current area and its resulting rows. The third time you press CTRL+SHIFT+SPACEBAR, the entire sheet is selected.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all sheet objects.
ALT+SPACEBAR displays menu Control element Excel windows.
|
|
|
Move one cell to the right.
Jump between unprotected cells in a protected worksheet.
Moves to the next option or group of options in the dialog box.
SHIFT+TAB moves to the previous worksheet cell or previous option in a dialog box.
The CTRL+TAB key combination moves to the next tab of the dialog box.
The keyboard shortcut CTRL+SHIFT+TAB navigates to the previous tab of the dialog box.
|
This article describes common keyboard shortcuts and function keys for Excel 2007. These include shortcuts that you can use to access the feed.
Advice: To ensure that help information is always available while working with the program, you can print this section. To print this article, press CTRL+P.
Note: If a frequently used action doesn't have a keyboard shortcut, you can create one by recording a macro.
CTRL Keyboard Shortcuts
Key
| Description
|
|---|
|
|
Switch between worksheet tabs from left to right.
|
|
|
Switch between worksheet tabs from right to left.
|
|
|
Show hidden rows in the selected area.
|
|
|
Show hidden columns in the selection area.
|
|
|
Inserts outer borders into selected cells.
|
|
|
Removes outer borders from selected cells.
|
|
|
Applying a common number format.
|
|
|
Use a currency format with two decimal places (negative numbers appear in parentheses).
|
|
|
Using percentage format without fractions.
|
|
|
Use exponential number format with two decimal places.
|
|
|
Apply a date format indicating the day, month, and year.
|
|
|
Use of a time format with hours and minutes display and AM or PM indexes.
|
|
|
Use a number format with two decimal places, a place separator, and a minus sign (-) for negative values.
|
|
|
Selects the current area around the active cell (the area of data limited by empty rows and empty columns).
A PivotTable highlights the entire PivotTable report.
|
|
|
Insert current time.
|
|
|
Copies the contents of the top cell to the current cell or formula bar.
|
|
CTRL+SHIFT+plus sign (+)
|
Displaying a Dialog Box Adding cells to insert empty cells.
|
|
CTRL+minus sign (-)
|
Displaying a Dialog Box Removing cells to delete selected cells.
|
|
|
Insert the current date.
|
|
|
Switch between displaying cell values and formulas in the worksheet.
|
|
|
Copies the formula in the top cell to the current cell or formula bar.
|
|
|
Displaying a Dialog Box Cell Format.
|
|
|
Apply or remove bold style.
|
|
|
Apply or remove italics.
|
|
|
Apply or remove underlining.
|
|
|
Strikethrough text or remove strikethrough.
|
|
|
Switch between hiding objects, showing objects, and showing object placeholders.
|
|
|
|
Show or hide structure signs.
|
|
|
Hiding selected rows.
|
|
|
Hiding selected columns.
|
|
|
Selecting the entire sheet.
If the worksheet contains data, CTRL+A selects the current area. Pressing CTRL+A again selects the current area and its resulting rows. The third time you press CTRL+A, the entire sheet is selected.
If the cursor is located to the right of a function name in a formula, a dialog box appears Function Arguments.
If the cursor is positioned to the right of a function name in a formula, CTRL+SHIFT+A inserts argument names and parentheses.
|
|
|
Apply or remove bold style.
|
|
|
Copy selected cells.
Pressing CTRL+C again displays the clipboard.
|
|
|
Using the command Fill Down to copy the contents and format of the top cell of the selection range to all cells below.
|
|
|
Displaying a Dialog Box Find and Replace with tab selected Find.
SHIFT+F5 also displays this tab, and SHIFT+F4 repeats the last action on the tab Find.
The keyboard shortcut CTRL+SHIFT+F displays a dialog box Cell Format with tab selected Font.
|
|
|
Displaying a Dialog Box Transition.
The F5 key also displays this dialog box.
|
|
|
Displaying a Dialog Box Find and Replace with tab selected Replace.
|
|
|
Apply or remove italics.
|
|
|
Displaying a Dialog Box Inserting a hyperlink for new hyperlinks or Changing a hyperlink for an existing selected hyperlink.
|
|
|
Create a new empty workbook.
|
|
|
Displaying a Dialog Box Opening a document to open or search for a file.
The keyboard shortcut CTRL+SHIFT+O selects all cells containing notes.
|
|
|
Dialog box output Seal.
The keyboard shortcut CTRL+SHIFT+P displays a dialog box Cell Format with tab selected Font.
|
|
|
Using the command Fill Right to copy the contents and format of the leftmost cell of the selected range to all cells to the right.
|
|
|
Saves the active file with the current name in the current location and in the existing format.
|
|
|
Displaying a Dialog Box Creating a table.
|
|
|
Apply or remove underlining.
The keyboard shortcut CTRL+SHIFT+U expands and collapses the formula bar.
|
|
|
Pastes the contents of the clipboard at the insertion point and replaces the selection. Functions only if there is an object, text, or cell content on the clipboard.
Pressing CTRL+ALT+V opens a dialog box Special insert. It is available only after you have copied or cut an object, text, or cell content in a worksheet or another program.
|
|
|
Closes the selected workbook window.
|
|
|
Delete the contents of selected cells.
|
|
|
Repeat the last command or action, if possible.
|
|
|
Using the command Cancel to cancel the last command or delete the last entered entry.
The keyboard shortcut CTRL+SHIFT+Z calls the command Cancel or Return to undo or restore the last AutoCorrect operation when AutoCorrect smart tags are displayed.
|
Function keys
Key
| Description
|
|---|
|
|
Displaying the task pane Microsoft Office Excel Help.
The CTRL+F1 keyboard shortcut shows or hides the Ribbon (a Microsoft Office Fluent user interface component).
The ALT+F1 shortcut creates a chart based on the data in the current range.
The keyboard shortcut ALT+SHIFT+F1 adds a new sheet to the workbook.
|
|
|
Changes the active cell and places the cursor at the end of its contents. Pressing this key also moves the cursor to the formula bar if the cell's edit mode is turned off.
SHIFT+F2 adds or changes a cell note.
The keyboard shortcut CTRL+F2 displays the preview window.
|
|
|
Dialog box output Inserting a name.
The SHIFT+F3 key combination displays a dialog box Inserting a function.
|
|
|
Repeat the last command or action, if possible.
The CTRL+F4 key combination closes the window of the selected book.
|
|
|
Displaying a Dialog Box Transition.
The CTRL+F5 key combination restores the size of the selected workbook window.
|
|
|
Switch the insertion point between the sheet, ribbon, task pane, and zoom controls. In sheets that have been divided (menu View, Managing this window, To fix areas, team Split window), when you switch between a ribbon area and other areas using the F6 key, the divided areas also participate in the switching.
SHIFT+F6 switches the insertion point between the worksheet, zoom controls, task pane, and ribbon.
If multiple workbooks are open, the CTRL+F6 key combination switches the insertion point to the next workbook window.
|
|
|
Displaying a Dialog Box Spelling to check spelling in the active worksheet or selected range.
If the workbook window is not maximized, the keyboard shortcut CTRL+F7 executes the command Move. Move the window using the arrow keys. When finished, press ENTER or press ESC to cancel.
|
|
|
Entering and exiting selection mode. When highlight mode is enabled, the status bar displays Expandable selection, and the arrow keys expand the selection area.
SHIFT+F8 lets you use the arrow keys to add nonadjacent cells or a range to a selection.
The keyboard shortcut CTRL+F8 executes the command Size(on the menu Control element book window) if the window is not maximized.
The ALT+F8 key combination displays a dialog box Macro, which allows you to create, run, edit, and delete macros.
|
|
|
Calculate all sheets of all open workbooks.
The SHIFT+F9 keyboard shortcut calculates the active sheet.
The keyboard shortcut CTRL+ALT+F9 calculates all sheets of all open workbooks, regardless of whether changes have been made to them since the last calculation.
The keyboard shortcut CTRL+ALT+SHIFT+F9 checks dependent formulas and then recalculates cells in all open workbooks, including cells not marked for calculation.
The CTRL+F9 key combination minimizes the book window to an icon.
|
|
|
Turn key hints on or off.
The SHIFT+F10 keyboard shortcut displays a context menu for the selected item.
ALT+SHIFT+F10 displays a menu or message for a smart tag. If there are multiple smart tags, moves to the next smart tag and displays its corresponding menu or message.
The CTRL+F10 keyboard shortcut maximizes the selected workbook window or restores it to its original size.
|
|
|
Create a chart based on data from the current range.
The SHIFT+F11 key combination inserts a new sheet into the workbook.
The ALT+F11 keyboard shortcut opens the Microsoft Visual Basic editor, where you can create a macro in Visual Basic for Applications (VBA).
|
|
|
|
Other useful keyboard shortcuts
Key
| Description
|
|---|
|
ARROW KEYS
|
Move the sheet one cell up, down, left or right.
The CTRL+arrow key combination moves to the border of the current worksheet data area.
SHIFT+arrow key expands the selection by one cell.
CTRL+SHIFT+arrow key expands the selection of cells to the last non-blank cell in the same row or column as the active cell, or, if the next cell is empty, to the next non-blank cell.
When the ribbon is highlighted, the LEFT ARROW or RIGHT ARROW keys help you select a tab on the left or right. When a submenu is selected or open, these arrow keys help you navigate from the main menu to the submenu and back. When a ribbon tab is selected, these keys help you navigate through the tab buttons.
When a menu or submenu is open, the DOWN ARROW or UP ARROW keys help you navigate to the previous or next command. When a ribbon tab is selected, these keys help you move up or down the tab groups.
In a dialog box, the arrow keys move to the next or previous option in the selected drop-down list or group of options.
The DOWN ARROW key or ALT+DOWN ARROW opens the selected drop-down list.
|
|
|
Removes one character from the left in the formula bar.
Also deletes the contents of the active cell.
In cell editing mode, deletes the character to the left of the insertion location.
|
|
|
Deletes cell content (data and formulas) in the selected cell without affecting cell formatting or comments.
In cell editing mode, deletes the character to the right of the cursor.
|
|
|
In SCROLL LOCK mode, you move to the cell in the lower right corner of the window.
Additionally, if a menu or submenu is displayed on the screen, pressing this key also selects the last command in that menu.
The CTRL+END keyboard shortcut moves to the last cell on the worksheet, located in the bottom-most usable row of the rightmost usable column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text.
The keyboard shortcut CTRL+SHIFT+END expands the selected cell range to the last used worksheet cell (lower right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end of the line (this does not affect the height of the formula bar).
|
|
|
Finish entering a value in a cell in the formula bar and select the cell below (default).
The data entry form moves to the first field of the next record.
Open the selected menu (press F10 to activate the menu bar) or execute the selected command.
The dialog box performs the action assigned to the default button selected in the dialog box (this button is highlighted with a thick border, often the button OK).
ALT+ENTER starts a new line in the current cell.
The CTRL+ENTER key combination fills the selected cells with the current value.
SHIFT+ENTER ends the entry in a cell and moves the insertion point to the cell above.
|
|
|
Cancel input in a cell or formula bar.
Closes a menu or submenu, dialog box, or message box.
Additionally, pressing this key closes full screen mode (if it was active) and restores normal mode, which displays the ribbon and status bar.
|
|
|
Move to the beginning of a line or sheet.
When SCROLL LOCK mode is turned on, you move to the cell in the upper left corner of the window.
Additionally, if a menu or submenu is displayed on the screen, the first command from the menu is selected.
The CTRL+HOME key combination moves to the cell at the beginning of the sheet.
The CTRL+SHIFT+HOME key combination expands the selected range of cells to the beginning of the sheet.
|
|
|
Moves one screen down the sheet.
The ALT+PAGE DOWN key combination moves one screen to the right on the sheet.
The CTRL+PAGE DOWN key combination moves to the next sheet of the book.
The CTRL+SHIFT+PAGE DOWN key combination selects the current and next sheets of the workbook.
|
|
|
Moves up one screen on the sheet.
The ALT+PAGE UP key combination moves one screen to the left on the sheet.
The CTRL+PAGE UP key combination moves to the previous sheet of the book.
The key combination CTRL+SHIFT+PAGE UP leads to the selection of the current and previous sheets of the workbook.
|
|
|
In a dialog box, click the selected button or select and clear a check box.
The keyboard shortcut CTRL+SPACEBAR selects a worksheet column.
The SHIFT+SPACE key combination selects a row in the worksheet.
The keyboard shortcut CTRL+SHIFT+SPACEBAR selects the entire sheet.
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current area. Pressing CTRL+SHIFT+SPACEBAR again selects the current area and its resulting rows. The third time you press CTRL+SHIFT+SPACEBAR, the entire sheet is selected.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all sheet objects.
ALT+SPACEBAR displays menu Control element Microsoft Office Excel windows.
|
|
|
Move one cell to the right.
Jump between unprotected cells in a protected worksheet.
Moves to the next option or group of options in the dialog box.
SHIFT+TAB moves to the previous worksheet cell or previous option in a dialog box.
The CTRL+TAB key combination moves to the next tab of the dialog box.
The keyboard shortcut CTRL+SHIFT+TAB navigates to the previous tab of the dialog box.
|
additional information
You can always ask a question in the Excel Tech Community, ask for help in the Answers community, or suggest a new feature or improvement on the Excel User Voice website. Microsoft is committed to ensuring that all of our customers receive the best products and service possible. If you have a disability or have questions about accessibility issues, contact the Microsoft Disability Answer Desk for technical support. Microsoft Disability Answer Desk experts are familiar with many popular accessibility features and can provide support in English, Spanish, French, and American Sign Language. Go to the Microsoft Disability Answer Desk site to find contact information for your region.
If you are a representative of a government agency or commercial organization, contact the service |
|
|
|
|
|
Hotkeys are buttons or their combinations who are responsible for carrying out this or that teams. And it is customary to divide them into 2 categories - are common And special.
General are key combinations that are widely used and allow you to perform the same action in different applications. Example This combination is ctrl+c, which in all programs, with extremely rare exceptions, is responsible for copying the selected data to the clipboard.
Special they are used only in some programs, although, taking into account the number of button combinations, they can be repeated in different ones. Such combinations are responsible for executing a single command, often unique to a given application. For example, the combination of the ctrl+p buttons in some programs is not sending a file for printing, but, say, rotating an image.
Excel Hot Keys
In order to avoid certain misunderstandings, let us immediately go through general hotkeys, which have a completely logical effect in Microsoft Office Excel.
Ctrl(Short for Control) +
C– copying the selected fragment
Ctrl+V– paste copied fragment/text
Ctrl+X- cut out. This action deletes a fragment from the document, but copies it to the clipboard. Useful when moving part of a document to a new location.
Control+S– saving the document. The specificity of this combination is that when you save the created document for the first time, a window will appear in which you are offered choose a place to save. That is, it is used as a command " Save as" But further uses will be simple re-record file.
Control+P– sending a document for printing. If you select a fragment, then by default only it will be sent for printing. Otherwise, the entire document will be sent for printing.
Ctrl+Z– cancel the last action. At the same time, a certain queue and logic for using the combination are stored. For example, if you cancel the action of typing in the selected cell, all entered text will be deleted. Also, this function does not work as “cancel undo”, that is, by canceling the third action in order and pressing the hot key combination again, we will cancel the second action.
In this case, pressing Ctrl+Z will delete all text from cell 1:1.
Ctrl+Y will restore the last action. A combination similar to Ctrl+Z, but working in the opposite direction. That is, the action canceled using the previous combination will be restored. It is especially useful if pressing Ctrl+Z canceled the entry of a huge formula.
Control+W close the current document. It could have been a special keyboard shortcut, but it works in all MS Office editors, so it ended up in the list of general ones.
Ctrl+T create a table. It works in the same way as the previous one - common to all Office editors. However, it doesn't make much sense since Excel is a spreadsheet editor in its own right.
Very often the use of this combination ends with the following message.
Control +
N creating a new document. Opens a new document without closing the old one.
Special keyboard shortcuts are also present in Excel. True, they are not so diverse. But on the other hand, the specificity of their use allows you to save a decent number of mouse clicks.
Ctrl+K– inserting a hyperlink. In principle, it is a general button, but due to the unique interaction with other Excel workbooks, it ended up in special ones. Using this button, unfortunately, you can only add the opening of another book from the current one.
Ctrl+
F/Ctrl+
H– find and replace and simply find. A corresponding window appears, which allows you to find the required part of the document and edit it manually or replace part of the text with the specified one. I ended up in special ones because I was trained to edit formulas.
Ctrl+
B/
U/
I– text processors that allow you to change its appearance to “bold”, “underlined” and “italics” do not perform other functions and work only with text.
These keyboard shortcuts can be used in the spreadsheet editor MS Office Excel.
In principle, each of these combinations is present in all programs in the package. There aren’t that many unique combinations just for Excel. Although, they still meet. Special combinations also include combinations that activate add-ons programs. For example, the Adobe Acrobat plugin, which makes it possible to save documents in PDF format, is activated by a custom button and can be exotic, e.g. Control +F12, which by default works like opening a document.
Excel hotkeys help you work more efficiently with the program.
The Excel spreadsheet processor combines a lot of functions and capabilities for working with even the most complex tables and documents.
The presence of hot keys makes it easier for users. They don't have to be distracted by clicking a button on a toolbar.
Unfortunately, a small number of users are aware of all the features of the program, in particular, the most popular keyboard shortcuts.
Calculation
Whether you are creating a complex report or a simple table in the program, calculation functions are equally necessary in both cases.
Using hot functions, you can carry out all calculations several times faster and more efficiently.
Having written any formula, the user independently determines the order of actions that will be performed on the cell.
Operators are symbolic or conditional designations of actions that will be performed in a cell.
List of hotkeys and operators they call:
| Combination
| Description
| Excel 2003 and older
| Excel 2007 and 2010
|
| SHIF+F3
| This combination calls the function wizard mode | Insert → Function | Formulas → Insert Function |
| F4
| Switch between document links |
|
|
| CTRL+~
| Displays the data in a cell and the result of its calculations | Tools → Formula Dependencies → Formula Validation Mode | Formulas → Show formulas |
| ALT+=
| Calls the autosum function | Insert → Function → SUM | Formulas → Autosum |
| F9
| Performing formula recalculation | Tools → Options → Calculations → Calculate | Formulas → Recalculation |
| SHIFT+F9
| Perform formula recalculation only on an included worksheet | Tools → Options → Calculations → Sheet recalculation | Formulas → Perform calculations |
Editing
Using editing hotkeys you can easily fill the table with data. You can fill a range and edit a cell without leaving your keyboard:
| Combination
| Description
| Excel 2003 and older
| Excel 2007 and 2010
|
| F2
| Calling the selected cell editor | Excel 2007 and 2010 F2 Edit active cell Double left click on cell |
| SHIFT+F2
| Calling a cell note | Right click on cell → Edit Note |
| CTRL+Delete
| Removes selected text |
|
| CTRL+ALT+ V
| Special insert | Right click on range → Paste Special |
| CTRL++
| Adding specified rows and columns | Insert → Rows/Columns | Home → Insert → Rows/Columns |
| CTRL+-
| Deleting specified rows and columns | Right-click on selected rows/columns → Delete | Home → Delete → Rows/Columns |
| CTRL+D
| Fill a range (down) with data from a cell that has been selected | Edit → Fill → Down | Home → Fill → Down |
| CTRL+R
| Fill a range (to the right) with data from the cell that has been selected | Edit → Fill → Right | Home → Fill → Right |
| CTRL+H
| Calling the Find-Replace dialog box | Edit → Replace | Home → Find and Select → Replace |
| SHIFT+F11
| Creating a new blank sheet in a workbook | Insert → Sheet | Home → Insert → Insert Sheet |
| CTRL+Z
| Undoing the last action taken in a program | Edit → Undo |
| CTRL+Y
| Repeat the last action taken in the program | Edit → Redo |
| ALT+SHIFT+→
| Grouping selected data and elements | Data → Group and Structure → Group | Data → Group |
| ALT+SHIFT+←
| Ungroup selected data and elements | Data → Group and Structure → Ungroup | Data → Ungroup |
Formatting
Formatting data using hot keys allows you to configure the format of each cell for further calculations without calling an additional menu.
| Combination
| Description
| Excel 2003 and older
| Excel 2007 and 2010
|
| CTRL +1 | Opening the cell format editing dialog box | Format → Cells | Right click on range → Format Cells |
| CTRL +SHIFT +~ | Setting a general format for elements | Right click on cells → Format Cell → Number |
| CTRL +SHIFT +$ | Hotkey for entering the currency format |
| CTRL +SHIFT +% | Hotkey for entering percentage format |
| CTRL +SHIFT +# | Hotkey for entering the “Date” format |
| CTRL +SHIFT +@ | Hotkey for setting time |
| CTRL + SHIFT +! | Setting the numeric data format |
| CTRL +B | Setting Bold Font | Right click on cells → Format Cell → Font |
| CTRL +I | Setting the Italic font |
| CTRL +U | Emphasizes text |
| CTRL +5 | Entering strikethrough text |
| CTRL +SHIFT +& | Enable Outer Borders of a Selected Cell | Right click on cells → Format Cell → Border |
| CTRL +SHIFT +_ | Turning off any edges of a cell |
Data input
Quick keyboard shortcuts for data entry will save time because you don't have to constantly switch between cells manually and select text.
Navigation and highlighting
Navigation hotkeys will help you quickly navigate the position of all elements on the sheet and access each of them more efficiently.
| Combination
| Description
| Excel 2003 and older
| Excel 2007 and 2010
|
| CTRL +Backspace | Return to previous cell |
|
|
| CTRL +PgUp /PgDown | Navigation through book sheets |
|
|
| CTRL+Tab | Book navigation | Window → desired file | View → Go to another window |
| CTRL + space | Column selection |
|
|
| SHIFT +space | Selecting a stitch |
|
|
| ALT+; |
| F5 → Select → Visible Cells Only | Home → Find and Select → Selecting a Group of Cells → Only Visible Cells |
| CTRL +A | Select cells that are in the visible range of the sheet |
|
|
| CTRL +End | Move to the most recent cell |
|
|
| CTRL +SHIFT +End | Selecting the most recent cell |
|
|
| CTRL + arrows | Move to Column Edges |
|
|
Working with files
With just a few key combinations you can open, save or create a file.
Use the save hotkey periodically to avoid losing document data in the event of a program failure.
You may also be interested in these articles:
Miscellaneous
These hotkey combinations allow you to create additional modes for working with tables and other functions necessary for quick work in the program.
| Combination
| Description
| Excel 2003 and older
| Excel 2007 and 2010
|
| CTRL +L | Smart table creation mode | Data → List → Create List | Data → Format as table |
| CTRL +F2 | Keyboard shortcut to enable preview | File -> Preview | Office button (File) → Print → Preview |
| F4 | Repeat the last action performed |
|
|
| CTRL +K | Inserting a hyperlink | Insert → Hyperlink | Insert → Hyperlink |
| CTRL +F3 | Calling the Name Manager | Insert → Name → Assign | Formulas → Name Manager |
| ALT +F8 | Open Macro Dialog Box | Tools → Macro → Macros | Developer → Macros |
Spreadsheet users can also use hotkeys for the search function. Search in Excel is stylized as a special key on the main toolbar.
The search window with subsequent replacement will help reduce the time spent editing the document.
You can call the search menu using the hotkey combination CTRL + F, as in other MS Office programs. In this way, only the keyboard is used.
To find or replace elements, follow the instructions:
- Press CTRL +F or the search menu on the toolbar;
- In the window that opens, go to the search tab if you just need to find an object or to the “find-replace” tab if you need to search the document and then replace the found data;
- Using additional functions, you can specify special search parameters, for example, cell format, location and search area;
- After the cell with the original data has been found, click on the Replace button.
12 ways to speed up your work in Microsoft Excell
No. 1. Copying elements
To avoid manually copying the same formula into each cell of the same column, simply move your pointer to the first cell and double-click the black cross, as shown in the figure.
No. 2. Automatically determines the required width of each column
To set the correct column width, double-click on the border of one of them.
No. 3. Quickly create a drop-down list in one of the cells
To quickly create such a list, follow the instructions:
- Select an area of cells or a single cell;
- On the toolbar, select the Data tab and in the validation field, select “Data Type” and then create a list;
- In the dialog box, specify the coordinate of the cell in which the list will be located.
No. 4. Copying elements while maintaining formatting
Advice! To avoid adjusting formatting after each copy, in the filling parameters, select the item that fills only the appeared value with formatting, as shown in the figure.
No. 5. Instant transition to a new document sheet
You can quickly move between sheets by right-clicking on the table of contents of the book (lower left corner of the working window).
No. 6. Creating a Smart Table
A regular list in a table can be turned into a smart table using the hotkey combination CTRL + L.
This way, a filter will be connected and all incoming data in the table will be automatically adjusted (aligned by size).
No. 7. Instantly add information to a chart
In order not to enter cell coordinates into the diagram over and over again, you can do the following: select all the necessary cells and drag them onto the diagram.
Hotkeys help users simplify and speed up their work by replacing multiple actions with one. This is especially important for an office program such as Microsoft Excel, which is designed to make it easier for a person to work with various types of data arrays. Let's look at popular ones that are applicable in many versions of this application (from Excel 2003 to Excel 2013). Moreover, in the Excel 2003 application there are no combinations for working with the ribbon - the Quick Access Toolbar, since this feature appeared only in Excel 2007 and is available in later versions. Some of the given combinations may not work for localized versions of the application in question.
The most popular Excel hotkeys
By pressing these key combinations, the main functions of the program are performed. When describing hot keys, the “+” symbol is used to indicate the simultaneous pressing of keys to the right and left of the “+” sign. Key combinations are indicated in parentheses; one, two, three or even four can be pressed at the same time. Usually one, two or three of them are service keys - Ctrl, Shift or Alt. You need to press them first and, while holding them down, press another (third or fourth) of the hotkey combination.
To create a new file, press (Ctrl + N). To go to the menu or open a file - (Ctrl + O), save a file - (Ctrl + S), "Save as" - (F12), print - (Ctrl + P). Close file - (Ctrl + F4). Last action: undo - (Ctrl + Z), redo - (Ctrl + Y). Start creating the formula - (=). Close file - (Alt + F4). Add a column - (Ctrl + Shift + plus key). Insert a new sheet - (Shift + F11). Call the table creation dialog - (Ctrl + L). Collapse text in a cell - (Alt + Enter).
Navigation Operations
The following Excel shortcut keys are available to perform transitions. Calling the “Go” window - (Ctrl + G). Go to: to the cell on the right - (Tab); to the cell on the left - (Shift + Tab); up one screen - (PageUp); down one screen - (PageDown); to the next sheet - (Ctrl + PageDown); to the previous sheet - (Ctrl + PageUp); in the data area: to the starting cell - (Ctrl + Home); to the enclosing cell - (Ctrl + End); towards the arrow to the first cell - (Ctrl + Arrow). To move between sheets of an open book - (Ctrl + F6).
Formatting text and cells
For the selected cell (cell area), use the Excel hotkeys shown below. These shortcuts use the Ctrl key plus the other keys listed in parentheses in this section.
Font: bold - (B), underlined - (U), italic - (3), strikethrough - (5). Menu: change font - (Shift + F), font size - (Shift + P). Apply border outline - (Shift + 7). Remove all borders - (Shift + Underline).
Call menu: cell formatting - (1), font selection - (Shift + F), font size selection - (Shift + P). Set format: percentage - (Shift + 5), numeric - (Shift + 1), time - (Alt + 2), date - (Alt + 3), monetary - (Alt + 4), currency - (Shift + 4) , general (to remove formatting) - (Shift + #).
Selecting and editing text
Select: entire sheet - (Ctrl + A), full row - (Shift + Space), entire column - (Ctrl + Space), cell array in the direction of the arrow - (Shift + Arrow), cell array including all worksheet data - (Ctrl + Shift + 8).
The selected text: cut (to clipboard) - (Ctrl + X), copy (to clipboard) - (Ctrl + C). Paste from clipboard - (Ctrl + V). Delete one character from the cursor: on the right (Delete), on the left - (Backspace). Changing the active cell - (F2). Deleting the current value and changing the active cell - (Space).
Other Excel hotkeys
Opening the text search window - (Ctrl + F), replacing text - (Ctrl + H), selecting a style - (Alt + "). Automatically create a chart on a new sheet (F11). Change a cell comment - (Shift + F2). Calculation of AutoSum of selected cells in a column - (Alt + =); the value of the sum is entered in the cell of this column in the next line under the selection. Insert the current one into the selected cell: date - (Ctrl + Shift +4), time - (Ctrl + Shift +6). ). Spell check - (F7).
Algorithm of actions
If you need to merge cells in Excel, there are some difficulties. After all, performing this operation is associated with the loss of data in all cells of the merged area, except for the very top left one. First, you need to select the area of cells to be merged, right-click on the selection area, and select “Format Cells...” from the drop-down menu. The “Format Cells” window itself appears, in it select the “Alignment” tab and check the box next to the “merge cells” item. In general, Excel does not provide hotkeys to perform the operation in question.
Merging cells is easier to do using the special “Merge and Center” button, which is located in the “Home” menu. If you do not need to place the data in the center, click on the label to the right of this button and select the appropriate item from the drop-down submenu. By the way, if you have to use this operation often, it is better to place this button on the quick access panel. To save data from cells other than the top left of the merged area, you need to move their contents to another location or add them to this cell using copy (or cut) and paste operations.
Other possible ways to merge cells without losing data involve the use of macros, which can be found, for example, on Excel forums. The principle of macros is the same as manually, but it is faster and more invisible to the user.
How to insert a row using hotkeys
Often there is a need to insert a row into an Excel worksheet. The hotkeys used for this operation are Ctrl + plus sign. In this case, you should select the line above which you want to insert a new one. This selection can be performed using a hotkey combination (Shift + Space) or by left-clicking in the number area on the left of the corresponding line when the cursor changes to an arrow. If a row is not selected, then the hotkey combination (Ctrl + plus sign) leads to the appearance of the corresponding “Add Cells” menu, which prompts you to choose what to insert: cells shifted down or right, row or column.
Excel hotkey “Delete Row” - (Ctrl + minus sign). To delete a line, you need to select it and press this key combination.
When you press the Alt key on the application menu bar, hotkey hints for the corresponding menu sections appear. This is illustrated in the figure. Available for program versions starting from Excel 2007.
Paste Special in Excel
Often you need to insert only values or just formulas into a cell. There is an option for this in Excel - paste special. The hotkeys for this are (Ctrl + Alt + V).
Pressing these keys will open the Paste Special dialog box. It is available if an object, cell contents, text on a sheet or in another program was copied or cut immediately before. In the window, select the item you are interested in: formulas, values, formats, notes, or another of the suggested options.
Thus, after reading the contents of this article, you learned what Excel hotkeys exist and how to use them. Naturally, not all existing combinations are described in the article. For a more complete study of the topic, you should use special literature.
