Finally, press right-click by putting the cursor over any blank column.Īfter hitting delete, you will see a dialogue box popup from which select “entire column” and click ok, and you are done. Wait a bit and Excel will automatically select all the blank columns. Step 4: From the drop-down menu select “Go to Special” and select “Blanks.” Step 3: Then from the “Home” ribbon go to the “Editing” tools and select “Find & Select.” Here a “cell” refers to the bordered boxes in which data is written. Step 1: Select the first cell that contains data. Method 3# Delete Infinite Columns by Select the data set Well, the problem is tricky, but the solution is very simple. What if there are 20 columns, 30 columns, or some number you can’t keep track of. Then the F4 method can be applied.īut what if there are more columns than that. Let’s say the 5 or 10 columns need to be deleted. Now, this method can be used if the number of columns that need deleting is limited. F4 will copy your last action, so you can repeat the process as many times as you like or for this instance repeat the process until you have deleted all the columns. So, to delete multiple columns in Excel, first follow the previous method of “press right click and hit delete.”Īfter you have done that, then just select the whole column you want to delete next and hit F4. It has many jobs in Excel, however for now, it will copy our last action in Excel. So how do we delete each column without getting our hands sore? Method 2# Delete Infinite Columns by Using the “F4” keyį4 is a very important key in Excel. Imagine a whole blank column before each filled column. However, this simple thing gets tricky when the scenario is like this. This is the simplest way to delete a whole column. The whole column gets deleted.įor a visual representation, let’s see how it’s done. Press right-click and select delete and voila. Usually what we do is, select the whole column we want to delete. How to Delete Infinite Columns in Excel? Method 1# Delete Infinite Columns by Pressing Right Click and Hit Delete But there is a quick and easy technique to delete columns in Excel. It may seem impossible or highly improbable even, to delete the infinite columns. And the issue becomes mammoth when there is a big number of blank columns within the data set. While working with Excel, I have faced a very crucial issue of deleting columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |