Clear everything but the Excel formulas: Here’s how

Let's say you want to clear a worksheet of its data but keep the formulas intact. There's an easy way to do that. Here's what you should do: Press F5. Click Special. Click the button beside Constants. Make sure all the boxes are checked under Formulas. Click OK. Press Delete.