TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Subject:Re: Importing Excel Spreadsheet into Word doc From:Elna Tymes <etymes -at- LTS -dot- COM> Date:Thu, 12 Aug 1999 19:30:54 -0700
Mark Kustrzynski wrote:
> How do I import an Excel spreadsheet into a Word document?
Couldn't be simpler: With your Excel spreadsheet open, select the columns
and rows you want to
transfer into the Word document, and select Copy on the Edit menu. (Or press
Ctrl C.) Close (or
minimize) the Excel window and maximize the Word window with a document in
it. Position the cursor
where you want the spreadsheet to go and select Paste on the Edit menu. (Or
press Ctrl V.)
The trick on this one is whether there are enough characters per line in
your Word document to
accommodate the number of characters per column (add one for each column
separator) in a row. If
you have 11 columns of 5 characters each, you have 55 characters of text,
plus 10 column
separators, and that might be too much for some word processing line widths.
If this is so there
are several options:
1. Increase the line length (in characters) for just the section where
you'll be pasting the
spreadsheet.
2. Decrease the point size of the font you're using for the spreadsheet.
3. Decrease the right and left margins of your word processing document.
This, however, will
cause the text lines to expand, too, and this may not be what you want.
I'm sure the group here can think of other ways around this too, but those
are the most obvious.