We heavily use this spreadsheet program in the business industry for recording the regular income and expenditure, budget, charts, and so on.
You can pull in data form the stock market feed and use it for regular automatic updates.
Though you have other options for restoring your data but the popularity of your Microsoft word and Excel can never be beaten.
That is why more than thirty million people still prefer to choose it worldwide.
But sometimes you might be facing trouble to delete the rows and columns sometimes.
How To Delete Multiple Rows In Excel?
If you are thinking how to delete multiple rows in excel, follow the workarounds provided in this article.
When you are stuck with how to delete multiple rows in excel, you can try it from your Contextual Menu that I will be discussing later.
You have another easy way to delete your unnecessary rows or columns with the help of backspace key. You can also choose to run a Macro for removing the cells as well. Now, let us demonstrate the ways in detail. Follow the steps.
Solution 1: Delete The Rows Or Columns From Contextual Menu
You may delete multiple rows and columns in excel through Contextual Menu. For this, you will have to follow the steps given below:
Step 1: First of all, select some columns or rows and then right click on them.
Step 2: Now from the given options, select Delete Rows or Delete Columns option according to your need.
Step 3: You have another option to select, the Layout option after the selection of rows or columns.
Step 4: Now choose to delete the rows or columns. You can choose to hit the Delete button after selecting Layout. Then choose to delete the rows or columns.
Hope this will solve your problem.
Solution 2: Arrange the Unnecessary Rows or Columns
You can put all the unnecessary columns and rows together. For doing this, you will have to go for selection of a row or column.
Then use your mouse for holding on. Now use the dragging technique to drag and release to the particular position.
Next choose the rows and columns you wish to delete. So, just use the drag and release technique to delete the rows or columns.
Solution 3: Use the Shortcut Method
You also have a shortcut technique for deleting multiple rows in excel. Applying the same method, you can delete the columns also. Follow the procedure mentioned below:
Step 1: Select the series of rows or columns you wish to delete.
Step 2: Now, you can use your very own Backspace. Just hit the button.
But in case the rows or columns are not consecutive, you will have to follow another method.
Actually, this method will not work for the non-consecutive rows or columns.
Solution 4: Run A Macro For Deleting Non-Consecutive Rows
If you are still thinking how to delete multiple columns in excel, hold the Alt key and press F11 for opening the VBA editor from your Microsoft Word.
Now, you will have to click on the Normal option for creating a module.
Now hit the Insert option and select Module. Click twice on the module and enter the codes as follows:
dim objcell as cell
dim objtable as table
dim nindex as integer, nrows as integer
dim strtable as string
dim varcellempty as boolean
application.screenupdating = False
Remove the contents of the selected rows.
Selection.Delete
With Selection.Tables(1)
nRows = .Rows.Count
For nIndex = nRows To 1 Step -1
For Each objCell In .Rows(nIndex).Cells
If Len(objCell.Range.Text) > 2 Then
varCellEmpty = False
Exit For
Else
varCellEmpty = True
.Rows(nIndex).Delete
End If
Next objCell
Next nIndex
End With
Set objCell = Nothing
Set objTable = Nothing
Application.ScreenUpdating = True
End Sub
At the end hit the Run option or press F5.
You can also apply the same process for deleting multiple columns.
Wrapping Up
So, I hope by now, you can find out a suitable solution if got annoyed when how to delete multiple rows in excel.
If you still have queries related to this issue or any other folder, please communicate with us in the comments section provided below.
Feel free to shoot us a mail with your ideas or suggestions. We always look forward to hearing back from you.
