Hiding Sensitive Worksheet Data. In addition to protecting locked cells from editing changes when the worksheet is protected, you can also ensure that their contents do not show up on the Formula bar when their cells contain the cell pointer.

Password-Protect a Worksheet from Viewing. Keep prying eyes from viewing a worksheet, unless they have the password. With the aid of some Excel VBA code placed the Private module of the workbook object, you can protect a worksheet from viewing by anyone w

Lifewire / Adrian Mangel. Spreadsheets programs can also perform calculations on the data using formulas.To help make it easier to find and read the information in a worksheet, Excel has a number of formatting features that can be applied to individual ce