How to Unhide columns in Excel (& everything else)!
Wondering how to unhide columns in Excel?
Need to unhide columns in Excel? What about whole workbooks, individual cells and even formulas? Confused about why it’s important to locate and unhide all data in Excel? If you answered yes, even once, then this article is for you. I have spent so much time pulling my hair out, working on a spreadsheet, trying to find the reason for an error only to discover that hidden columns in Excel was at fault! I have spoken to and received a lot of input from other experts. I am not alone. Hidden data in Excel is frustrating, especially when you have inherited a workbook from a previous employee. It’s also sometimes tricky to unhide. There are many reasons someone may hide data in excel spreadsheets. The most common reason is to provide a clean presentation of data to your audience, without any unnecessary information cluttering up your visual. Sometimes you simply want to hide sensitive or private data in an Excel spreadsheet.What types of data can you hide and unhide in Excel?
You can hide columns and rows in Excel, as well as individual cells and entire worksheets. Those can hold a lot of information. Here is a list of some of the types of data you can hide:- Comments
- Formulas
- Numbers
- Hyperlinks
- Dates
Why should you unhide columns in Excel?
Before you can unhide columns in Excel you must first find them. You have to do the same thing before you unhide rows in Excel. This is an important step, especially when inheriting spreadsheets and verifying final data. Read more about why finding hidden data is important, and some methods to do just that. Hiding rows and columns in Excel does not delete the data or the formulas within them and sometimes that can come back to haunt you. What if someone forgets to unhide rows in Excel or delete hidden data from a master spreadsheet before its finalised? Such as when purchase agreements are prepared. Often they contain an Excel spreadsheet detailing multiple products and their respective data. Imagine you have a Product spreadsheet, showing all twenty of your products and their commercial pricing options:

How to unhide rows in Excel, and everything else!
There are a couple of different ways to unhide all data in excel. Each solution gives you the same final result, but most take several steps to accomplish and not all solutions apply to all types of data. Some data types have different methods of unhiding. To unhide rows in Excel you follow the same process as to unhide columns in Excel, but keyboard shortcuts are different. Unhiding sheets and workbooks are different still. What about the white text on white background in Excel trick?! We recognized a need for an easy, all inclusive tool. So we built an entire toolbox of RPA Bots to fill the void:

