Tips for Office 2007

Microsoft Office Word:

• Change the Microsoft Office Word Smart Quote Auto-correct Setting->

By default, Word replaces straight quotes with smart quotes. To change this setting:
1. Click the Office button.
2. Click Word Options.
3. Click Proofing, and then click AutoCorrect Options.
4. Click the AutoFormat tab.
5. Clear the Straight quotes with smart quotes check box.
6. Click the AutoFormat As You Type tab.
7. Clear the Straight quotes with smart quotes check box.
8. Click OK twice.

• Editing in Print Preview

After you have worked on a document in Microsoft Office Word, click the Office button, point to Print, and then click Print Preview.
You can still edit in print preview mode:
Disable the magnifier by clearing the Magnifier check box on the Preview tab, and edit the document as you want.

• Line Breaks Without Bullets

When you're creating a bulleted or numbered list in Microsoft Office Word or Microsoft Office PowerPoint, you might want an item to appear in the list without a bullet or without incrementing the number. You can start a new line without a bullet by pressing SHIFT+ENTER. The next time you press the ENTER key, the new line will continue the bulleted or numbered list.

EXCEL:

• Copy Data from a Table in a Web Page to Excel->

If you see a data table on a Web page and you want to import it into Microsoft Office Excel:
1. Copy the URL (address) of the page.
2. In Excel, on the Data tab, in the Get External Data section, click From Web.
3. In the New Web Query dialog box, paste the URL into the Address box.
4. Select the table that contains the data that you want to work with, and then click Import.
5. In the Import Data dialog box, indicate where you want the data to appear, and then click OK.

• Move the Cursor in Any Direction During Data Entry->

By default, the cell pointer in Microsoft Office Excel moves down when you press ENTER after entering data in a cell. You can, however, change the direction in which the cell pointer moves.
1. Click the Office button, click Excel Options, and then click Advanced.
2. Select the After pressing Enter, move selection check box if it isn't already selected, and then on the Direction menu, click the direction in which you want the pointer to move.

Also, when working in a document, you can make the pointer move in the opposite direction from the one you've chosen by holding down the SHIFT key while you press ENTER.

• Showing Formulas in Microsoft Office Excel Instead of Their Results->

Sometimes you want to display formulas in an Excel worksheet instead of their results. Here’s how:
1. Click the Office button, and then click Excel Options at the bottom of the menu.
2. Click Advanced, click Display options for this worksheet, click Show formulas in cells instead of their calculated results, and then click OK.

For more tips and tricks read this article.