|
INTERVIEW QUESTIONS
MICROSOFT OFFICE
MICROSOFT EXCEL
DETAILS
Question: 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.
Answer: Every cell has two key attributes: Locked and Hidden. By default, all cells are locked, but they are not hidden. Furthermore, the Locked and Hidden attributes come into play only when the worksheet is protected. In order to allow a particular cell to be changed when the worksheet is protected, you must unlock that cell.
|
|
|
Category |
Microsoft Excel Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8006 users |
Added on |
9/24/2012 4:53:25 AM |
Views |
68853 |
Rate it! |
|
|
Question:
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.
Answer:
Every cell has two key attributes: Locked and Hidden. By default, all cells are locked, but they are not hidden. Furthermore, the Locked and Hidden attributes come into play only when the worksheet is protected. In order to allow a particular cell to be changed when the worksheet is protected, you must unlock that cell. Source: CoolInterview.com
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 |
|
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
|
|
Why does Excel have two macro languages?
|
View Answer
|
|
Why does Excel have two macro languages?
|
View Answer
|
|
Why does Excel have two macro languages?
|
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
|