MS Office Tips & Tricks

Quick Graphs in Excel 2007

If you have data in an Excel spreadsheet which you want to represent in a graph, just select any cell containing the data and press the F11 key. Right-click on the graph border to change the graph type, location or data.

Format Painter functions using keystrokes
The Format Painter tool is frequently used when

Useful tips and Tricks for Word 2007

Startup and settings

1. To change the author name and initials that are displayed in comments and tracked changes for new or existing documents, update the name in the User name box (Word options dialog box, Popular category) or the Author document property. For more information, see Change the author name for documents.
2. To assign keyboard shortcuts to frequently used styles, click Customize in the Customize category in the Word options dialog box. For more information, see Accessibility features in Word.
3. Block users from changing the default Quick Style set
4. On the Home tab, in the Styles group, click the Styles Dialog Box Launcher.
5. In the Styles dialog box, click Manage Styles, and then click the Restrict tab.
6. Select the Block