Excel: Currency Format Shortcut

Last week, someone asked me if there's a keyboard shortcut to change a cell's number format to currency - and I'm pleased to say that yes, there is! And it's pretty easy to remember too:

Ctrl + Shift + $

This will change the number format of whatever cell(s) you have selected to currency format (with the default dollar sign and two decimal places).
Read More

Word: Where did my ruler go?

This is a really common question I get from new Word 2007 users. I'll answer it in today's entry: where did my ruler go?

Don't worry! It's still there, you just need to make it visible. Go to the 'View' tab on your ruler, and check off the 'Ruler' box (it's in the 'Show/Hide' group on the left-hand side of the ribbon).
Read More