Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-12-2017, 08:30 AM
melvin1942 melvin1942 is offline Windows 10 Office 2007
Novice
 
Join Date: Apr 2016
Posts: 20
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 Windows 8 Office 2016
Advanced Beginner
 
Join Date: May 2017
Posts: 75
ArviLaanemets is on a distinguished road
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 Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 819
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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
Insert Static Date when another cell is changed. evansrj Excel 5 02-04-2017 02:00 AM
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 an absolute reference in a cell bremen22 Excel 7 01-16-2014 11:06 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft