Working with Excel

Tips, Tricks, and Answers

The following articles are available for the 'Working with Excel' topic. Click the article''s title (shown in bold) to see the associated article.

   Can't Merge Alphanumeric Data Correctly
When you merge data from Excel into a Word document, you may need to do some conditional processing based on the data you are merging. This can lead to some screwy results at times. Here's an example and how to fix it.

   Embedding an Excel Chart in a Word Document
Word and Excel usually work pretty well together. This means that you can easily paste charts from Excel into your Word documents. Here's how to go about doing the pasting.

   Hyperlinking to a Specific Excel Worksheet
Creating a hyperlink to an Excel workbook is easy. With the information in this tip you can discover how to hone that hyperlink so that it goes right to the place you need in the workbook.

   Importing Excel Information Into Chart
Microsoft Graph is great for displaying charts in a document, without the need to actually use Excel. However, your data may actually be in an Excel worksheet, and you want to import it into a Microsoft Graph datasheet. Here's how to do it.

   Maintaining Leading Zeroes
When merging ZIP Codes from a data source such as Excel, you might find that Word ends up dropping out leading zeroes in the ZIP Codes. Here's how you can make sure that those digits are not dropped.

   Transposing Table Contents
When you transpose information, it is essentially "rotated" in a direction. If you transpose the information in a table, then the rows become columns and the columns become rows. This cannot be done directly in Word, but you can accomplish it if you work in conjunction with Excel.

   Unlinking an Excel Chart Automatically
When Excel charts are linked in a Word document, they update every time the document is opened. Here's how to unlink the chart and prevent automatic updating.

   Word Link to Create a New Excel Workbook
It's easy to create and include links in your documents to other sources, in and out of Word. There are some limitations you should keep in mind when using these links. This tips explains what they are (at least when it comes to Word and Excel) and how to avoid potential problems.

   Wrong Values Merged from Excel
When you use an Excel workbook as a data source for your merged document, you may be surprised if what is merged doesn't match what you see in Excel. This could be due to how Excel formats and displays numbers and how those numbers are shared with other programs, like Word.

This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.


FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.