How to Remove Column Headers in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for simple ways to remove column headers in Excel, this article will serve the purpose. While working with Excel worksheets, sometimes we need to remove column headers from our worksheets. So, let’s start with this article and learn all the steps to remove column headers in Excel.


What Are Column Headers?

In Microsoft Excel, both column and row headers are added to the worksheet by default. The column headers are situated at the top of the worksheet and the row is grey-colored. The column headers are denoted by alphabet (A, B, C,…).


How to Remove Column Headers in Excel: 2 Ways

In this article, we are going to learn 2 simple, and easy-to-use methods to remove column headers in Excel.
We have used Microsoft Excel 365 version for this article, you can use any other version according to your convenience.
In the following dataset, we have the Sales Data of “ABC” Company. Now, we will remove column headers from the worksheet.

how to remove column headers in excel


1. Using Excel Options to Remove Column Headers

Using Excel Options is one of the easiest ways to remove column headers in Excel. Let’s follow the steps mentioned below.

Steps:

  • Firstly, go to the Files tab from the Ribbon.

how to remove column headers in excel Using Excel Options to Remove Column Headers

After that, you will see the following image on your screen.

how to remove column headers in excel Using Excel Options to Remove Column Headers

  • Afterward, select the Options tab.

After selecting the Options tab, the following dialogue box will open, named Excel Options.

Note: You can press the ALT+F+T keyboard shortcut to directly open the Excel Options dialogue box from your worksheet.

  • From the Excel Options dialogue box, click on Advanced.

how to remove column headers in excel Using Excel Options to Remove Column Headers

After that, the following image will be available on your worksheet.

  • Now, scroll down until you find Display options for this worksheet as marked in the picture given below.

  • Afterward, uncheck the box of Show row and column headers.
  • Then, press Ok.

how to remove column headers in excel Using Excel Options to Remove Column Headers

Consequently, you will see those column headers are removed from your worksheet.

Read More: How to Change Column Headings in Excel


2. Utilizing View Tab to Remove Column Headers

By utilizing View tab, we can remove the column headers in a quite efficient way. Let’s follow the steps given below to do this.

Steps:

  • Firstly, go to the View tab from the ribbon.

how to remove column headers in excel Utilizing View Tab to Remove Column Headers

  • After that, uncheck the box of Headings, as marked in the following image.

how to remove column headers in excel Utilizing View Tab to Remove Column Headers

There you go! You will see that your column headers are removed from your worksheet like in the following picture.

Read More: How to Rename Column in Excel


How to Remove Column Headers from Table in Excel

In Excel, when we use a table to represent our data, Excel automatically adds the headers to the table. But sometimes we need to keep the table while removing the column headers of the table.
In the following image, we can see the Sales Data of “ABC” Company shown in table format.

how to remove column headers in excel How to Remove Column Headers from Table in Excel

So, let’s learn the steps to remove column headers from a table.

Steps:

  • Firstly, select the table as marked in the following picture.

how to remove column headers in excel How to Remove Column Headers from Table in Excel

After that, the Table Design tab will be available on the ribbon

  • Now, click on the Table Design tab.

how to remove column headers in excel How to Remove Column Headers from Table in Excel

Afterward, you will see the following image on your screen.

  • Now, uncheck the box of Header Row from the Table Style Options group.

Consequently, you will see that the column headers from your table are removed.

how to remove column headers in excel How to Remove Column Headers from Table in Excel

Read More: How to Remove Column1 and Column2 in Excel


Practice Section

For doing practice, we have provided a practice section in each worksheet on the right side. Please do it by yourself.

how to remove column headers in excel


Download Practice Workbook


Conclusion

Finally, we have to the very end of the article. I sincerely hope that this article was able to guide you to learn the steps to remove column headers in Excel. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. Happy learning!


Related Articles


<< Go Back to Rows and Columns Headings | Rows and 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.
Zahid Hasan
Zahid Hasan

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo