How to Hide & Unhide Cells in Excelby Stephanie Ellen
Microsoft Excel is powerful spreadsheet software that allows you to use up to 16,000 columns of data. With the ability to have vast amounts of data in one spreadsheet, there may be times when you just don't need to display all the data at once. For example, you may want to print just a small portion of the worksheet; hiding the cells you don't want to print will enable you to print only the cells that are unhidden. Hide and unhide cells in Excel through the Format Cells dialog box.
Select the cells you want to hide.
Click the "Format" tab and then click "Format Cells."
Click the "Number" tab.
Click "Custom" from the Category List.
Type three semicolons ";;;" into the "Type" text box and then click "OK." The cell data will be hidden.
Reopen the Format Cells dialog box.
Delete the semicolons in the Type box.
- To hide entire rows, columns or sheets, click the "Format" button on the Home tab and then click "Hide and Unhide." Click the option you would like: "Hide Rows," "Hide Columns" or "Hide sheet."
- Comstock Images/Comstock/Getty Images