Skip to content

Unhide All Rows and Columns in Excel

This article is short and to the point. You will learn how to unhide all rows and columns in Excel.

Three Simple Steps

Here are the steps you can take to unhide all rows and columns in Excel.

  1. Select all cells
  2. Go to Format Hide & Unhide > Unhide Rows
  3. Go to Format Hide & Unhide > Unhide Columns

And that’s all there is to it! Keep reading to see each step in detail.

1 – Select All Cells

Start by selecting all the cells in your worksheet. You can do this by clicking on the triangle icon near the top left corner.

You can also use the keyboard shortcut CTRL + A.

2 – Unhide the Rows

To unhide all the rows, use the Excel Ribbon and go to Format Hide & Unhide > Unhide Rows.

All the rows should now be visible.

3 – Unhide the Columns

To unhide all the columns, use the Excel Ribbon and go to Format Hide & Unhide > Unhide Columns.

All the columns should now be visible.

And that is how to can quickly unhide all rows and columns in Excel.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top