Here's a nifty way to delete all values entered into a workbook while keeping the formulas.

• Open the Excel worksheet containing the values and formulas.
• Hit "Ctrl G", that will bring up the Go To dialog box

• Click on "Special"
Average:
4
I Averaged: 4 | 2 votes

So have you ever had your F2 editing button stop working? (I use mine a lot for editing cells in Excel). For the longest time mine had stopped working and well I had just given up on it. Now I've realized that there is an F Lock key so I just pressed it again and there ya go, my F2 is working again!! Woot!