Video:Hide Information in Microsoft Excel

SHARE ON                

Transcript:Hide Information in Microsoft Excel

Hi, I'm Don Schechter for About.com Computing. Today I'm going to show you how to hide information from your worksheets in excel. In some cases, you may not want to display certain information on your spread sheet. You can simply hide information in specific rows, columns and even cells.

Hide Columns of Information in Excel

Let's open a previously written document in Excel. Here, I have some data that is in three columns. To hide columns of information, select a column at the top of the screen. Go up to the menu bar and select 'format, columns.' From here you can unhide or hide information in column. Click on it and that information will disappear.

Unhide the Information

To unhide your information, go back to format, columns and click 'unhide' or go to the top of the column bar and dragging the bolded edge to reveal the column.

Hide Rows in Excel

You can also do this with rows by selecting the row and then format, rows, hide.

Hide Specific Information in Excel

To hide specific information in cells, first select the information. Go to 'format,' and then 'cells.' In the new window under the numbers tab, select 'Custom' from the category options. In the text box provided, type three semicolons and then click 'OK.' The information will disappear.

To redisplay cell information, select the cells, go back to format, cells, and select the numbers tab. Under the category options, select 'general' and then 'OK.'

Thanks for watching. For more information, please visit us online at computing.about.com.