Microsoft Excel: Hot Keys

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:

Content:

• Combinations of the “Irreplaceable” category

• Combinations in the “Useful” category

• Combinations of the “Doubtful” category

• Combinations of the “Trivial” category

• Combinations in the “Useless” category

▲ up

▲ up

▲ up

▲ up

▲ up

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.

Excel hotkeys customization

What should you do if you often use a certain operation in your work, and the keyboard shortcuts are difficult to remember? Press "ALT+F+T". Select:

Further:

The command will appear in quick access.

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.

You may also be interested in these articles:

• EXCEL formulas with examples - Instructions for use
• Excel Pivot Tables - Creation Examples
• Rounding in Excel - Step by step instructions

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.

Document selection and search menu

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;

Find and Replace Dialog Box

• 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.

What is Excel

Read also: Basic hotkeys in Windows 10: all the necessary combinations for full operation, as well as how to disable and configure them.

This program is the second most popular among all programs in the Microsoft Office suite.

Word, already familiar to everyone, invariably remains in first place.

This program is also positioned as a table processor because it was originally designed to work with tables.

The main range of use of Excel is accounting, economics and other areas that use the processing of mathematical formulas and data.

back to menu ↑ back to menu ↑

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.

The process of quickly copying elements of one table column

No. 2. Automatic determination of the required width of each column

To set the correct column width, double-click on the border of one of them.

Column width alignment method

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.

Drop-down list

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.

Copy without losing format

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).

Quickly move between sheets of a book

No. 6. Creating a Smart Table

A regular list in a table can be turned into a smart table using the CTRL+L hotkey combination.

This way, a filter will be connected and all incoming data in the table will be automatically adjusted (aligned by size).

Formatting a table

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.

Quickly add cells to a chart

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.

Autocomplete

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.

Copying data in a cell

No. 10. Entering recently used functions

If you need to apply a function that was recently used to a cell, follow these instructions:

• Select the desired cell and enter the “=” symbol;
• At the top left of the window, open the drop-down list and select one of the recently applied formulas.

Entering the last formula

Read also:  Screen video recording: 10 best programs for any occasion

No. 11. Converting columns to rows and vice versa

Copy a row or column. Paste the data into the desired location using the key combination CTRL+ALT+V.

Transpose the selection using the Insert window.

Quick conversion

No. 12. Instant copying of book sheets

To copy, quickly click on the sheet icon and press the CTRL key.

Copying sheets

Videos:

Presentation of Hot Keys when working in Excel

Excel Hot Keys - The Most Essential Options

10 Rarely Used Keyboard Shortcuts in Excel

We look at little-known, but very useful hot key combinations in the MS Excel spreadsheet processor.

Hotkeys. Introduction

This lesson covers the basics of working effectively in Excel - using hotkeys.

If you have Telegram, you can now download any software or game through our bot, just follow the link and try it!

« Previous entry

Search settings

If you need to set certain settings, then in the window you need to click “ Options ”.

Here you can set the following settings:

• in the “ Search ” line you can limit the search to only the sheet;
• in the “ View ” line you can select the option of viewing by rows or by columns;
• the line “ Area ” allows you to select the symbols you are looking for: formula or value;
• o the required combination is found, taking into account the case;
• if you need to see a cell that contains only specified characters, you need o;
• In the “ Format ” tab you can select the desired formatting.

How to use and customize the advanced filter in Excel

By clicking the “ Replace ” button, you can immediately replace what was found with the specified values.

In the “ Find ” line you need to enter the desired combination of values, and in the “ Replace ” line those characters with which you should replace the found ones.