9th April 2002
If you're not using formulas in Excel, then why bother with the spreadsheet app in the first place? Though, I suppose there are times when you'd like a formula's result to become a static number (no longer dependent on another cell's value). Fix that calculated cell by selecting it, flipping up to the Formula bar, and tapping F9. Formula gone, number converted. Cool. Now only if we could get rid of those grid lines. Sometimes they can get in the way, so here's a way to quickly toggle them on and off. Right-click on a toolbar and select Customize | Commands tab | Categories section | Forms, then drag & drop the "Toggle Grid" button somewhere into a menu or an existing toolbar. Press it at will! Oh, now if only I easily could figure out how old my dad is. I'll enter his birth date into A1: 07/19/1943 (with the slashes). Now, in A2, I'll enter: =datedif(a1,today(),"y") (with no spaces). How many months has he been alive? Replace that "y" with an "m" to find out. As for days? Yeah, you guessed it. Use a "d" in its place. Wow. I had no idea he was that young.