7th May 2002

The shortest distance between two points is a keyboard (as far as computing is concerned). Let's play the number game again, shall we? For that, we'll need Excel. Let's say this cell contains a dollar value, but it isn't formatted as such. Simple. Select it and do a CTRL+SHIFT+$ on that bad boy. Was it a percentage without a percent symbol? CTRL+SHIFT+% will work its magic. If you need to insert an empty cell, CTRL+SHIFT+Plus will put your mind at ease. Yes, that means you hold onto CTRL and SHIFT as you tap the "+" key. Go ahead and select a few random (or semi-random) rows. Don't wanna see 'em anymore? Yeah, neither do I. So slap a CTRL+9 on 'em. Wanna see your precious data again? Either drop a million dollars (in unmarked bills) into the nearest mailbox, or use CTRL+SHIFT+( instead. Hey, here's something that'll drive your dad nuts. Open his favorite spreadsheet, select a cell, click Data | Validation. Flip to the Input Message tab and enter a wacky message. The next time he selects that cell, he'll see what you wrote. Check out the Error Alert tab, too. Instant customized dialog creation!