I have a series of 114 workbooks with 22 worksheets each. They are setup
for A4 printing. Is there a way to print all worksheets in each workbook on
8½x11 with row and column headings without specifying it on each worksheet
individually? I am using Excell 2000.
Steve Williams
You can do it once for each workbook.
1) Select the first worksheet tab, then scroll over and hold the <Shift> key
while clicking the last tab. This will select all worksheets in that
workbook.
2) Define your paper sizes, headings, etc and they will be applied to all
worksheets.
There may be some way to change your system settings, then go to each
workbook and apply default settings, but that is beyond me. Maybe you can
create a general macro to do it then start each workbook running that macro.
Hopefully, someone else can help with that.
Good Luck,
Jim