Can I lock cells such that only specific users can modify them? - Yes, but it requires Excel 2002. - Microsoft Excel Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

MICROSOFT OFFICE

MICROSOFT EXCEL

DETAILS

Question: Can I lock cells such that only specific users can modify them?

Answer: Yes, but it requires Excel 2002.

Category	Microsoft Excel Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7884 users
Added on	9/24/2012 5:03:03 AM
Views	67753
Rate it!

Question: Can I lock cells such that only specific users can modify them?

Answer:

Yes, but it requires Excel 2002. Source: CoolInterview.com

Hi

The same is also possible in excel 2003 or excel 2007,There is a option "Allow users to edit ranges" can be used for this purpose.

Regards
Rajender Soni Source: CoolInterview.com

Answered by: Rajender Soni | Date: 7/15/2010 |

Contact Rajender Soni

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Why aren't these options available in earlier versions of Excel?	View Answer
	Why aren't these options available in earlier versions of Excel?	View Answer
	Why aren't these options available in earlier versions of Excel?	View Answer
	How is worksheet protection different in Excel 2002?	View Answer
	I protected my worksheet, but now I can't even do simple things like sorting a range. What's wrong?	View Answer
	I made some cells hidden and then protected the worksheet. But I can still see them. What's wrong?	View Answer
	How do I unlock a cell?	View Answer
	I tried the procedure outlined above, and it doesn't let me change any cells! I only want to protect some of the cells, not all of them.	View Answer
	How do I protect a worksheet?	View Answer
	How can I print the workbook's full path and filename in a page header?	View Answer
	Is it possible to change the color and font of the sheet tabs?	View Answer
	How can I increase the number of rows in a worksheet?	View Answer
	How can I increase the number of columns in a worksheet?	View Answer
	How can I add a drop-down list to a cell so the user can choose a value from the list?	View Answer
	Is there a utility that will convert my Excel application into a stand-alone EXE file?	View Answer
	Is there a way to automatically convert 1-2-3 or Quattro Pro macros to VBA macros?	View Answer
	Is it possible to call a VBA procedure from an Excel 4.0 XLM macro?	View Answer
	I'm looking for a third-party utility that will convert my Excel 4 macros to VBA. Am I out of luck?	View Answer
	Do XLM macros written for previous versions of Excel work in Excel 97 and Excel 2000?	View Answer
	I need to distribute a workbook to someone who still uses Excel 4. Is there a way to have Excel 97 or Excel 2000 record my actions to an XLM macro?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Microsoft Excel Interview Questions & Answers - Exam Mode / Learning Mode