Microsoft Excel is one of the most powerful Office suite tools out there, with the creation of its spreadsheets to create and keep records, data, make lists, invoices, perform simple and complex calculations and be able to edit the table in any way possible. . Allowing even delete empty rows and columns in case we don’t need them.
In this article we will show you how you can delete several groups of rows in Excel , it should be noted that this process can also be applied with the columns, since it is practically the same, you will learn how to do it from the three versions of the program.
Index( )
- What steps should you follow to delete multiple rows in your Excel?
- From your Excel online
- With your Excel license
- From your Excel application
- Why can’t you delete the rows from your Excel file?
- How can you unprotect your cells in an Excel file?
What steps should you follow to delete multiple rows in your Excel?
The Microsoft Excel program is available in its classic PC version , which we all know, its online version on the Microsoft Office 365 platform, where there are also the other Office package programs and the version for Android and iOS mobiles. In any of the three, it is possible to carry out the same tasks, except with certain differences, especially in the version for Smartphones.
From your Excel online
The Excel web platform in Microsoft Office 365 does not present any perceptible differences with respect to its desktop version, since it is practically the same, only an online version. You can get it on the main page of Excel and you will be able to do the same tasks as its computer counterpart; the only thing is that in order to use it, you have to have a Hotmail or Outlook account.
To remove rows, columns and/or cells in general, there are different methods. The first is to do everything with the mouse, select the row or rows that will be deleted, simply select only one column, since the effect will have on the entire row of the spreadsheet, then right click and “Delete” , a dialog box will appear and you will click on “Delete the entire row” and that’s it.
The other method is also selecting the corresponding cells, but now we go to the “Home” tab and then in “Cell”, we look for the “Delete” option and select “Delete sheet rows”. The Macro method is not available for the web version.
With your Excel license
In case you have the desktop version, the methods given in the previous section are also valid for this version to eliminate empty rows and columns or with data. However, there is one more addition and that is the use of codes to make it automatic.
First of all, you have to open the Excel VBA dialog box, which is done by pressing the “Alt + F11” keys, here we will enter the following code:
- SubDeleteEntireRow(); Rows(1).EntireRow.Delete; Rows(3).EntireRow.Delete; Rows(5).EntireRow.Delete; End Sub
For each semicolon in the code, it must be written on a separate line and these are not placed, once said code is placed, we save the macro and close the dialog box. Now select a box you want to remove the row from, go to “View” > “Macros” > “View macros” and select the newly created macro and then “Run”.
From your Excel application
The mobile version of Microsoft Excel is the one that presents the greatest differences by far and it is obvious, the menus are somewhat more “hidden”, however, it is not a difficult task either. Select the boxes that will be deleted, then, in the bottom menu, tap on the arrow that is in the right corner to expand it, scroll down until you see the option “Insert and Delete”, tap there and look for the option “Delete rows ”, this will delete the selected rows on your mobile.
Why can’t you delete the rows from your Excel file?
Many times there are certain problems when deleting a row, it happens more than anything when there is information in the spreadsheet and when inserting or deleting interleaved rows , cells or columns, Excel cannot find a way to reorganize the data , when this happens, it usually asks you where you want to move the cells to, and doing so can mess up absolutely everything.
Another reason may be that the document is protected against editing . In this case, if the “Enable Editing” option is not present, you have to talk to the person who gave you the document to remove the protection. Finally, it is very similar to the one we just mentioned, but only when certain cells are protected or blocked.
How can you unprotect your cells in an Excel file?
If it is the case that you accidentally blocked one or several cells due to accidents or it was already like that, in the “Start” tab, in the “Cells” section, touch the “Format” option. At the end of the drop-down menu is the “Protection” section, there tap on the “Protect sheet…” option to remove the lock from your cells and that’s it, you can now edit your spreadsheet normally.