How to remove blank columns in excel.There are many things that you can do on a computer when you work, for example, doing financial statements , accounts or other things that have to do with that field. That is why the most common is that you use the Excel program to do most of the work.
One of the issues that bothers us the most when we make a spreadsheet in Excel is the blank columns. For this reason, the most common thing is that we begin to eliminate them so that the view is a little freer. If you are going to eliminate a good number of columns, we will be showing you how you can do it.
How to remove blank columns in excel;5 Easy Method.
Index( )
- How to remove blank columns in an Excel document?
- In a box with sharp edges
- From the toolbar
- using a filter
- How can you delete blank columns in Excel in bulk?
- How to remove all blank columns in Excel document with VBA macro?
How to remove blank columns in an Excel document?
Microsoft Office is a program that has a large number of tools that we can use very easily on our computer. Among the writing and design tools that this program has, you will be able to do an immensity of things and one of the most used is Excel.
With Excel you will be able to make numerical conversions and accounts in an orderly manner, percentage and price lists and other things with which you will save a good amount of time, since you will not have to do the accounts manually and maybe they will go wrong. But one of the problems is when the line or row is blank and we want to eliminate it without damaging the order we already have.
In a box with sharp edges
One way to clear cells and columns in Excel is by checking them. After doing this you will have to press the right click of your mouse. Here in the tab you will see the option to delete and pressing the row or column you marked will disappear.
From the toolbar
Another way to remove blank cells from Excel is by marking the borders of this column. After doing that you’re going to go to the toolbar at the top and click on ‘Cells’.
After doing that you will see the ‘Delete’ option and when you press it you will have all the options to delete’, so you will click on the one that you see that suits you best, either ‘Delete row’ or ‘Delete column’ . After pressing it, this row will be permanently deleted, but the order or the results you had in your Excel document will not be altered .
using a filter
This is the last way you are going to be able to remove empty columns in Excel . The first thing you are going to do is mark the scope in which you want to remove empty columns. After checking all the boxes that will be deleted, you will click on ‘Data’ which is on the toolbar.
Here a series of choices will be displayed , so you will click on ‘Filter’. Then you will choose what is most necessary with the options that the program offers you.
How can you delete blank columns in Excel in bulk?
If what you want to do is eliminate many columns that are blank, you will be able to do it just by leaving them marked. For this, you have to open this Excel that you want to improve.
Now that it is open, you are going to keep the CTRL key pressed , then while you have the key pressed, you are going to click on the columns that you want to delete. When you check all the boxes you want to delete, you are going to press the right mouse click and then you will only press delete. Thus the boxes that were blank and that you marked will be permanently eliminated.
How to remove all blank columns in Excel document with VBA macro?
VBA is a tool that allows you to use all the Office programs in the most optimal way so that you can get the most out of them. This will give you tables, data and diagrams that will be very useful to you when using those or other programs.
But this is a coding thing so it’s going to be very complicated and if you make a mistake writing one of the things you need to do, you could damage all the progress you’ve made in this document. For this reason, we recommend that you do not do it, since it would be a shame if you ruined a job that you have already done.