Microsoft Excel program: hot keys. Keyboard shortcuts in Excel for Windows Understanding hotkeys in Excel

This article describes Excel shortcut keys (the term Excel Shortcut Keys is often used) for the Microsoft Excel 2013 version, but most of the key combinations apply to previous versions of Microsoft Excel: Excel 2010, Excel 2007, Excel 2003 (except for the function ribbon key combinations).

Hotkeys in Excel are shortcuts or keyboard shortcuts that can be used to quickly perform various necessary actions and navigate through the program. If you frequently perform the same type of work operations, using hot keys can significantly save your working time.

In localized versions of Microsoft Excel, some hotkeys may not work.

Excel hotkeys for working with the function ribbon (Ribbon)

In new versions of Microsoft Office programs, starting with version 2007, the user interface has changed significantly. A so-called Ribbon appeared at the top of the screen, containing bookmarks with functional buttons.

Bookmarks and some buttons can be activated with keyboard shortcuts. To view these combinations, just press the Alt button.

Excel keyboard shortcuts with Ctrl key

Excel Hotkeys Using Function Keys (F1-F12)

Other useful Excel keyboard shortcuts

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:

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:

Formatting

Formatting data using hot keys allows you to configure the format of each cell for further calculations without calling an additional menu.

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.

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.

Miscellaneous

These hotkey combinations allow you to create additional modes for working with tables and other functions necessary for quick work in the program.

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:

1. Select an area of ​​cells or a single cell;
2. On the toolbar, select the Data tab and in the validation field, select “Data Type” and then create a list;
3. 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.

No. 8. Automatically fill empty cell(s)

Select the desired range and use the F5 key to select “blank cells”. Press CTRL+Enter on your keyboard.

No. 9. Copying only cells that are visible

Select the cells (required range). Using the ALT+ key combination; Visible cells can be selected. Then copy and paste the data to the desired location as shown in the image below.

When you start the program, a new document automatically opens, which is a table ready for data entry.

The main difference from Word is the ability to produce various mathematical functions.

Calculations can also be automated by entering a special formula in a specific cell.

Excel has a large number of different functions.

For example:

• financial– this function is intended primarily for planning and carrying out financial and economic activities, and also helps to make settlements on financial assets;
• date and time – allows you to use temporary values ​​​​in calculations, which are entered in the form of simple numbers;
• mathematical and trigonometric – used to simplify and speed up the calculation process;
• statistical – used to calculate statistics of input data, as well as probability, population and sample analysis;
• viewing and links – allows you to insert hyperlinks into a document and work with them directly;
• Database– provides data and list management using autofilters built into Excel, performs statistical analysis;
• text– processes texts entered in table cells;
• logical– used to speed up work, for example, in numbering cells;
• informational – provides work in macros.

Almost all functions are available in the standard version of the program.

For others, the installation of an extended package or individual components is required.

Excel 2007

Read also: TOP 5 Ways to take a screenshot on a computer running Windows 10

This section describes the most common hotkey combinations for Excel 2007.

If in the “Keyboard shortcut” line the value of the keys is indicated by a “+”, it means that the keys can be pressed simultaneously. All combinations are entered on the English keyboard layout.

Using Ctrl

Read also: How to Download Free Office for Windows? Replace Office: TOP 10 free analogues for Windows

Function keys

Read also: TOP 10 Services and programs for free online text recognition

Other keyboard shortcuts

Read also: TOP 10 Free programs for working with PDF files + Reviews

Excel 2010

Read also: Our TOP 10: Choosing the best PDF editor in Russian

Versions of Excel from 2010 and higher have a ribbon at the top, which, when you press the Alt key, displays tips for entering special combinations.

The table of combinations using the Ctrl key can also be used in this version of the program, since all commands are identical.

However, commands for function keys and other keys may differ.

Function keys

Read also: WPS Office: what is it? Introduction to the program, where to download | +Reviews

Other keyboard shortcuts

Read also: How to determine a font from a picture? The best services of 2019

If in the “Keyboard shortcut” line the key values ​​are indicated separated by “+”, it means that the keys must be pressed simultaneously; if the key values ​​are listed separated by commas, then they must be entered sequentially.

All combinations are entered in accordance with the table.

Excel 2013 and 2016

