|
Hi, Speakingtohe! I tried what you suggested and not only did everything go horribly wrong, Excel and printer just sat there and laughed at me. Thanks anyway.
I did some more fooling around (get your minds out of the gutter; at my age, the only action I get any more is when the prunes kick in) and found that converting the Excel file from the Acrobat tab then printing worked out much better. These are the revised steps:
1. Save Library (author, not author sort, and title only) as an XML file.
2. Open the XML in Excel (2007). There will be three columns: A (title), B (sort), C (author).
3. Sort columns A & C, in that order.
4. Delete column B.
5. Select and drag column A to column D.
6. Select and drag column B to column C.
7. Delete columns A & B.
8. Set page size to 11" X 17".
9. Set left margin to 0.7" and rest to 0".
10. Drag columns to correct width.
11. Set print area.
12. Click on Adobe tab.
13. Click on Create PDF.
14. Click on Convert to PDF in pop-up.
15. Click on Yes in next pop-up.
16. In the next pop-up, fill in file name and destination, then click on Save.
17. Click on Save again in the next pop-up.
18. Print booklet from Adobe.
All of the inside margins are now the same. The outside margin is a bit wide but the booklet would need trimming anyway after stapling so that isn't a problem. Once trimmed, all margins will be even.
This seems like a lot of steps, but it goes faster than it looks. I won't be doing this very often anyway.
|