• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to unhide rows/columns or all hidden rows/columns in Excel?

0 Comments

How to unhide rows/columns or all hidden rows/columns in Excel? In Excel, if you are working with a spreadsheet that contains sensitive or private data, you may have hidden certain rows and columns. Conversely, you may also have hidden unimportant information or data that you don’t want others to see in your own spreadsheet.
In either case, before updating or examining the data in the spreadsheet, you’ll need to unhide these hidden rows and columns. This article will walk you through the steps on how to unhide rows and columns in Excel, as well as how to unhide all rows and columns if they are all hidden.
This tutorial is applicable to Excel 2007 to 2016, and can also guide you on how to do it in other versions of Excel. Before we get started, let’s first take a look at how to find hidden rows and columns in Excel.

How to Find Hidden Rows and Columns

To identify a concealed row or column in a spreadsheet, observe the lines separating each row and column. If the lines are green or double, it indicates the presence of a hidden row or column.

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

Additionally, if there are columns with missing letters or rows that lack numbers, there may be hidden rows and columns in the spreadsheet.

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

How to Unhide Column in Excel

To unhide a particular column, you can right-click on the double line which shows the hidden column and then choose “unhide”.

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

How to Unhide Row in Excel

To unhide a row, you can right-click on the double line indicated in green (or a different color based on user settings) and choose the “unhide” option.

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

How to Unhide all Hidden Rows and Columns in the Home Tab

To reveal all rows that are hidden, press Ctrl+A to select all rows and columns. Go to the Home tab, locate the “Cells” section, and click the arrow next to “Format”.

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

Hover over “Hide and Unhide” under the “Visibility” option, and select “Unhide Rows”.

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

To unhide all hidden columns, repeat the same process but select “Unhide Columns” instead.

How to Unhide all Rows and Columns at Once with VBA Macro

If you find working with a massive spreadsheet cumbersome, the methods we have just discussed can be time-consuming. To simplify the process of unhiding rows and columns, you can use VBA (Visual Basic for Applications) code. Running VBA code in Excel is simple:

1. Press Alt + F11 (Option + F11 for Mac) to access the VBE (Visual Basic editor)

How to unhide rows/columns or all hidden rows/columns in Excel?

How to unhide rows/columns or all hidden rows/columns in Excel?

2. Right-click on your current workbook and select “Insert”

3. Hover over “Module” and click to insert a new module.

unhide rowscolumns 10Paste this code into the editor:

Sub UnhideAllRowsAndColumns()
Cells.EntireColumn.Hidden = False
Cells.EntireRow.Hidden = False
End Sub

After closing the dialogue, return to your worksheet and proceed to run the VBA macro.
Press Alt + F8 and a window like this will appear.

unhide rowscolumns 11
Expand the window and click “run”.

unhide rowscolumns 12After running the macro, all rows and columns should now be displayed.

unhide rowscolumns 13Conclusion

In this article, we have demonstrated the steps for unhiding rows and columns in Excel.
We discussed how to unhide a single row or column, unhide all columns, and unhide all rows.
Additionally, we explored how to unhide rows and columns simultaneously using Excel VBE (Visual Basic Editor).
If you found this article helpful, please feel free to share it with your friends and family.

Rate this post
31
285 Views
6 Ways to Fix The File Is Corrupted and Cannot Be Opened Error in Excel and WordPrev6 Ways to Fix The File Is Corrupted and Cannot Be Opened Error in Excel and WordApril 13, 2023
What is a Gantt Chart? An Evergreen Tool That Has Never Gone Out of StyleApril 13, 2023What is a Gantt Chart? An Evergreen Tool That Has Never Gone Out of StyleNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Kaspersky Internet Security 2021 1 year 1 device key Global Kaspersky Internet Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $24.00
Products
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Project Professional 2021 Microsoft Project Professional 2021 - 1 PC $13.00
  • Microsoft Project 2019 Professional Key Global Microsoft Project 2019 Professional - 5 PC
    Rated 4.97 out of 5
    $12.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
  • SQL Server 2014 Standard SQL Server 2014 Standard $20.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Windows 10 Pro N Key Global Windows 10 Pro N Key Global
    Rated 4.83 out of 5
    $10.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.