Video:Hide Information in Microsoft Excelwith Don Schechter
In some cases, you may not want to display certain information on your Excel spreadsheet. You can simply hide information in specific rows, columns, and even cells. See how it's done!See Transcript
Transcript:Hide Information in Microsoft ExcelHi, 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 ExcelLet'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 InformationTo 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 ExcelYou can also do this with rows by selecting the row and then format, rows, hide.
Hide Specific Information in ExcelTo 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.
About videos are made available on an "as is" basis, subject to the User Agreement.