Yes, there is a way to remove the cell reference in a sheet at once. You can use the "Find and Replace" feature in Excel to replace all the cell references with their actual values.

Here are the steps to do it:

1. Select all the cells that contain formulas with cell references.
2. Press "Ctrl + H" to open the "Find and Replace" dialog box.
3. In the "Find what" field, type the
   Code:

   $A

   .
4. Leave the "Replace with" field blank.
5. Click on "Replace All" button.
6. Excel will replace all the cell references with their actual values.

Note: This will replace all the cell references in the selected cells with their actual values. Make sure you have a backup of your original data before doing this, as it will permanently remove the cell references.