Tips.Net > WordTips Home > Working with Other Programs > Working with Excel
Tips, Tricks, and Answers
The following articles are available. 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. Microsoft Word versions: 97 2000 2002 2003
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. Microsoft Word versions: 97 2000 2002 2003
Importing Excel Information Into Chart How to get information stored in Excel into a datasheet for use by Microsoft Graph. Microsoft Word versions: 6 95 97 2000 2002 2003
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? Microsoft Word versions: 97 2000 2002 2003
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. Microsoft Word versions: 97 2000 2002 2003
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. Microsoft Word versions: 2002 2003
Fast Answers!
It doesn't matter if you are a beginner or expert, the WordTips archives are the fastest way to improved productivity. (more information...)
Helpful Links
Ask a Word Question
Make a Comment
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Great Info!
RSS Feeds
Daily Nuggets (a WordTip every day)
Allen Wyatt's WordTips (the weekly classic)