Variable column width by page?

  • Thread starter Thread starter Steve S.
  • Start date Start date
S

Steve S.

Okay...I'm stumped on this one. I have a book that has a
perf edge on it. Some columns need to be wider to account
for product info. On the perf is the same info and it is
printed 2-sided, so the information on the perf has to
change to the opposite side. Here's the example setup:

Front of page
ID1 | ID2 | Pinfo | Product | Qty | (perf) ID1 | Qty
Back of page
ID1 | Qty | (perf) ID1 | ID2 | Pinfo | Product | Qty

Space limitations keep me from just keeping the column
widths big enough to account for either direction.

Is there a way to have two setups for column widths based
on Front or Back of the page? I have a column which will
describe whether the page is odd/even (front/back).

This one is beyond me. Thanks for any help you can offer!
 
Hi
you can't have different column widths on one sheet. Possible
workarounds:
- devide the data on two separate worksheets
- you can record a macro for printing this page:
-> first set the column width for page 1, and print it
-> then change the column widt and print page 2
 
Back
Top