# How To Hide & Unhide Columns in Excel | Capterra | Capterra > Are you missing data in your Excel spreadsheet? It's likely that the data wasn't deleted but hidden instead. Here's how to unhide columns in Excel. Source: https://www.capterra.com/resources/how-to-unhide-columns-in-excel --- IT & Software Development # How To Unhide Columns in Excel By Sydney Chamberlain Sydney Chamberlain Sydney Chamberlain is a content writer specializing in business, marketing, and technology topics. With extensive experience in nonprofit organizations, she ... [See bio & all articles](https://www.capterra.com/resources/author/schamberlain/) Published July 18, 2023 4 min read Table of Contents - [What are hidden rows and columns in Excel?](#what-are-hidden-rows-and-columns-in-excel)  - [How to unhide data in Excel](#how-to-unhide-data-in-excel)  - [Considerations when hiding rows and columns in Excel](#considerations-when-hiding-rows-and-columns-in-excel) ## Follow these simple steps to quickly unhide columns (and rows) in Excel. Maybe you learned how to hide data in Excel a long time ago, but now you need to reveal it. Or perhaps you clicked something by accident, and your rows or columns disappeared. In any case, if you are trying to learn how to unhide columns in [Microsoft Excel](https://www.capterra.com/p/176574/Excel/), there's a simple way to do it.  This step-by-step guide explains how to hide and unhide rows and columns in your Excel workbook. We'll also explain some key considerations to consider when using the hide/unhide feature to conceal data. ## What are hidden rows and columns in Excel?  If you've spent time working with Excel, you know that it can quickly start to look overwhelming. Oftentimes, you need to include many data points for calculations and summaries, but you don't always need to look at those individual data points when scrolling through your worksheet. That's when hidden rows and columns come in handy. Hiding a row or column will conceal it from your view, but the data remains in your spreadsheet, allowing it to be used for formulas and calculations. Learning to hide and unhide data this way can keep your spreadsheets easy to read and conceal sensitive data that doesn't need to be on constant display, such as salary information for your employees.  ## How to unhide data in Excel  Hiding and unhiding data in Excel is easy once you know where to find your desired setting. Follow one of these methods to unhide rows or columns in your workbook (and learn how to re-hide them when you're done).  ### How to unhide columns in Excel  If you see a double-line separating two columns, one or more columns in between them have been hidden. You can unhide the column(s) by double-clicking on that line. _In the above image, column C has been hidden, indicated by a double-line[\[1\]](#sources)_ Alternatively, you can follow these steps:  1. Select the columns adjacent to the hidden column(s).  2. Right-click on your selection, then select **Unhide**. ### How to unhide rows in Excel  The easiest way to spot a hidden row in Excel is to scroll to the left of your worksheet and look for a missing number in the sequence. You can then click the double-line separating the visible numbers to show the hidden row(s). _In the above image, rows 9 through 69 have been hidden, indicated by a double-line[\[1\]](#sources)_ Alternatively, you can follow these steps:  1. Select the rows above and/or below the hidden row(s).  2. Right-click on your selection, then select **Unhide**. ### How to unhide all columns in Excel at once If you want to quickly unhide all columns or rows in Excel, follow these steps. Option 1: Click on the small triangle in the upper left corner of the table to select your entire worksheet. Right-click anywhere on your selection and select **Unhide**. _Source[\[2\]](#sources)_ Option 2: Use the keyboard shortcut Ctrl+A (Windows) or Command-A (Mac) to select the entire worksheet. Right-click anywhere on your selection and select **Unhide**. ### How to hide rows or columns in Excel  Once you have revealed the data you wanted to see, what if you want to hide it again?  1. Simply select one or more columns or rows. If you want to select non-adjacent rows or columns, hold down **Ctrl** on Windows or **Command** on Mac while clicking on them. 2. After selecting all the columns or rows you want to hide, right-click somewhere on your selection and then select **Hide**. 3. As you scroll through your workbook, you will see a double line between cells when there are hidden columns or rows. _Source[\[3\]](#sources)_ ## Considerations when hiding rows and columns in Excel The hide and unhide feature is a handy trick to know, especially if you're dealing with complicated workbooks. However, there are some important considerations to keep in mind. - **Hiding data does not make it secure**. While hiding a row or column containing sensitive information might be sufficient when you want to avoid someone looking over your shoulder and seeing the information, it doesn't protect the data from being viewed by someone who wants to look at it.  - **Delete unnecessary data**. "Out of sight, out of mind" may work for many things, but it doesn't make your overloaded spreadsheet any faster. If you no longer need data but aren't sure whether to hide it or delete it, consider saving a copy of your old workbook and starting fresh with the unneeded data removed.  - **Learn the keyboard shortcuts**. If you work in Excel frequently, learning the keyboard shortcuts for tricks like hiding and unhiding data can be very helpful. The shortcut is Ctrl+9 on a PC or Command-9 for a Mac. Getting more out of your data Want to make the most of your data and reduce the time you spend on tedious tasks like this one? Explore the latest in [spreadsheet software](https://www.capterra.com/spreadsheet-software/), [data entry software](https://www.capterra.com/data-entry-software/), and [productivity tools](https://www.capterra.com/productivity-software/) to simplify your workday and make the most of your valuable information. * * * Sources 1. [3 Ways to Hide and Unhide Columns or Rows in Excel](https://www.isumsoft.com/office/hide-or-unhide-rows-or-columns-in-excel.html), iSumSoft 2. [Copy Data or Formatting to Multiple Worksheets in Excel](https://www.teachexcel.com/excel-tutorial/2102/apply-worksheet-changes-to-all-worksheets-in-excel), Teach Excel 3. [How to Hide Cells, Rows, and Columns in Excel](https://www.howtogeek.com/218582/how-to-hide-cells-rows-and-columns-in-excel/), How-To Geek * * * ### Was this article helpful? * * * ## About the Author [### Sydney Chamberlain](https://www.capterra.com/resources/author/schamberlain/) Sydney Chamberlain is a content writer specializing in business, marketing, and technology topics. With extensive experience in nonprofit organizations, she is a frequent contributor to trusted business resources including Capterra. ### RELATED READING - [XLAs: How Experience‑Level Agreements Improve Help Desk Performance](https://www.capterra.com/resources/xlas/) - [Marketing ROI: Prioritizing Your Next Sales and Marketing CRM Investment](https://www.capterra.com/resources/marketing-roi-strategies/) - [How Integrating Email Automation With CRM Systems Boosts Customer Engagement](https://www.capterra.com/resources/integrating-email-automation-with-crm-systems/) - [ERP for Small Businesses: Do You Need It and What to Look For](https://www.capterra.com/resources/does-your-small-business-need-erp/) - [Project Management Software for Creative and Marketing Workflows](https://www.capterra.com/resources/project-management-software-creative-marketing-workflows/) - [5 Key Learning Management Software (LMS) Features With Top Products That Offer Them](https://www.capterra.com/resources/key-features-of-learning-management-system/) - [How to Choose Project Management Software With Confidence: Insights From Real Buyers](https://www.capterra.com/resources/project-management-software-buyer-insight/) - [LMS Pricing Models Explained: Hidden Costs, Plans, And Comparisons](https://www.capterra.com/resources/lms-pricing-models-guide/) - [Payroll Pricing Explained: Flat-Rate vs Per-Employee Models](https://www.capterra.com/resources/payroll-pricing-models-guide/)