Filed under: Office, Productivity, Microsoft
Excel tip: Show formulas with a keystroke
I've been using Excel for a long time and might even consider myself a power user, so I'm surprised I never came across this tip before: You can toggle a formula view to see all of a spreadsheet's formulas at once by pressing Ctrl+`. That little fleck, in case it's not entirely clear, is a backtick (or, as this site takes way too many paragraphs to explain, a gravé), i.e. the seldom-used character that shares a key with the tilde just to the left of the 1 key on most keyboards. Press Ctrl+` once to show all of your formulas, press it again to switch back to the regular data view.[Via Digg]
So, just how good at time waster games are you? Think you've got the stuff? Well, The World's Hardest Game 2.0 doesn't think you do.
Yes, amazingly, it's possible to have a sequel to a game called "The World's Hardest Game". It doesn't seem logically possible, since if the first one was actually the world's hardest, how could another one come along and share the moniker? It made me doubt the name in the first place. That is, until I tried the game.
The mechanics of the game are very simple. You are a small red square, ...
Reader Comments (Page 1 of 1)
junior aspirin said 1:00PM on 5-11-2006
works in open office calc too.
Reply
Claudiu Spulber said 2:44AM on 5-12-2006
Well for more tricks in Excel you have to install the ASAP utilities (http://www.asap-utilities.com/). Freeware.
Reply
Stephen Metheringham said 9:32AM on 5-12-2006
I use f2 which toogles between value and formula on the active cell
Reply