要鎖定Excel中的公式，需通過保護(hù)單元格和工作表實(shí)現(xiàn)。1. 右鍵點(diǎn)擊公式所在單元格，選擇“設(shè)置單元格格式”>“保護(hù)”>勾選“鎖定”。2. 若需其他單元格可編輯，需提前解鎖這些單元格。3. 點(diǎn)擊“審閱”>“保護(hù)工作表”，設(shè)置密碼并選擇允許用戶操作的權(quán)限。4. 可選：通過“允許用戶編輯區(qū)域”功能授權(quán)特定用戶修改特定范圍。鎖定單元格僅在工作表受保護(hù)時(shí)生效，因此必須完成保護(hù)步驟才能有效防止公式被編輯。

If you want to lock a formula in Excel so it can’t be edited, the key is to protect the worksheet after setting up the right protections. Excel doesn’t have a direct "lock formula" button, but by using a combination of cell protection and sheet protection, you can make sure only the formula stays off-limits while other parts of the sheet remain editable if needed.

Protect the Cell Containing the Formula

By default, all cells in Excel are locked, but that lock only takes effect when the sheet is protected. So first, you need to make sure the cell with the formula is set to locked.

• Right-click the cell or range of cells with the formula
• Choose Format Cells
• Go to the Protection tab
• Make sure the Locked checkbox is checked (it usually is by default)

If you want other cells to remain editable, you’ll need to unlock those cells before protecting the sheet — which brings us to the next step.

Protect the Sheet to Prevent Editing

Once the correct cells are locked, you need to protect the sheet. This is what actually prevents changes to the formula.

• Go to the Review tab
• Click Protect Sheet
• Set a password (optional but recommended)
• Choose what users can still do (like selecting cells or formatting)

With the sheet protected, any attempt to edit the locked formula cell will be blocked. If you didn’t unlock other cells earlier, users won’t be able to edit those either.

Optional: Allow Editing for Specific Users

If you’re working in a shared environment, you might want to allow certain people to edit specific cells or ranges while keeping the formula locked.

• Go to Review > Allow Users to Edit Ranges
• Add ranges and assign users who can edit them
• You can still protect the sheet normally

This feature is especially useful for collaborative workbooks where only certain parts should be editable by specific users.

Locking a formula in Excel isn’t complicated, but it does require a few careful steps. The main thing to remember is that locking a cell only works when the sheet is protected. If you're sharing the file, test the protection before sending it out — it's easy to accidentally leave a formula editable or lock down too much.

基本上就這些.

以上是如何將公式鎖定在Excel中，以免編輯的詳細(xì)內(nèi)容。更多資訊請(qǐng)關(guān)注PHP中文網(wǎng)其他相關(guān)文章！