Tuesday, July 21, 2009

Excel Tips - Hide Formula from Being Displayed in the Formula Bar

You may want to hide the formula that you are using in your Excel from being seen by other viewers who are using your spreadsheet.
To hide the formula, you will have to protect your worksheet but before protecting, you'll have to set the cell's format.
  1. Select the cell(s) with the formula(s) you want to hide.
  2. From Home tab, click Format from Cells group and select Format Cells (for earlier Excel versions, go to Format menu and select Cells).

  3. From the Format Cells dialog box, go to the Protection tab.
  4. Select the Hidden check box (leave the Locked check box selected to protect from user changing or deleting the cell content).

  5. Click OK.

(If you want to allow entering or editing data on certain cells, select those cells and follow step 2 and 3. Then uncheck the Locked check box and click OK.)

Now you can protect your worksheet.

  1. From Home tab, click Format from Cells group and select Protect Sheet... or you can also find Protect Sheet button in the Changes group from Review tab (for earlier versions, go to Tools menu, point at Protection and select Protect Sheet...).
  2. Apply your password to protect (optional) and repeat the same password after clicking OK.

REMINDER! Password is case sensitive. To unprotect, you must type the password exactly like the one you've created. If you forgot the password then you can say good bye to your worksheet :).


No comments:

Post a Comment