Using keyboard shortcuts is a much more efficient way of working than choosing options through the menu. Here are a few killer keyboard shortcuts for Microsoft Excel that can save you time.

Action
Shortcut

Apply the outline border to the selected cells
Ctrl+Shift+&

Apply the Date format with the day, month, and year
Ctrl+Shift+#

Apply the Time format with the hour and […]

Here are a few tips to make you more productive with Word 2007.
Compare docs the smart way
You don’t need two windows to compare documents in Word 2007. Go to Review > Compare, and click Compare one more time. Enter two document names and you’ll see the difference.
Look for private data
Before sending a file, use the […]

Never leave the key board
Using keyboard shortcuts to choose options is definitely faster than reaching out for the mouse everytime. Office 2007 makes it easy. Tap the Alt key while in any Office 2007 application and the ribbon is instantly covered in small letters indicating the keystrokes. Type the for the different ribbon tabs (H […]

Ever come across an Excel file that you can open and view but if you wanted to edit it, you can’t, since it is has been protected? And when you try to unprotect, it asks for a password.

Here are a couple of ways to overcome the situation. While, you may not be able to make […]

Microsoft as changed its default file format in Office 2007. For example, .doc has become .docx and .xls has become .xlsx. The new formats now heavily depend on the XML file format. So, while you can open files of the older format using Office 2007 (in Compatibility mode), you won’t be able to open files […]

Versions earlier to Word 2007 used to have an AutoSummarize option in the Tool menu. The idea of the tool was to basically summarize long documents so that you could get the gist of the content. But honestly, it was not a tool you could really rely on. While, the summaries produced by it were […]

Did you know that when you save a file in Word 2007’s default .docx format, what you are actually saving is a compressed (or zipped) file containing several different XML documents. The earlier versions of word (.doc) were in binary format. The .docx documents tend to be much smaller than their older counterparts.