I have a spreadsheet which requires only one value to be entered into cell C2 in order to re-calculate all the other cells. How can I keep the cursor from leaving cell C2 after entering a value into it and preventing the user from altering any other cells?
我有一个电子表格，只需要将一个值输入到单元格C2中，以便重新计算所有其他单元格。如何在向其中输入值并防止用户更改任何其他单元格后，保持光标不离开单元格C2？
1 个解决方案
#1
2
Unlock the cell(s) you want users to be able to change. Protect the sheet, and uncheck the "allow users to select locked cells" checkbox.
解锁您希望用户能够更改的单元格。保护工作表，并取消选中“允许用户选择锁定的单元格”复选框。
#1
2
Unlock the cell(s) you want users to be able to change. Protect the sheet, and uncheck the "allow users to select locked cells" checkbox.
解锁您希望用户能够更改的单元格。保护工作表，并取消选中“允许用户选择锁定的单元格”复选框。