Question about Microsoft Excel for PC
I need to protect a single cell in excel sheet from modification, Other cell i need to edit, Pls if Any one is there to clarify my doubt regarding this reply soon
Found on the internet and it seems to work:
The default setting for each cell is for them to start locked. So, you first need to highlight ALL cells in the sheet, right click, choose format, go to the Protection tab and take the tick out of the Locked box.
Now no cells are locked.
Now you need to select the one cell you want locking. Right click, choose format cells, Protection tab and then put a tick into the Locked box.
Locking the cells does not take place until you have locked the sheet. So go to Tools, Protection and Protect Sheet. Add a password of your choosing, and put a tick into every option available to you, EXCEPT the very top option. "Select locked cells" should NOT have a tick in it.
OK that to confirm, and hey presto, that cell can no longer be selected, edited or erased unless you unprotect the sheet by entering the password you chose.
Posted on May 23, 2008
Yes it was helpful
Posted on Apr 24, 2009
You have first to protect the whole workseet with a password and then unprotect all except the single cell.
Posted on May 23, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 14, 2011 | Computers & Internet
Jan 30, 2011 | Microsoft Excel for PC
May 06, 2010 | Microsoft EXCEL MAC UPGRADE 2008 Upgrade...
Feb 22, 2010 | Microsoft Excel for PC
Jul 04, 2009 | Microsoft Excel for PC
Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...
Sep 15, 2008 | Microsoft Excel for PC
Jun 16, 2008 | Excel (SS8SATAS5128400R)
Dec 28, 2007 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
714 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: