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.962024
I Averaged: 4 | 79 votes

Who's New

metaclippingpath's picture
Generalocee's picture
emma agro's picture
DarkkDdream's picture
Larisabrownb's picture
conor13's picture
MeadeDorianx's picture
Emilylowes's picture
Emmaythomson's picture
Chair's picture
Financial's picture
Red bud's picture
DonnaStella123's picture
WenrichFeugene's picture
Weissert's picture
Syndicate content
facebook codes exploits tips tricks Phrozen Crew
All contents ©Copyright GeekDrop™ 2009-2024
TOS | Privacy Policy