Microsoft Excel is one of the most used tools in any industry. As a standard spreadsheet, it allows users to import and store large amounts of data in workbooks. MS Excel is optimized for data analysis and calculation. This flexible program can also be used to create data analysis models, write simple and complex formulas to perform calculations on this data, extract PivotTables from data in any way possible and present data with graphs. professional aspect. While users are playing with data in Excel, they often find it necessary to delete multiple rows in Microsoft Excel.
When users are processing large data sets, there are many ways to delete individual rows or even thousands of rows. In this guide, you will know the different tips for delete multiple lines in Microsoft Excel all at once.
How to delete multiple rows in Excel
You can try the following methods to delete multiple rows in Microsoft Excel, which are unwanted:
- Deletion of several lines in Microsoft Excel via the context menu
- Deleting multiple lines in Microsoft Excel using the shortcut
- Delete multiple rows in Excel by cell color
- Delete multiple lines by running a macro
Read on to find out how these tips work.
1. Delete several lines in Microsoft Excel via the context menu
This tip works well when you intend to delete several consecutive lines, do the following:
1]Open the Microsoft Excel sheet containing the data you want to use.
2]In the data, select all the rows you want to delete at once.
3]Now right click on the selection to open the context menu.
4]Hit ‘Remove“
5]Then select ‘Whole row ‘ in the list of deletion options and press ‘Okay’.
You can also click on the button boutonHome“In the MS Excel spreadsheet and go to”Cells‘Group. Expand the options by clicking on the arrow button that appears next to “Remove” Now, from the drop-down menu, select ‘Delete sheet lines»To delete unwanted lines.
2. Delete multiple rows in Excel using the shortcut
Here we’re going to use one of the most commonly used shortcut keys, “CTRL + minus (-) “. Let us understand how to use it:
- Select multiple lines in one attempt
1]Select unwanted rows in one attempt on your spreadsheet to delete multiple rows in Microsoft Excel.
2]Now press ‘Ctrl + – “To delete the selection made.
Please note: Now, if the columns or rows are not consecutive, you will have to select individual rows by pressing and holding the CTRL button on your keyboard and clicking individually on the unwanted rows.
When the selection is complete, press the shortcut as mentioned.
- Bulk delete data after line
In case you have a dataset in which you have to delete all the data, the last line is 30 for example. This can easily be done using the shortcut “CTRL + Shift + ?»To select all the lines from your starting point to the last. Once the lines selected, press delete Contextual menu or group of cells of Home or just click on “CTRL + -. “
3. Delete multiple rows in Excel by cell color
Excel offers this amazing filter option which allows users to sort their data in different ways – and sorting by cell color is one of them. This allows you to remove all columns containing a specific background color.
1]Open the Microsoft Excel sheet containing the data you want to use.
2]To apply filers to your table, go to ‘The data ‘ tab, then press “Filtered’ icon.
3]Now click on the small arrow that appears right next to the name of the target column.
4]Go to ‘Filter by color»And select the correct cell color you want to delete.
5]Click OK and you will see all the selected cells at the top.
6]Now select the filtered colored cells, right click on them and select “Delete line»In the list of options.
Lines of the same color will be deleted in no time.
4. Delete multiple lines by running a macro
For those who have tasks in Microsoft Excel that need to be repeated, it can be easily automated by recording a macro. A macro is an action or a set of actions that can be executed by a user as many times as he wishes. Therefore, you can also create a macro to delete multiple rows in Microsoft Excel; here are the steps:
1]Select the targeted lines that you want to delete.
2]Hurry ‘ALT + F11»On your keyboard to open the VBA editor.
3]Click on the first project in the left pane.
4]]Go to the menu bar and select ‘Insert> Module“
5]Paste the following code in the new window to select multiple cells to delete:
Sub Delete_Rows () ‘delete several lines (lines 4, 5 and 6) Worksheets (“ Sheet1 ”). Range (“C4: C6”). FullyRow.Delete End Sub
Edit the line number references (“C4: C6”) to select the specific lines that are not desired.
6]Finally, run the macro script. You can either click on the “Run’ button or press the shortcut F5 to delete multiple rows in Excel.
Finished! Now run the same macro whenever it is necessary to manipulate similar data.
Microsoft Excel is a single destination for storing and storing data that changes from time to time. But updating data can be a tedious task; even smaller things like deleting lines can be time consuming and labor intensive. We hope this guide will help and make things easier.
Related readings:
- 10 most useful Excel tips and tricks for beginners
- Advanced Microsoft Excel tips and tricks.