Tech

Limit your Style list in Word to your favorites

Microsoft Word

Most users use only a few of the available Word document styles. For example, you might use only three custom heading styles and one table style from the Style list for all your Word documents. Instead of scrolling through all the styles associated with your Word document, you can save yourself time by limiting the list to only those styles you frequently use. Follow these steps:

1. Go to View | Task Pane.
2. Click the drop-down arrow and select Styles And Formatting.
3. Click the drop-down arrow in the Show box at the bottom of the Styles And Formatting window.
4. Click Custom.
5. Select Available Styles.
6. In the Styles To Be Visible box, click to select the check boxes of the styles you use.
7. Clear the check boxes of the remaining styles listed.
8. Click OK.

You no longer have to scroll through a lengthy list to apply a style -- only the ones you need will be visible in the task pane. If you need to view them all again, press [Shift] and click the Style box in the Formatting toolbar.

Microsoft Excel

After creating UserForm1 for one Excel application, you realize that you'll want to use it again (with a few modifications) in another application. You do not need to recreate the form -- simply export the code to a file that you can import later to the new application. Follow these steps to export the code:

1. Open the workbook that contains the code you want to export.
2. Press [Alt][F11].
3. Right-click UserForm1 in the Project Explorer.
4. Select Export File.
5. Navigate to the folder where you want to save your form.
6. Give the file a name and click Save.

To import the form into another application, follow these steps:

1. Open the workbook that contains the code for your new application.
2. Press [Alt][F11].
3. Right-click the project name in the Project-VBA Project window.
4. Select Import File.
5. Navigate to the file you want to import.
6. Click Open.

You can use these steps to export or import any Excel VBA Project object.

Microsoft Access

While the Report Wizard automatically adds page numbers to your Access report, it does not add a date and time stamp. And, if you create a report in Design view, you have to add the controls for the page numbers as well. Access provides menus so that you don't have to know the code for setting these controls.

For example, to add page numbers to the bottom of your report, follow these steps:

1. Open your report in Design view.
2. Go to Insert | Page Numbers.
3. Click Page N Of M under Format.
4. Click Bottom Of Page [Footer] under Position.
5. Click the drop-down arrow under Alignment and select Center. Click OK.

If the first page of your report is a title page and you do not want the number to appear on that page, clear the Show Number On First Page check box before clicking OK in step 5.

The Page Numbers dialog box gives you a number of options for positioning the number in the header and footer. For example, if you are printing the report on both sides of the paper, you can select Inside or Outside in step 4.

To use the menus to insert a date and time stamp in your report's footer, follow these steps:

1. Open your report in Design view.
2. Go to Insert | Date And Time.
3. Select the Date format you want to display under Include Date.
4. Select the Time format you want to display under Include Time. Click OK.
5. Drag the Time And Date fields to where you want to position them in the page footer section.

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.