Tech Tip: Paste with Word [Insert] key/Format Excel cells/Create Access 2002 database

Word: Paste items from the clipboard with the [Insert] key

By default, pressing the [Insert] key toggles Word's Overtype mode on or off. However, you can reconfigure the [Insert] key to exhibit the Paste function.

Follow these steps:

  1. Go to Tools | Options.
  2. On the Edit tab, select the Use The INS Key For Paste check box, and click OK.

Pressing the [Insert] key after cutting or copying a selection of text now pastes the contents of the clipboard into the document at the point of insertion.

After you've set the Use The INS Key For Paste option, you can no longer use the [Insert] key to toggle Overtype mode on or off. However, you can still toggle Overtype mode on and off by double-clicking OVR in the status bar.

To make Overtype the default mode, select the Overtype Mode check box on the Edit tab in the Options dialog box.

Excel: Format cells as you type

Instead of going back to format cells after entering data, use these tips to configure Excel to format the cell as you type.

To enter a value in Currency format, type a dollar sign [$] before the value. For example, type $10.00 to enter 10 dollars in Currency format. (Don't confuse the Currency format with the format generated by the Currency button on the Formatting toolbar, which formats the cells in Accounting format with a dollar sign.)

To enter a value in Fraction format, type 0, press the spacebar, and type the fraction (including the slash). For example, typing 0, pressing the spacebar, and typing 1/2 enters one-half in Fraction format.

To enter a value in Percentage format, type a percent sign [%] after the value, as in 70%.

You can also format cells as text as you type. For example, if you enter the ZIP code value 08053, Excel formats it as the number 8053 by default. To configure Excel to format it as text, enter an apostrophe ['] before the value. In this case, typing '08053 formats the cell as the text value 08053.

Access: Create Access 2000 format databases in Access 2002

When you create a new database in Access 2002, the application displays the file format next to the database name in the Database window title bar. However, you can't use files created in the Access 2002 file format with Access 2000.

If you work with Access 2002 but want your database to be accessible to Access 2000 users, you must create it in Access 2000 format.

Follow these steps:

  1. Open a new or existing database, and go to Tools | Options.
  2. On the Advanced tab, select Access 2000 from the Default File Format drop-down list, and click OK.

The next time you create a database in Access 2002, it will have the Access 2000 file format.

Even though Access 2000 users can work with the file, any features added to the database that are unique to Access 2002, such as PivotTable views, will not be available. You must open the file in Access 2002 in order for these features to work.

Editor's Picks

Free Newsletters, In your Inbox