Hide and Show Column and Row Headers in the Current Worksheet!!
Tags: kutoolsexceltutorial, stepstohideandshowco, kutools
Published: 2020-10-06 08:53:50

---
title: Hide and Show Column and Row Headers in the Current Worksheet!!
published: true
date: 2020-10-05 11:49:36 UTC
tags: KutoolsExcelTutorial,StepstoHideandShowCo,Kutools
canonical_url: https://geekexcel.com/hide-and-show-column-and-row-headers-in-the-current-worksheet/
---

In this post, you will learn the steps to **Hide and Show Column and Row Headers in the Current Worksheet in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Steps to Hide and Show Column and Row Headers in the Spreadsheet:

To hide and show column and row headers in the spreadsheet, do as follows.

- If you don’t have the **Design Tab** in your Excel sheet, you need to enable it by clicking the **Worksheet Design** option under the **Kutools Plus** Tab.

![select the Worksheet Design option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/EXCEL_cJkt0ALDpj.png)<figcaption id="caption-attachment-15195">select the Worksheet Design option</figcaption>

- Now, it will add the **Design Tab**.
- You can **check** or **uncheck** the **Show Headers** option in the View section to toggle show/hide columns and row headers.

![Show Headers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-7.png)<figcaption id="caption-attachment-15204">Show Headers</figcaption>

- If you **uncheck** the **Show Headers** option, it will **hide column**  **and row headers** as shown in the below screenshot.

![Uncheck Show Headers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Uncheck-Show-Headers.png)<figcaption id="caption-attachment-15205">Uncheck Show Headers</figcaption>

- You need to **check** the **Show Headers** option, then it will **display the Column and row headers** as shown in the below image.

![Check Show Headers option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Check-Show-Headers-option.png)<figcaption id="caption-attachment-15206">Check Show Headers option</figcaption>

## Wrap-Up:

In this post, you can clearly understand the steps to **Hide and Show Column and Row Headers in the Current Worksheet in Excel Office 365** using **Kutools.** Give your  **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [How to Find the Largest Value Smaller than a Specified Number in Excel?](https://geekexcel.com/how-to-find-the-largest-value-smaller-than-a-specified-number-in-excel/)
- [How to Extract Substring Between Two Texts in Excel?](https://geekexcel.com/how-to-extract-substring-between-two-texts-in-excel/)