Tech

Where are the Save All and Close All commands in Word 2007?

Microsoft Word

In Word 2002 and 2003, when you press the Shift key as you click the File menu, the File menu displays the Save All and Close All commands.

These commands are not available on the Word 2007 Ribbon; you will need to add these commands to the Quick Access toolbar to use them.

To do so, follow these steps:

1. Click the Office button.
2. Click Customize in the left-hand column.
3. Click the drop-down arrow of the Choose Commands From box and select Commands Not In Ribbon.
4. Scroll to and click Close All.
5. Click the Add button.
6. Scroll to and click Save All.
7. Click the Add button, then click OK.

You can now access the Save All and Close All commands by clicking their icons in the Quick Access Toolbar.

As an alternative, you can create custom keyboard shortcuts for these commands by following these steps:

1. Click the Office button.
2. Click Customize in the left-hand column.
3. Click the Keyboard Shortcuts Customize button.
4. Under Categories, click Commands Not In Ribbon.
5. Under Commands, scroll to and click FileSaveAll.
6. Click in the Press New Shortcut Key box.
7. Press [Ctrl]F+A (or any key combination of your choice).
8. Click the Assign button, then click OK.

To create a shortcut key for Close All, select FileCloseAll in step 5.

Microsoft Excel

You can use diagonal borders to create a heading for the column labels and a heading for the row labels in the same Excel cell. For example, say you want to place the headings for the Regions column and the Sales columns in cell A3, as shown in Figure A. Follow these steps:

1. Select cell A3.
2. Press the spacebar eight times.
3. Type Sales.
4. Press [Alt][Enter] twice.
5. Type Regions.
6. Press [Ctrl][Enter].
7. In Excel 2007, click on the Home tab, then click the drop-down arrow of the Borders button in the Font group.
8. Click More Borders at the bottom of the list.
9. Click the Border tab, and then click the lower right-hand icon in the Border section.
10. Click OK.

If the word Sales is too close to the diagonal border, click before Sales in the formula bar, and press the spacebar a few more times.

Microsoft Access

When you need to change the name of a table, field, control, form, query or any object in your Access database, you don't need to go through your database and change every instance of that name manually--have Access do it for you.

For example, suppose your database contains a form with fields bound to a table, and you change the names of fields in that table. To have Access propagate those name changes to the form, follow these steps before you make those changes:

1. Go to Tools | Options and click the General tab.
2. Under the General tab, click in the NameAutoCorrect section, and click to select the Track Name AutoCorrect Info and the Perform Name AutoCorrect check boxes.
3. Click OK.

To activate the NameAutoCorrect option in Access 2007, follow these steps:

1. Click the Office button, and click the Access Options button.
2. Select Current Database on the left column.
3. Scroll to Name AutoCorrect Options and then click to select the Track Name AutoCorrect Info and the Perform Name AutoCorrect check boxes.
4. Click OK.

Now when you open the form, Access looks for all objects that the form depends on to see if there are any discrepancies in the names of the relative objects, and makes the changes accordingly.

Note that Name AutoCorrect will not propagate changes made to objects in Access Projects, SQL code, references in VBA modules, names of fields in linked tables, replicated databases, or macros used for toolbar and menu objects.

Latest from Blog Central

Up close and personal with a merger

Read more »

What's important from our sponsors

Business

Intelligence Summit

Presented by

Cutting-edge technology from premium sponsors

HP Simply StorageWorks D2D Backup System

Explore this disk-to-disk backup system that is fully automated and provides reliable data protection for your business.