Would you like to know how you could easily delete one or more columns in Excel? We can take a look at it together in this tutorial!
See the video tutorial and transcription below:
See this video on YouTube:
If you’re asking how to remove columns in Excel, you’re in the right place! To find the answer, we’ll use the data table you can see right in front of you now.
First, you need to click on the selected column heading represented by a letter located on the top of the spreadsheet. That’s how you mark the column you want to remove. In our case, this is gonna be column B.
Now right-click and choose the option ‘Delete’.
And that’s all you need to do! You may have spotted that the order of the columns got adjusted to the change we’ve made. February’s not in column C anymore, but it’s moved to column B.
And here are two tips to make your life with Excel easier:
If you need to remove multiple columns that are next to each other at once, select the first column of the batch – click on the left button of the mouse, then hold and drag through all the columns you want to delete.
You don’t need to waste your time counting the number of columns you’re highlighting – Excel will do that for you! Just look at the little box on the right where you’ll see the selected column count.
Once you’ve marked all the columns you want to remove, repeat the steps you already know – right-click into the highlighted area and select ‘Delete’. Good job!
But watch out!
If the columns you need to delete are not consecutive, you’ll have to try a slightly different way to remove them.
Select the columns by clicking on the first one, then find and press on the keyboard the ‘Ctrl’ key. While holding it, select any column you need by simply clicking on it. Let’s pick columns C, E and G, now.
Use the right-click, choose ‘Delete’, and we’re done!
There’s one thing to keep in mind, though.
In this tutorial, you saw how to delete columns from a spreadsheet. Before you remove any columns, make sure you won’t need the data they contain, since all the information becomes lost after deletion.
If you still need the information contained in the columns you intend to remove, it’s always better to hide them.
Don’t miss out a great opportunity to learn:
If you found this tutorial helpful, give us a ‘like’ and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!
See you in the next tutorial!