How to hide formulas in MS Excel worksheets | NowPublic News Coverage

How to hide formulas in MS Excel worksheets

by scorpion68a | November 18, 2006 at 08:52 am

2282 views | 0 Recommendations | 3 comments

Sometimes it is necessary to hide formulas from other people's eyes. It is very simple to do this, in a few steps.

0 See all footage | View Slideshow

Share: email story | add to any | | facebook | stumbleupon

recommend This comment thread is now closed

Obi-Akpere

at 09:58 on November 18th, 2006

Very helpful tip... Thanks for sharing this with us.

Edgar5 (not verified)

at 17:12 on July 19th, 2008

Two questions about hiding formulas.

1. I know how to hide formula bar. I know that by protecting cells in Excel, noone is able to see the formulas. But since those cells I hid are referrenced to another one that is not, whenever I change that one, the data of the hidden cells cannot change. Is there a way cells protected can change when I change the not hidden cell? For example:

Unhidden cell: Product 1.

Sales of Product 1: 2000

Change to Product 2 is not able. Is there a way I can do this?

2. By not protecting sheet, I can hide formula, but a user could still type F2 on the cell of the formula and still see it. Is tehere a way to not letting users to type F2?

Edgar.