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: