Question about Microsoft Excel for PC

3 Answers

How to protect a single cell in excel from modification

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

Posted by on

3 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 143 Answers

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

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Yes it was helpful

Posted on Apr 24, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Expert
  • 55 Answers

You have first to protect the whole workseet with a password and then unprotect all except the single cell.

Posted on May 23, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

6 Answers

How do I unlock an excel spreadsheet which has password protection (lost). I am using Mac Excel not Windows


A) Open document > Select edit menu > choose select all > then choose copy from edit menu.
Open new document > edit menu> paste.
Select tools menu> choose options> window opens with options. Select form different tabs the edit tab> make sure that al desired boxes are selected.
Select save tab>choose and mark box>ask about properties
accept or Apply options and close.
Save new document different name. When saving it should ask if you want to save properties> choose not save. Maybe it asks if you want to modify properties> choose yes> select box archive amongst read only, hidden or archive.
If this does not work.
B)There are many 3rd party utilities which claim to reset forgotten word password:
The program that I recommend is the Excel Password Recovery 5.0 It recovers/removes the "Password to Open" and "Password to Edit" for you to view and edit the document freely.
http://www.recoverlostpassword.com/products/excelpasswordrecovery.html

May 06, 2010 | Microsoft EXCEL MAC UPGRADE 2008 Upgrade...

1 Answer

MS EXCEL


Click on the space above the first row header and on the left of the first column header. All cells on the sheet are selected now. Ctrl 1 to open the format cells dialog. On the protection tab uncheck locked.
After you do this select the cell you want to lock. Ctrl 1 to open the format cells dialog. On the protection tab check locked.

Feb 22, 2010 | Microsoft Excel for PC

1 Answer

How to protect a single cell or row in excel (single cell)


Start by selecting the entire sheet, right clicking, going to "Format Cells", "Protection" and clearing the "locked" checkbox.

Then select the rows or cells you want to protect and turn "locked" on for them.

Finally, go to Tools->Protection->Protect sheet and enable protection - setting a password might be a good idea.


Jul 04, 2009 | Microsoft Excel for PC

1 Answer

In one of my excel files, I found that the Merge Icon is Inactive, In tried all moods and options, but the Icon is still inactive, I also tried the ''format painter'' to make cells merged but it not...


This can be caused by the worksheet being protected. Check on the Review tab in the Changes group and see if the Protect Sheet or Unprotect Sheet icon is visible. If the Unprotect sheet icon is visible, then the sheet is protected and that would cause the merge cells icon to be inactive.

Apr 22, 2009 | Microsoft Excel 2003 (06503995)

2 Answers

Excel oquestion


how to remove the excel file security pass word


solution explain tel plz

Feb 09, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Tools protect workbook& sheet


Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.

Jan 23, 2009 | Steinberg Cubase Studio 4 Upgrade Version...

2 Answers

Excel


Highlight the cells you want to format. Move the mouse to the highlighted area, press the right mouse button and make sure the locked option is on under the protection tab.

Make sure protect sheet is enabled. To activate it, press the review under the menu options and select protect sheet (if its on sheet) or workbook for more than one sheet.

Sep 15, 2008 | Microsoft Excel for PC

1 Answer

Excel Coordinates don't show up in Formula Bar


Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.
  1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
  2. On the Format menu, click Cells, and then click the Protection tab.
  3. Select the Hidden check box.
  4. Click OK.
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Dec 28, 2007 | Business & Productivity Software

1 Answer

Microsoft Excel


Dear jois you can make a link from one sheet to other sheet by making a hyperlink. When you will click one cell in first sheet it would shift the sheet in the cell you will fix it.

You can follow this process:

  1. Select a cell that contains the external formula
  2. Highlight the File path and sheet name in the Formula bar, eg; 'L:\Daves\[Book2.xls]Sheet1'!
  3. Push Ctrl+C then push Enter.
  4. Select the range of cells you wish to change the reference in and go to Edit>Replace.
  5. Select in the Find what box and hold down the Backspace to ensure you do not have a space.
  6. Push Ctrl+V.
  7. Do the same in the Replace with box and then edit the file path to the new one needed.
  8. Click Replace All
if that has helped you please press 'fixya'

Nov 29, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

708 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...