How to shrink multi-page xl spreadsheet>

Subject: How to shrink multi-page xl spreadsheet>
From: "Hart, Geoff" <Geoff-H -at- MTL -dot- FERIC -dot- CA>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Mon, 30 Sep 2002 09:22:43 -0400

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 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!

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:

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 for more resources and info.


Previous by Author: Job market and potential age discrimination?
Next by Author: Tools: Index problems in PageMaker
Previous by Thread: RE: techwr-l digest: September 28, 2002
Next by Thread: Word-PC link

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

Sponsored Ads