Read also: Our TOP 15: The best programs for presentations in 2018

The combinations and hotkeys presented above are applicable to the latest versions of Excel.

If there is no command, you can set it yourself in Macros.

This is done to automate repetitive tasks.

What is a macro?

The macro is present in every product in the package.

This component is designed to optimize work with programs.

For example, if you repeat the same actions over and over again, you can speed them up by recording them in a Macro and assigning a hotkey combination to the action.

There are a few things to remember before you start recording a new Macro:

1. If a Macro was recorded for a specific range, it will only work in that range. Even if you add new rows and/or cells to the range, the Macro will not be applied to them.
2. To record a sequence of tasks, it is recommended to create several “small” macros rather than one large one. This way, you can apply actions not in a given sequence, but changing it if necessary.
3. Not only tasks related to Excel can be recorded in Macros. If these actions can be performed in other products of the package, the Macro will work with the same set of hot keys.

How to record a macro?

To record a Macro correctly, carefully follow the instructions below.

First you need to enable Macros in Excel.

To do this, you need to go to the “Developer” ribbon tab.

Toolbar. Developer Tab

Note: If there is no such tab in the ribbon, you need to enable it yourself.

To do this, open the menu "File" in the upper left corner and go to "Options".

When the parameters window opens, go to the tab "Customize the Ribbon", after which in the right part of the window we put a tick on the item "Developer" and save the changes by clicking the “OK” button.

In the “Developer” tab, select the item.

In the window that opens, place a marker on the line “Enable all macros (not recommended, may launch dangerous program)”, then click the “OK” button

After you have activated macros, a new macro can be recorded.

To do this, go to the “Developer” tab again and click the button

In the window that opens, enter the name of the macro.

To assign a keyboard shortcut, enter a letter or number in the appropriate field.

If it matches an existing command, the combination with “Ctrl+” will be automatically changed to Ctrl +Shift ++.

After defining the keyboard shortcut, you need to choose where to save the current macro.

Several options are offered: "This book", "Personal Book" And "A new book"

By default, users save macros in "This book", but you can change the save location if you wish.

In the “Description” field, you can enter a short description of the new macro so that in the future it will be clear what action it performs.

To start recording the macro, click the “OK” button.

After this, perform the desired action on the masonry "Developer" click the button "Stop recording".

Now, when you press the hotkeys you specified, the action recorded in the macro will be performed.

This way, you can record frequently performed actions yourself.

Let's start with the basics, " Excel hotkeys“, these are keys, when you press a combination of which, the action associated with them occurs.

Hot keys are a combination of keys that, when pressed simultaneously, perform some action. This allows you to significantly save time on searching for what you need using a mouse button in the program menu. The expression comes from the English " hot key", literally hot keys, but figuratively

(and these combinations work in many programs, including Wivdows)

Ctrl+A- select all

Ctrl+C- copy

Ctrl + Alt + V—

Ctrl+V- insert

Ctrl+X- cut

Ctrl+Z- go back to action

Ctrl+F— document search

Accumulated experience and research show that the hotkeys Ctrl + C, Ctrl + V, Ctrl + X and Ctrl + S save approximately 3% of the working time of an employee working regularly at a computer. This is really useful!

Hotkeys for every day

Ctrl + 1— opens the cell format menu

Shift + 'space' - select the entire line

Ctrl + 'space - select the entire column

Ctrl + ‘-‘, Ctrl + ‘+‘ - deletes, adds a line

F4— when writing a formula, adds a $ sign to the formula or the so-called. anchors (choose between absolute and relative links)

F7- spell check

ALT+=— autosum function

CTRL + down/up arrow— moves the pointer to the last/first cell of the range

CTRL + End— moves to the last filled cell.

CTRL + Shift + End- selects all cells until the last one

ALT + down arrow - simple dropdown list

Useful Excel Shortcut Keys, But Rarely Used

CTRL + Shift + 4- insert date today

CTRL + PgUp/Pgdown- switching between sheets

CTRL + Shift + Enter- array formula

ALT + F8 - open menu

ALT+F11- open VBA

Other ledgers in Excel

To quickly copy a range, select it, hold down CTRL, and drag the border that appears to the desired location. The range is copied.

Remember to use alt + tab to switch between windows.

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.