how to remove references formula while keeping formatting and vaulues
Delete Values But Keep Formulas. Reset An Excel Worksheet.
Remove All Formulas from an excel sheet and Keep Values (using Shortcuts)
How to keep formula cell reference constant in Excel
Remove Formula but keep the data in Excel (2 Really Simple Ways)
Excel Hack: Copy Formula Without Changing Cell References (or Without File References)
Excel Quick Tip: Absolute References with the F4 Key