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.
Peter Beves wondered: <<I'm trying to take an excel spreadsheet (900 cells)
and get it into some form I can import into other docs as a single sheet.>>
Your best bet is to start in Excel by adapting the spreadsheet so that it
fits on a typical page before you even consider moving it to Word. Don't
forget, spreadsheets aren't tied to pages; they're abstract beasties that
can be as large and convoluted as you want, and that's one of their
less-recognized advantages over paper and pen calculations. Most people use
Excel primarily as a calculating engine, and design Excel _reports_ (not
spreadsheets) that summarize the results of those calculations when they
want printed output.
Once you've got something that might conceivably fit into or onto a page,
then _import_ the spreadsheet in Word. The simplest way to do this is to
open the File menu, select Open, then select the spreadsheet file. You can
then resave the file in Word format and convert the table into a Word table,
if necessary. Alternatively, you can open the Insert menu and select Object;
see the online help for details on the various options for this choice.
One problem with the latter approach is that if you embed the spreadsheet as
an object, you enormously increase file size and vulnerability to
corruption, plus you may make it more difficult to move the file around
(depending on the link options). So on the whole, the first approach is
faster and easier, though the latter approach is of course superior if the
spreadsheet must remain live so it can be updated in Word when the original
spreadsheet file changes.
--Geoff Hart, geoff-h -at- mtl -dot- feric -dot- ca
Forest Engineering Research Institute of Canada
580 boul. St-Jean
Pointe-Claire, Que., H9R 3J9 Canada
"User's advocate" online monthly at
"With Linux, customers end up being in the operating systems business,
managing software updates and security patches while making sure the
multitude of software packages don't conflict with each other."--Microsoft
spokesperson in a News.com article
"And just how would that be different from Windows?"--Adam Engst, TidBITS
Experience RoboHelp X3! This new RoboHelp release combines single sourcing,
print-quality documentation, conditional text and much more, into the most
monumental release of RoboHelp ever! http://www.ehelp.com/techwr-l
FrameMaker-to-PDF TimeSavers Assistants let you enhance & automate navigation
in PDF doc sets (chapter tabs, next/prev chapter/pg, bookmarks, popup menus);
create interactive PDF forms, rollover popups; presentations: http://www.microtype.com
You are currently subscribed to techwr-l as:
archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit http://www.raycomm.com/techwhirl/ for more resources and info.