There may be times when you need to know how to delete infinite columns in Excel, how to delete blank columns in Excel, how to delete infinite blank rows in Excel, how to delete infinite blank columns in Excel using Office 365 etc. For example, you may need to use an Excel formula or VBA for this purpose. Today, we’ll show you how to delete infinite columns in Excel using Office 365 with various methods and lots of examples. You can use any version of Excel that you prefer.
📁
Download Excel File
To prepare this article, we used an Excel workbook, which is available for download. Additionally, you can edit and customize the data you enter while viewing the results.
Learn to Delete Infinite Columns in Excel with These 5 Easy Techniques
Let’s say we have the following set of data, and we have used up to column E. Now, you want to get rid of all of the columns in the Excel sheet that start with column H.
1. Using Context Menu
We can delete as many columns as we want by using context menu in Excel. We follow the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- First, we select the very first column from which we wish to delete the rest of the columns.
- Then we press Ctrl, Shift, and Right Arrow together It will select all the columns next to the selected columns.
- Now we press the right-click on any selected column header and Delete.
- It will return to our initial dataset with limited columns.
Read More: 4 Ways to Delete Columns in Excel That Go on Forever
2. Combining with Keyboard Shortcut
In Excel, F4 is a very important key. It can do a lot of things, but for now, it will just copy the last thing we did in Excel. In this method, we can delete 20-30 columns. If we hope to delete the whole columns, it will become tiresome work, as we have to delete each column individually.
⬇️⬇️ STEPS ⬇️⬇️
- First, we select first column from which we wish to delete the rest of the columns.
- Now we press the right-click on any selected column header and Delete.
- After that, we pick the entire column to erase and press F4. F4 copies our last action, so we can repeat it until all columns are eliminated.
- Finally, it will return to our initial dataset.
Read More: 6 Easy Ways to Delete Multiple Columns in Excel
3. Deleting by Deselecting Columns
You don’t have to choose the columns that aren’t being used. Instead, you can choose all of the columns and then deselect the ones that are being used to delete the infinite columns.
⬇️⬇️ STEPS ⬇️⬇️
- First, we click on the top left corner’s tiny sign at the intersection of the column and row headers. I will automatically select the columns of our dataset.
- Now we deselect the column that we do not require to delete by clicking on the column header while holding the Ctrl key.
- Now we press the right-click on any selected column header and Delete.
- It will return to our initial dataset.
4. Getting Rid of Infinite Heights of Columns
Now, I’ll show you how to get rid of the columns’ infinite heights. To do that, you’ll need to know how to delete infinite blank rows in excel. We can follow the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- First of all, we click on the row number of the first row from which we want to remove the columns’ infinite height. We clicked on the row number.
- Then we press Ctrl, Shift, and Down Arrow It will select all the rows next to the selected row.
- Now we press right-click on any selected row header and Delete.
- It will return to our initial dataset with removed infinite column heights.
5. Removing Columns by Hiding
We can delete as many columns as we want by hiding them in Excel. We follow the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- First, we select the column from which we wish to delete the rest of the columns.
- Then we press Ctrl, Shift, and Right Arrow It will select all the columns next to the selected columns.
- Now we go to Home, then go to From the Format box, we select Hide & Unhide then we select Hide Columns.
- All the selected columns will be hidden as a result. So, your Excel sheet will now only show the columns that are being used.
📄
Important Notes
🖊️
In Excel, the ribbon is used to access various commands. You can change a lot of things in the options dialogue window, like the ribbon, formulas, proofing, saving, and so on. So the appearance of worksheets on your device could be different from ours.
🖊️
A practice workbook is given so that you can practice yourself.
🖊️
All these exercises and tutorials are done on Microsoft Office 365. Some functions may be unavailable in previous versions.
🖊️
At the side of each Excel worksheet file, there is space where they can practice.
📝
Takeaways from This Article
📌
Readers will be able to know easily how to delete infinite columns in Excel with various methods.
📌
They can press right-click and hit Delete.
📌
They can also use the F4 key to delete infinite columns.
📌
Readers can also delete infinite columns from the context menu.
📌
They can again remove infinite columns by hiding them.
📌
Readers can again do the same by unselecting necessary columns.
📌
Finally, readers can remove the heights of the columns.
Conclusion
That concludes today’s session. These are the methods for deleting infinite columns in Excel with various methods.. We are hopeful that this article will be extremely beneficial to you. Don’t forget to leave your thoughts and questions in the comments section and explore our website, ExcelDen.com, the best Excel solutions provider.