Last Updated on
Excel can be tricky sometimes, there’s tons of shortcuts and loads of different ways you can do the simplest of tasks, so in this article we’ll be giving you a lesson on how to delete a row or rows in excel easily. Without further ado let’s get started.
Choose A Row
To quickly delete a row in excel, you need to begin by choosing the row that you want to delete, you can do this by left clicking on the row that you want from the leftmost bar which is parallel to the row you want to delete.
These will be numbered so you can easily see which row it is you’re deleting
Once you’ve selected your row, it should be highlighted in a light gray. This is so you’re absolutely sure that the row that you’ve selected is the one that you want to customize.
Press Right Click
You can then right click anywhere on that row that you’ve selected, and press the ‘delete’ option that’s on the dropdown bar.
This should’ve immediately deleted the row that you had highlighted previously. It’s that easy!
If you’d prefer, you can also delete rows by right clicking on a single cell that you’re using. Just make sure that it’s apart of the row that you wish to delete altogether.
You can right click on the cell you’re using and select the ‘delete’ option once again.
This should come up with an option box, where you can choose to delete things from a list of characteristics, these are:
- Shift cells left
- Shift cells up
- Entire row
- Entire column
For this specific purpose, you’ll just want to delete the entire row, but you can use this feature if you want to delete anything on excel!
Deleting rows is just as easy as before, all you have to do is left click the starting row that you wish to delete, and drag down all of the rows that you want to delete.
If the rows aren’t after one another, you can group them all together by holding down the ctrl key and left clicking on each row that you wish to delete from the left bar that you used before.
Press Right Click
Once you’ve selected every row that you want to delete, it’s as easy as before, simply right click over any of the rows that you’ve highlighted, and press the ‘delete’ option
Every row that you highlighted should now have disappeared!
Now that you know how to delete rows, it’s important to know that the undo feature is always in place to have your back, if you make a mistake.
If you look to the top left of your screen, near to where you can save your work and print, there are two forwards and backwards arrows which you can click on.
You can go as far back as you like, and if you even want you can reverse the backwards arrow with the forwards one too!
So there it is, it’s that easy to delete rows on excel. We hope that this guide was helpful for you, as excel can be tricky, but now you can delete rows at ease!