When you create a worksheet, it sometimes contains columns and rows of data that aren’t relevant for every review or for every use of the worksheet, even though they’re important in various analyses. You can hide these columns and rows from view when they’re not needed and reveal them again when you or someone else wants to review or work with them.
To make sure that you don’t accidentally distribute a workbook that contains information you don’t want to share with others, make sure there are no hidden rows or columns in your final version of the workbook. To check for hidden rows or columns, run the Document Inspector by pointing to Prepare on the Office menu and clicking Inspect Document in the gallery.