To remove a formula and keep the values in Excel, there are several methods you can use. Here are the steps for each method:

1. Copy and paste values:

• Select the cell or range of cells that contains the formula.
• Press Ctrl + C to copy the cells.
• Right-click on the cell or range of cells where you want to paste the values.
• Click on "Paste Values" or "Values" under "Paste Options" to paste the values.

2. Use the Paste Values option:

• Select the cell or range of cells that contains the formula.
• Click on "Copy" or press Ctrl + C.
• Click on the arrow below "Paste" in the "Home" tab.
• Click on "Paste Values" or "Values" to paste the values.

3. Use the keyboard shortcut:

• Select the cell or range of cells that contains the formula.
• Press Alt + E + S + V + Enter to paste the values.

4. Use Kutools for Excel:

• Select the cell or range of cells that contains the formula.
• Click on "To Actual" under "Kutools" to paste the values.

All of these methods will remove the formula and keep the values in Excel.