How do I lock a formula in Excel 2007?

How to Lock Cells that have Formulas in Excel (Step-by-Step)

Best Answer
Here are the steps to Lock Cells with Formulas:
  1. With the cells with formulas selected, press Control + 1 (hold the Control key and then press 1).
  2. In the format cells dialog box, select the Protection tab.
  3. Check the 'Locked' option.
  4. Click ok.

How To Lock And Protect Formulas In Excel

Related Questions

How do I lock a single cell in Excel?

How do I lock a text box in Excel 2016?

How do you unfreeze panes in Excel 2007?

How do I freeze specific cells in Excel 2007?

How do I freeze columns in Excel 2007?

How do I protect formulas in Excel but allow input?

What is the shortcut to lock formulas in Excel?

How do I freeze cells in Excel 2007?

How do I freeze both rows and columns in Excel 2007?

How do I lock certain cells in Excel 2016?

How do I lock a position in an Excel spreadsheet?

How do you unfreeze cells in Excel 2007?

How do you lock a cell in a formula?

How do I lock a column in Excel 2007?

How do I freeze the top 2 rows in Excel 2007?

How do I freeze the first two rows in Excel 2007?

How do you pause a formula in Excel?

How do I freeze a row in Excel 2007?

How do I remove formula and keep text in Excel?

How do I freeze two columns in Excel 2007?

What happens if you freeze formula?

How do I lock multiple cells in Excel?

How do I freeze multiple rows in Excel 2007?

How do I freeze rows and columns at the same time in Excel 2007?

How do I freeze a cell in an Excel formula?

How do I keep one cell constant in an Excel formula?

How do you lock cells in Excel for Mac?

Is it OK to freeze formula?

How do I lock cell values in Excel?

What is the shortcut to freeze panes in Excel 2007?

Can you lock tabs in Excel?

How do I lock an image in Excel so it doesn't move?

How do I freeze columns and rows in Excel 2007?