Protect formula in cell?

markg2 · #1 05-24-2010, 10:58 AM

Office XP

My goal is to protect cells of a spreadsheet that hold formulas so as to not inadvertently overwrite same with data. Help is not helpful. I'm finding how to protect an entire sheet and then allow exclusions or...

The nearest I find is???

In the worksheet, select the cells that contain the formulas that you want to hide.
On the Home tab, in the Cells group, click Format, and then click Format Cells.

On the Protection tab, select the Hidden check box, and then click OK.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
Protect signature image in word document	carolind	Drawing and Graphics	0	02-16-2010 06:50 PM
password protect excel file?	Dawg751	Excel	2	01-28-2010 06:23 AM
Help for formula	dehann	Excel	5	05-01-2009 10:44 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM