Hints and tips home » Excel hints and tips » Hiding Formulae in the Formula Bar

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

Added by Orok on 19th October 2006

More Excel hints and tips, like:

• bring up formatting dialog box
• Change the default location for opening and saving spreadsheets
• Transpose text