User Login

Help Community Login:

ms excel tips

missb's picture

How To Remove Values but Keep Formulas in MS Excel 2007

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"
  • 4
    I Averaged: 4 | 2 votes
missb's picture

F2 Editing Button Not Working - Excel

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 Doh! so I just pressed it again and there ya go, my F2 is working again!! Woot!

F-Lock Key Tip
3.96104
I Averaged: 4 | 77 votes

Who's New

Redneck's picture
juanpabarri's picture
henta2002's picture
Vanillachinchilla's picture
versioniii's picture
xgensolutions's picture
OkwuteAgu's picture
CB_Latin's picture
GrimRapper's picture
glrobins's picture
hady's picture
Jessica Davis's picture
CRowmAN's picture
redd993's picture
Austeen Legitt's picture
Syndicate content
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2020
TOS | Privacy Policy