Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2010, 10:58 AM
markg2 markg2 is offline Protect formula in cell? Windows 7 Protect formula in cell? Office 2007
Expert
Protect formula in cell?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 336
markg2 is on a distinguished road
Default Protect formula in cell?

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???
  1. In the worksheet, select the cells that contain the formulas that you want to hide.
  2. On the Home tab, in the Cells group, click Format, and then click Format Cells.
  1. On the Protection tab, select the Hidden check box, and then click OK.

Reply With Quote
  #2  
Old 05-24-2010, 11:12 AM
Kimberly Kimberly is offline Protect formula in cell? Windows 7 Protect formula in cell? Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Two things have to be in place to protect a cell... The cell must be locked and then sheet protection must be turned on.

Worksheet cells are locked by default, so you need to unlock the ones that don't have formulas. You can select the entire worksheet and unlock them and then select the cells that contain formulas and lock them back. (Or you can Find & Select Constants and unlock them, but this won't unlock empty cells.)

To Unlock or Lock, go to the Format Cells and on the Protection tab, uncheck (or check) Locked.

Now when you protect the sheet, only the cells that are "locked" are protected from being edited.

To protect the sheet, right-click on the worksheet tab and choose protect Sheet. check any boxes that you want users to be allowed to do. There is no need to set a password unless you are concerned about malice. Click OK.
Reply With Quote
  #3  
Old 05-24-2010, 11:16 AM
markg2 markg2 is offline Protect formula in cell? Windows 7 Protect formula in cell? Office 2007
Expert
Protect formula in cell?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 336
markg2 is on a distinguished road
Default

Very clear explanation Kimberly, but one question before I get started.

You say that by default a spreadsheet's cells are all locked. Dumb question. If all cells are locked, then how can anyone (including me) open a brand new sheet and enter anything in any cell? Doesn't 'locked' mean keep out?
Reply With Quote
  #4  
Old 05-24-2010, 11:23 AM
Kimberly Kimberly is offline Protect formula in cell? Windows 7 Protect formula in cell? Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

It is like having all the doors to your house locked but not shut. Locked or unlocked... doesn't matter, everyone can walk right in.

Turning on sheet protection is like shutting all the doors at the same time, and once the doors are shut, people can only walk in through doors that are unlocked.
Reply With Quote
  #5  
Old 05-24-2010, 11:50 AM
markg2 markg2 is offline Protect formula in cell? Windows 7 Protect formula in cell? Office 2007
Expert
Protect formula in cell?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 336
markg2 is on a distinguished road
Default

You should be a school teacher :-)!

Thanks.

Mark
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect formula in cell? 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
Protect formula in cell? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft