OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

Hide cell values

You can hide cell values from the casual user by an undocumented feature in Excel. Select the cells. Click on format cells. In the format tab select Custom and type in there semi-colon's (;;;) and click on OK. That should do it. The cell contents will be hidden. It will be visible only in the formula bar when the cell is activated.
 

Copyright 1999-2014 (c) Shyam Pillai. All rights reserved.