How to Hide Row and Column Headings in Excel (2 Suitable Ways)

When using Microsoft Excel, sometimes we need to hide row and column headings to represent our dataset. This is a very basic Excel operation. Are you having trouble hiding the row and column headings in Excel? This article will help to learn how to hide row and column headings in Excel in 2 suitable ways. Let’s get started!


Download Practice Workbook

You can download the Excel workbook from here.


2 Suitable Ways to Hide Row and Column Headings in Excel

There are 2 ways to hide row and column headings in Excel. One of them is using the View tab and another one is using the Excel Options window. Both ways are very easy and efficient to do the task. Now we will learn how to hide row and column headings in these 2 ways.


1. Use of View Tab to Hide Row and Column Headings in Excel

This method is quicker and easier than the second method. Suppose, you have a dataset like the following figure and you want to hide row and column headings for the dataset. In order to hide row and column headings by using the View tab, follow the steps below.

Use of View Tab to Hide Row and Column Headings in Excel

Steps:

  • First of all, click on the View tab from your ribbon.

Use of View Tab to Hide Row and Column Headings in Excel

  • After that, uncheck the Headings option like the image below.

Use of View Tab to Hide Row and Column Headings in Excel

  • As a result, you will see that your row and column headings are hidden from your worksheet as shown below.

Read More: How to Create Excel Table with Row and Column Headers


2. Hide Row and Column Headings from Excel Options Window

We can also hide row and column headings from the Excel Options window. This method is also an easy and efficient one to do the task. Suppose, we have a dataset like an image below and we want to hide the headings from the Excel Options window. Follow the steps below to hide the headings from Excel Options Window.

Steps:

  • First, click on the File Tab from your ribbon as shown below.

Hide Row and Column Headings in Excel from Excel Options Window

  • Then, click on the Options like the image below.

Hide Row and Column Headings in Excel from Excel Options Window

  • As a result, Excel Options window will pop up on your screen like the below one.

Hide Row and Column Headings in Excel from Excel Options Window

  • After that, click on the Advanced option and scroll down your screen until you find the Display option for this worksheet menu like the following image.

Hide Row and Column Headings in Excel from Excel Options Window

  • Furthermore, uncheck the Show row and column header option as shown below.

  • Hence, click OK.

  • As a result, you will now see that your row and column headings are hidden from your worksheet like the image below.

Read More: How to Promote a Row to a Column Header in Excel (2 Ways)


How to Unhide Row and Column Headings in Excel

After hiding row and column headings, if we want to unhide the headings in Excel, we can do it like the above-described methods as well. Suppose, we have a dataset like the following figure and we want to unhide the row and column headings for the dataset. In order to unhide row and column headings, we have to follow the steps below.

How to Unhide Row and Column Headings in Excel

Steps:

  • To start with, click on the View tab from your ribbon.

How to Unhide Row and Column Headings in Excel

  • After that, check the Headings option like the image below.

How to Unhide Row and Column Headings in Excel

  • As a result, you will see that your row and column headings are unhidden from your worksheet like the image below.

Read More: How to Remove Column1 and Column2 in Excel (4 Easy Methods)


Things to Remember

  • First of all, If you want to be really quick and efficient in using Excel, then Using the View tab method will be the best option for you to hide the headings.
  • Moreover, you can also unhide row and column headings using the above-described methods.

Conclusion

Hence, follow the above-described methods. Thus, you can easily learn how to hide row and column headings. Hope this will be helpful. Follow the ExcelDemy website for more articles like this. Don’t forget to drop your comments, suggestions, or queries in the comment section below.


Related Articles 

Md. Asaduzzaman

Md. Asaduzzaman

Hello! I am Md. Asaduzzaman. Currently, I am working as an Excel and VBA Content Developer and I will be posting my articles related to this here. I graduated from Bangladesh University of Science and Technology(BUET) in 2022. I completed my BSc in Naval Architecture and Marine Engineering. I like to solve real-life problems in Microsoft Excel and share the solutions through articles. I post here regularly. Hope you find the articles helpful.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo