SOLVED

Delete formula

Copper Contributor

How do I delete a formula in a column that I no longer want.  Delete does not work.

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

@sfa0277gmailcom 

To delete a formula in a column, you can follow these steps:

  1. Select the range of cells that contain the formula you want to delete.
  2. Press F2 to enter edit mode.
  3. Press F9 to switch to formula view.
  4. Press the Delete key to delete the formula.
  5. Press Esc to exit edit mode.

If you want to delete the formula in all cells in a column, you can follow these steps:

  1. Select the column that contains the formula you want to delete.
  2. Press Ctrl+A to select all cells in the column.
  3. Follow steps 2-5 from the previous solution.

If you are unable to delete the formula by pressing Delete, it is possible that the cell is protected.

To unprotect the cell, follow these steps:

  1. Right-click the cell that contains the formula and select "Format Cells" from the context menu.
  2. In the "Protection" tab, uncheck the box next to "Locked".
  3. Click "OK" to apply the changes.

Once the cell is unprotected, you should be able to delete the formula using the steps above.

 

If none of these steps help you, I recommend adding more information to your topic. Information such as Excel version, operating system, storage medium, file extension, etc.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

The text was created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

@NikolinoDE 

thank you that was very helpful and solved the problem

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@sfa0277gmailcom 

To delete a formula in a column, you can follow these steps:

  1. Select the range of cells that contain the formula you want to delete.
  2. Press F2 to enter edit mode.
  3. Press F9 to switch to formula view.
  4. Press the Delete key to delete the formula.
  5. Press Esc to exit edit mode.

If you want to delete the formula in all cells in a column, you can follow these steps:

  1. Select the column that contains the formula you want to delete.
  2. Press Ctrl+A to select all cells in the column.
  3. Follow steps 2-5 from the previous solution.

If you are unable to delete the formula by pressing Delete, it is possible that the cell is protected.

To unprotect the cell, follow these steps:

  1. Right-click the cell that contains the formula and select "Format Cells" from the context menu.
  2. In the "Protection" tab, uncheck the box next to "Locked".
  3. Click "OK" to apply the changes.

Once the cell is unprotected, you should be able to delete the formula using the steps above.

 

If none of these steps help you, I recommend adding more information to your topic. Information such as Excel version, operating system, storage medium, file extension, etc.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

 

The text was created with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

View solution in original post