How to Hide Cell Contents
- 1). Open the Excel worksheet that you like to work with.
- 2). Choose the range of cells that you like to hide with your mouse. On the "Format" menu, choose "Cells."
- 3). Click on the Number tab. Choose "Custom" from the Category list. In the Type box, replace the existing data with three semicolons (;;;). Your data in Excel spreadsheet will now be hidden.
Source...