Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 344
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
 



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 06:29 AM.


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