Change Formulas to Values and Change Relative to Absolute References in Excel
This tutorial shows you how to change formulas to values (F2, F9). If batch is needed, use copy, paste special (values). To change form relative to absolute use F4 on the formula or search replace. (Watch the video for more details).