Home >
Computers And Internet >
Training
Using Smart Tags to Link Excel Data in Word
by Beth Sunny
If you want to link Excel worksheet data within a Word document, you can use the Paste Options smart tag button -- here's how...
by Beth Sunny and Karin Rex
If you want to link Excel worksheet data within a Word document, you can use the Paste Options smart tag button to ensure that formatting changes made to the object in your document are not lost when the object in the source file is updated.
1. In Excel, select an area and then choose Copy from the Edit menu.
2. In Word, choose Paste from the Edit menu.
3. Click on the Paste Options smart tag button (an example is shown below) and choose either Keep Source Formatting and Link to Excel or Match Destination Table Style and Link to Excel.
*********** Beth Sunny and Karin Rex share their extensive knowledge in IT and training as freelance writers for SharperTraining.com. Don't miss their training tips along with insights from other experienced trainers in SharperTraining.com's "Focus On Training" newsletter. To subscribe, visit http://lb.bcentral.com/ex/manage/subscriberprefs.aspx?customerid=1468
About the Author
Beth Sunny is a writer, publisher, and computer trainer. She owns Software Training Resources (STR), a courseware company known for their "QuickSteps to Learning" training manuals. STR launched an exciting web site in January of 2001. The web site is specifically for the Computer Training Industry - http://www.sharpertraining.com. The site offers a place for individuals in the Computer Training Industry a place to advertise their business, correspond with others in the industry, find training products, and discover software tips and read great articles relating to computer training. Visit the site today! http://www.sharpertraining.com
More articles by Beth Sunny:
