How to Delete Infinite Columns in Excel (4 Methods)

Get FREE Advanced Excel Exercises with Solutions!

Actually, Excel doesn’t have infinite columns. Excel 2007 and all the newer versions have 16384 columns in total. The number is so huge for most of the uses of Excel, that the number of columns seems infinite. When you are working with a smaller dataset, these huge numbers of unused columns are absolutely unnecessary, and you may want to remove these columns from your spreadsheet. In this article, I’ll show you 4 easy ways to delete infinite columns in Excel.

Suppose, you have the following dataset where you’ve used the columns up to column E. Now, you want to remove the infinite number of columns starting from column G from your Excel sheet.

dataset


How to Delete Infinite Columns in Excel: 4 Methods

1. Delete Infinite Columns from Context Menu

We can use the Excel context menu for deleting infinite columns.

➤ Select the first column from where you want to delete infinite columns by clicking on the column number (i.e. column G).

selecting columns

➤ Press CTRL + SHIFT+ RIGHT arrow to select all the columns right to your selected column.

infinite columns

As a result, Excel displays the columns at the right end of your sheet and the area will be marked with gray color.

➤ Right-click on any of the column headers.

➤ The context menu will appear and select Delete from there.

context menu

As a result, the display will automatically return at the beginning of the sheet. You will see there is not an infinite number of columns. The last column number of your Excel datasheet is AA. That means now your Excel spreadsheet has only 27 columns.

how to delete infinite columns in excel

You will find your existing dataset at the beginning of your Excel sheet.

dataset

Read More: How to Delete Multiple Columns in Excel


2. Remove Infinite Columns by Hiding

You can remove infinite columns by hiding all the unused columns.

➤ Select the first column from where you want to remove infinite columns by clicking on the column number (i.e. column G).

how to delete infinite columns in excel

➤ Press CTRL + SHIFT + RIGHT arrow to select all the columns right to your selected column.

how to delete infinite columns in excel

As a result, Excel displays the columns at the end of your sheet and the area will be marked with gray color.

➤ Go to Home > Cells > Format > Hide & Unhide > Select Hide Columns.

hide

As a result, all the selected columns will be hidden. So, now you will see only the used columns in your Excel sheet.

how to delete infinite columns in excel


3. Delete Infinite Columns by Unselecting Necessary Columns

Instead of selecting the unused columns, you can select all the columns and then unselect the used columns to delete the infinite columns.

➤ Click on the little sign at the top left corner of your Excel sheet where the row numbers and the column numbers meet.

how to delete infinite columns in excel

It selects all the columns of your dataset.

➤ Unselect the columns that you don’t want to delete by pressing CTRL and clicking on the column number.

delete all unused col.umns

➤ Right-click on any of the column headers of the selected columns.

➤ The context menu will appear.

➤ Select Delete from this context menu.

As a result, the infinite columns will be deleted. Now, you will see the last column number of your Excel datasheet is AA. That means now your Excel spreadsheet has only 27 columns.

how to delete infinite columns in excel

You may think still there are a number of unused columns but compared to the infinite number 27 is way less than that.


4. Remove Infinite Heights of the Columns

Each of the columns has 1,048,576 cells in it. Most of the time you will use only a few cells of each column. Now, I’ll show you how you can remove the infinite heights of the columns. To do that you will need to delete the infinite rows from your datasheet.

➤ Select the first row from where you want to delete the infinite height of the columns by clicking on the row number (i.e. row 18).

how to delete infinite columns in excel

➤ Press CTRL + SHIFT + DOWN arrow to select all the columns at the bottom of your selected row.

how to delete infinite columns in excel

As a result, Excel displays the rows at the bottom of your sheet and the area will be marked with gray color.

➤ Right-click on any of the row numbers and the context menu will appear.

➤ Select Delete from this context menu.

how to delete infinite columns in excel

As a result, the display will automatically return at the beginning of the sheet. You will see now that the columns don’t have infinite heights.

how to delete infinite columns in excel

The last row number of your Excel datasheet is 31. That means now your Excel spreadsheet has only 31 cells in each column.

how to delete infinite columns in excel

It’s not the conventional way of deleting columns. Removing the row height may have an impact on the infinite columns.

Read More: How to Delete Blank Columns in Excel


Download Practice Workbook


Conclusion

By following any of the above-described methods you’ll learn how to delete infinite columns in Excel. Method 2 which is removing columns by hiding will allow you to have a neat and clean datasheet. Method 1 and 3 will delete the infinite columns and you’ll have only a limited number of columns in your Excel datasheet. By following method 4 you will be able to reduce the height of the columns of your Excel worksheet.


Related Articles


<< Go Back to Delete Columns | Columns in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Prantick Bala
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

2 Comments
  1. This does not work — the columns are still there, you just have to scroll past AA to see them.

    • Hello JOEY,
      Actually, those columns have been deleted. If there were any data you would understand then. But, you got confused because all the deleted columns get replaced instantly with new ones and it happens so fast that we cannot detect it with our eyes. If you fill the first row with all columns and then apply this method, you could realize the change.
      Thanks for your feedback. Please visit our website, ExcelDemy, a one-stop Excel solution provider, to explore more.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo