Re: Inserting an Excel Spreadsheet into Word

Subject: Re: Inserting an Excel Spreadsheet into Word
From: Ed Wurster <glassnet -at- gmail -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Mon, 19 Sep 2005 11:39:27 -0400


Dan Goldstein wrote:

> Excellent method, Jyoti -- you can then edit it as a *table*, of course,
> not as a spreadsheet. One quirk: Wherever the original Excel worksheet
> has a blank cell, the Word table merges it with the cell to its left.

> > One way:

> > 1. Select the contents of a single worksheet in Excel.
> > 2. Edit->Copy
> > 3. In Word, Edit->Paste Special. And choose "Formatted Text".

> > You can then manipulate the data as a spreadsheet in word. It
> > won't look as nice as the Excel table, but it might be good
> > enough for what you want to do with it.

> > Do this with each worksheet in your workbook.

Do not forget that Word can convert the tab text to a table after you
paste special. Look under the Table menu for that.

--
Ed Wurster (Voorhees, NJ)
Tech Tips Blog
http://www.ewurster.com/html/tech_tips.html

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Now Shipping -- WebWorks ePublisher Pro for Word! Easily create online
Help. And online anything else. Redesigned interface with a new
project-based workflow. Try it today! http://www.webworks.com/techwr-l

Doc-To-Help 2005 converts RoboHelp files with one click. Author with Word or any HTML editor. Visit our site to see a conversion demo movie and learn more. http://www.componentone.com/TECHWRL/DocToHelp2005

---
You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- techwr-l -dot- com
Send administrative questions to lisa -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/techwhirl/ for more resources and info.



References:
RE: Inserting an Excel Spreadsheet into Word: From: Dan Goldstein

Previous by Author: Re: FrameMaker Quick Reference Guide in Word format...
Next by Author: Re: Invoicing
Previous by Thread: RE: Inserting an Excel Spreadsheet into Word
Next by Thread: RE: Inserting an Excel Spreadsheet into Word


What this post helpful? Share it with friends and colleagues:


Sponsored Ads