Create a shortcut key for printing selected text in Word

If you frequently print selected text in Word 2002 or Word 2003, you can eliminate having to bring up the Print menu for each copy you print. You simply create a macro and assign it to a keyboard shortcut.

Microsoft Word
Create a shortcut key for printing selected text in Word

If you frequently print selected text in Word 2002 or Word 2003, you can eliminate having to bring up the Print menu for each copy you print. You simply create a macro and assign it to a keyboard shortcut.

Follow these steps to create a shortcut key:

  1. Press [ALT][F11].
  2. In the Project-Normal view, double-click Normal | Microsoft Word Objects | This Document.
  3. Enter the following code in the Normal-This Document window:

    Sub PrintSelection()

    'PrintSelection macro

           Application.PrintOut Range: =wdPrintSelection
    End Sub

  4. Select File | Close And Return To Microsoft Word.
  5. Select Tools | Customize.
  6. Click the Keyboard button.
  7. Under Categories, select Macros.
  8. Under Macros, select PrintSelection.
  9. In the Press New Shortcut key text box, press [ALT][P]. In the Select Changes In drop-down menu, select Normal.dot.
  10. Click the Assign button.
  11. Click Close twice to return to your document.

To start benefiting from this keyboard shortcut, you need to select the text you want to print from the Word document and press [ALT][P].

Note: This example uses [ALT][P], but you can assign any keys that you didn't already assign to a keyboard shortcut.

Microsoft Excel


Make subtotal values stand out

When Excel's Data | Subtotals menu is used to calculate subtotals and grand totals in a list, Excel displays the resultant grand total and subtotal headings in bold; however, their associated values are not reformatted.

If there are a number of columns between the subtotal labels and their values, you may need to reformat the values manually to make the worksheet easier to read. Or, you can set conditional formatting that will automatically reformat the values for you.

For example, suppose you want to subtotal employee payroll worksheet data by employee and gross pay per month. You may prefer for the subtotals to appear bold and underlined, while the grand total is bold and double underlined.

Before running Data | Subtotals on the worksheet, follow these steps:

  1. Open the worksheet and select the raw data.
  2. Select Format | Conditional Formatting.
  3. Under Condition 1, select Formula Is.
  4. Press [TAB] and enter the following code:

    =$A1="Grand Total"

  5. Click the Format button.
  6. On the Font tab, select Double in the Underline drop-down menu and select Bold in the Font Style drop-down menu.
  7. Click OK and then click the Add button.
  8. Under Condition 2, select Formula Is.
  9. Press [TAB} and enter the following code:
    =Right($A1,5)="Total"
  10. Click the Format button.
  11. On the Font tab, select Single in the Underline drop-down menu and select Bold in the Font Style drop-down menu.
  12. Click OK twice to exit both dialog boxes.

When you run Data | Subtotals to obtain the gross pay subtotals and grand totals, both the labels and the total values for each employee and grand total will now be formatted.

Microsoft Access


Add a Switchboard to your Access application

Rather than accessing forms and reports from the Database Window in Access, you can create a Switchboard, which allows users to go directly to a specific form or report.

For example, suppose you want to present your users with a menu from which they can access the Employee data form and Employee Email Address form. You can do so by adding a Switchboard to your applications. Simply follow these steps:

  1. Go to Tools | Database Utilities | Switchboard Manager.
  2. You'll see this message: "The Switchboard Manager was unable to find a valid Switchboard in this database. Would you like to create one?" Click Yes.
  3. Click the Edit button.
  4. Click the New button and enter Open Employee Data Form for the Switchboard text.
  5. In the Command drop-down menu, select Open Form In Edit Mode.
  6. In the Form drop-down menu, select the Employee Data Form and Click OK.
  7. Click the New button.
  8. In the Text box, enter Open Employee Email Address Form.
  9. In the Command drop-down menu, select Open Form In Edit Mode.
  10. In the Form drop-down menu, select the Employee Email Address Form.
  11. Click OK and then click Close.

To automatically display the Switchboard when the database is opened, follow these steps:

  1. Go to Tools | Startup.
  2. Under Display Form/Page, choose Switchboard.
  3. Click OK.