Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2017, 08:30 AM
melvin1942 melvin1942 is offline Keeping a cell from being changed Windows 10 Keeping a cell from being changed Office 2007
Advanced Beginner
Keeping a cell from being changed
 
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default Keeping a cell from being changed

How can I keep a cell from being changed by other people?
Reply With Quote
  #2  
Old 07-12-2017, 01:05 PM
ArviLaanemets ArviLaanemets is offline Keeping a cell from being changed Windows 8 Keeping a cell from being changed Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

1. Select a cell/range;
2. Format - In format window select Protection tab;
3. Check Lok when you want to protect selected cell(s), uncheck when you want to allow changes. By default Lock is checked for all cells. You can also hide formulas here - formula is not displayed in edit mode;
4. Protect the worksheet.
Reply With Quote
  #3  
Old 07-12-2017, 01:11 PM
gebobs gebobs is offline Keeping a cell from being changed Windows 7 64bit Keeping a cell from being changed Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

It's a two step process. By default, all cells are locked. If there are any cells that you would like editable by others, you need to unlock them at Home:Cells:Format:Format Cells. Go to the Protection tab in this dialog and uncheck "Locked". If you do this a lot like I do, you will want to put the Lock Cell toggle button on your Quick Access Toolbar.

Next, you need to protect your sheet at Review:Changes:Protect Sheet. There are several protection options you can enable/disable. You can add a password if you want. If you don't, anyone can turn protection off. I usually don't use a password unless protection is critical. If you forget the password, sayonara worksheet. Again, if you do this a lot, you can add the toggle to the Quick Access Toolbar.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping a cell from being changed Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow FUGMAN Excel Programming 7 02-05-2017 08:37 AM
Keeping a cell from being changed Insert Static Date when another cell is changed. evansrj Excel 5 02-04-2017 02:00 AM
Keeping a cell from being changed If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting hanvyj Excel Programming 0 08-28-2015 01:15 AM
Keeping a cell from being changed Keeping an absolute reference in a cell bremen22 Excel 7 01-16-2014 11:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:12 PM.


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