|
Re: How to hide the formula in formula bar?
Hi Learner,
Right-click on the cell with the formula you want hidden and choose Format Cell..
On the protection tab, check the box for 'Hidden' and 'Locked'. You then must protect the worksheet, so be sure to unlock any cells you still want to be able to edit first.
__________________
- Paul
Click here to read the Forum Rules
To give a virtual "pat on the back" click the icon in the gray toolbar from that user's post.
To report abuse, spam or offensive posts, please click the icon.
|