Hot key “delete row” in Excel spreadsheet

The hot key combination is an option through which it is possible to type a certain combination on the keyboard, with which you can quickly access certain features of the Excel editor. In the article, we will consider ways to delete rows in the editor table using hot keys.

Deleting a line from the keyboard with hotkeys

The fastest way to delete a line or several is to use a combination of hot keys. In order to delete an inline element using a keyboard shortcut, you just need to click 2 buttons, one of which is “Ctrl” and the second is “-“.

Hot key delete row in Excel spreadsheet
1

It should also be noted that the line (or several elements) must be selected in advance. The command will delete the specified range with an upward offset. The application will make it possible to reduce the time spent and to refuse unnecessary actions with the help of which the dialog box is called. It is possible to speed up the procedure for deleting lines using hot keys, however, for this purpose, you will need to do 2 steps. First, save the macro, and then assign its execution to a specific combination of buttons.

Saving a macro

By using macro code to remove an inline element, it is possible to remove it without using the mouse pointer. The function will help determine the number of the inline element where the selection marker is located and delete the line with an upward shift. To perform an action, you do not need to select the element itself before the procedure. To transfer such code to a PC, you should copy it and paste it directly into the project module.

Hot key delete row in Excel spreadsheet
2

Assigning a keyboard shortcut to a macro

It is possible to set your own hotkeys, so that the procedure for deleting lines will be somewhat accelerated, however, for this purpose, 2 actions are required. Initially, you need to save the macro in the book, and then fix its execution with some convenient key combination. The considered method of deleting lines is more suitable for more advanced users of the Excel editor.

Important! It should be noted that it is necessary to select hot keys for deleting rows very carefully, since a number of combinations are already used by the Excel application itself.

In addition, the editor distinguishes the alphabet of the specified letter, therefore, in order not to focus on the layout while running the macro, it is possible to copy it with a different name and select a key combination for it using a similar button.

Hot key delete row in Excel spreadsheet
3

Macro for deleting rows by condition

There are also advanced tools for implementing the procedure in question, using which you do not need to focus on finding the lines to be deleted. For example, we can take a macro that searches for and removes inline elements containing user-specified text, and an add-in for Excel. It removes lines with a lot of different conditions and the ability to set them in a dialog box.

Conclusion

To remove inline elements in the Excel editor, there are several handy tools. You can use hotkeys to perform such an operation, as well as create your own macro to remove inline elements in the table, the main thing is to follow the algorithm of actions correctly.

Leave a Reply