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
Sometimes merging data from an Excel file can be downright tricky. Dave was having a problem that illustrates this statement perfectly. This tip addresses that problem and provides a couple of ideas to help solve 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
Word allows you to create hyperlinks in a document. These hyperlinks can go to a Web site or some other resource, such as an Excel workbook. How to open a specific worksheet (or go to a specific cell) in the workbook can be a little bit baffling, at least until you discover the techniques in this tip.

Importing Excel Information Into Chart
How to get information stored in Excel into a datasheet for use by Microsoft Graph.

Maintaining Leading Zeroes
If you merge information into a Word document from Excel, you know that it can sometimes be challenging to get the information imported in just the way you expect. Case in point: leading zeroes in ZIP Codes. What do you do if the zeroes don't appear in the merged data?

Word Link to Create a New Excel Workbook
You can create a hyperlink to an existing Excel workbook template, but clicking on the hyperlink won't create a new workbook based on that template. Here's how to get around that limitation.

Wrong Values Merged from Excel
Excel can be used as a data source for information in a Word mail merge. It is possible, however, for the values you merge to be different than what you expect. This is more than likely caused by the way in which Word merges the data. This tip covers a few things you can do to get your data just the way you want.