How to Unhide All Rows and Columns in Excel Office 365?
Tags: kutoolsexceltutorial, stepstounhideallrows, kutools
Published: 2020-10-30 07:15:41

---
title: How to Unhide All Rows and Columns in Excel Office 365?
published: true
date: 2020-10-29 12:39:21 UTC
tags: KutoolsExcelTutorial,StepstoUnhideAllRows,Kutools
canonical_url: https://geekexcel.com/how-to-unhide-all-rows-and-columns-in-excel-office-365/
---

In this article, we are going to see how to **Unhide All Rows and Columns 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.
## Unhide All Rows and Columns:

Here, we will provide the steps to [unhide all hidden rows](https://geekexcel.com/how-to-unhide-row-in-microsoft-excel-365/) and columns of the active/current [worksheet](https://geekexcel.com/how-to-hide-or-unhide-workbooks-and-sheets-in-excel-office-365/) with a single click. Let’s see them below!!

- You need to open the worksheet that contains **hidden rows or columns**.
- In the below image, we have shown the hidden rows and columns of a worksheet as an example.

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

- Now, go to the **Kutools Tab, select** the **Show**  **& Hide** option, then **choose** the **Unhide all ranges** option from the drop-down list.

![Select unhide all ranges option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-unhide-all-ranges-option.png)<figcaption id="caption-attachment-16376">Select unhide all ranges option</figcaption>

- After selecting the **Unhide all ranges** option, the hidden ranges will be displayed as shown in the below screenshot.

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

The above steps can make you understand how to show all hidden ranges in an Excel spreadsheet with the help of Kutools function.

### Note:

- This option supports one level of **Undo** operation.
- You need press ( **CTRL + Z** ) to immediately restore the action.

<!--[if lt IE 9]><script>document.createElement('video');</script><![endif]--><video id="video-16372-1" width="770" height="389" loop="1" autoplay="1" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Record-1.mp4?_=1"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Record-1.mp4">https://geekexcel.com/wp-content/uploads/2020/10/Record-1.mp4</a></video>

## Verdict:

In the above article, you can clearly understand the steps to **Unhide All Rows and Columns in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Toggle All Hidden Columns to be Visible or Invisible in Excel 365!!](https://geekexcel.com/toggle-all-hidden-columns-to-be-visible-or-invisible-in-excel-365/)
- [Unhide All Hidden Workbook Windows with One Click in Excel 365!!](https://geekexcel.com/unhide-all-hidden-workbook-windows-with-one-click-in-excel-365/)
- [How to Delete All Hidden Worksheets with One Click in Excel 365?](https://geekexcel.com/how-to-delete-all-hidden-worksheets-with-one-click-in-excel-365/)
- [How to Filter Cells with Strikethrough in a Specific Column with One Click?](https://geekexcel.com/how-to-filter-cells-with-strikethrough-in-a-specific-column-with-one-click/)