Internet Fixes Weekly Office XP Newsletter

April 23, 2004Keeping you up-to-date every week!

Use automatic language detection in Word XP!

Word XP's language detection feature can help you check the grammar and spelling of text written in almost any language, but first you must enable Word for the different languages with which you'll be working.

Click Start | Programs | Microsoft Office Tools | Microsoft Office Language XP Settings and select the Enabled Languages tab. Scroll down the list of available languages, select the language you would like to edit in Word, and click Add. Follow this procedure for each language you would like to enable. You can choose as many as you like.

After making all your language selections, click OK. A dialog box informs you that the changes will go into effect the next time you launch an Office XP application.

When you begin typing in the language of your choice, at first Word will check for spelling and grammar errors in your default language. After you type a few lines, Word detects the new language and begins checking for grammar and spelling in that language. (Note: If the appropriate spelling and grammar tools haven't been installed, Word will ask you to install them.)

In addition, Word automatically corrects words for spelling as you type. For example, when you type television as part of a sentence in Spanish, Word automatically corrects it to the Spanish equivalent, complete with special characters.

Word's built-in language detection feature can automatically detect text entered in approximately 60 different languages or language variations. However, if the particular language you would like to work with isn't available on your copy of Office XP, you can obtain language pack updates at the Microsoft Office Tools Web site.

Visit Our Windows XP Database Full Of Tips!

Copy an Excel Table and Its Formatting into Word!

When you copy a table of data from Microsoft Excel version 2002 into Microsoft Word version 2002, you can choose to keep the formatting you applied to the table in Excel. Or you can match the destination table style to format your table in the Word default table style.

To copy a table from Excel to Word:

1. Open the Word document you want to copy to and the Excel worksheet that contains the table.

2. In Excel, select the rows and columns of the table you want to copy.

3. On the Excel Edit menu, click Copy.

4. Switch to Word, and then click where you want the table to appear.

5. On the Word Edit menu, click Paste.

Click the Paste Options smart tag, and then click one of the following:

1. To keep the formatting that you applied in Excel, click Keep Source Formatting. (Or, to link to the table so that it automatically updates with new data, click Keep Source Formatting and Link to Excel.)

2. To match the style of a table already in your Word document, click Match Destination Table Style. (Or, to link to the table instead of copying it, click Match Destination Table Style and Link to Excel.)

Copy data from one Access table to another!

Before Office XP, Access users who wanted to copy columns of data from one table to another in a database had to copy and paste each column separately. With XP's Office Clipboard Task Pane, Access users can copy as many as 24 columns of data to the clipboard, and then later paste some or all of the columns into another table. Follow these instructions to copy data from one Access table to another.

First, follow these steps to collect the columns of data you wish to copy:

1. Click Edit | Office Clipboard to display the Clipboard Task Pane.

2. Open the table from which you want to copy the data, and select the first column of data to copy.

3. Click Copy, and a partial listing of data for that column will appear as an item in the Clipboard Task Pane.

4. Repeat Steps 2 and 3 for each column of data you wish to add to the clipboard.
Close the source table.

Next, follow these steps to paste the columns to a new table:

1. Open the table to which you want to copy the data, and select the blank column in which you want to paste an item from the clipboard. To avoid errors, ensure that the data type of the destination column is the same as that of the column to be pasted.

2. In the Clipboard Task Pane, click the item that lists the column you want to paste and confirm the paste.

3. Rename the field if necessary.

4. Repeat Steps 1 through 3 for each item you wish to paste from the clipboard.

5. Save your changes before closing the new table.

Before closing the Clipboard Task Pane, click the Clear All button to clear the clipboard.

Interesting Facts

Visit one of our Forums.

Web Site Topics