tileworks said:
how can i print 70+ documents as a group instead of one by
one? do i need to make them into a workbook or
something? how would i do that?
An Excel file is a workbook. It can have multiple worksheets. Click at the
tabs at the bottom to view different worksheets. You can add a blank
worksheet by right-clicking on a tab and using:
Insert >> worksheet
This way you can have a big file with many worksheets that you can print by
using:
File >> Print >> Entire workbook
(I'm not sure if there can be as many as 70+ worksheets, though. Somebody
here'll know that factoid.)
Then, you can copy the contents of one of an old Excel document into one
worksheet of the big file in these steps:
1. In the old document, select an entire sheet by hitting control-A
2. Edit >> Copy
3. In a blank worksheet of the big file, select cell A1 and use
Edit >> Paste
Excel's "Help" has more detail on all of this.
A different way is to use a "Binder."
To start, right-click at an empty spot on the desktop, and use:
New >> Microsoft Office Binder
After opening the new Binder, use its Help for instructions about adding
Sections to the Binder. Each of your documents would be a section.
The Binder program is at
C:\Program Files\Microsoft Office\Office\BINDER.EXE
(I'm using Office 97.)
