Hello all,
I have a double whammy here. I searched for an answer but seem to find answers regarding rows that are changing, not columns.
My 1st issue is this:
I have a document with a bunch of summaries that are filled out by different users on a single worksheet. Each summary can be a different width based on information required. I need to print these documents as PDF's on separate sheets. The way it prints with page breaks, it has the column width of the largest summary, regardless how many columns are on the specific printed page. Is there way to set a print area so that it looks at each specified print area (I set print area to match the needed areas), and prints the column width that is specified? (since I am new, i don't think i can attach). I am at work and am not able to load a picture to a url site either.
My 2nd issue is this:
When I filter, it prints blank pages for items that were not used in the filter. I feel this should be easy, but I am missing something.
I will try and load an image from my personal computer as soon as I can.
I have a double whammy here. I searched for an answer but seem to find answers regarding rows that are changing, not columns.
My 1st issue is this:
I have a document with a bunch of summaries that are filled out by different users on a single worksheet. Each summary can be a different width based on information required. I need to print these documents as PDF's on separate sheets. The way it prints with page breaks, it has the column width of the largest summary, regardless how many columns are on the specific printed page. Is there way to set a print area so that it looks at each specified print area (I set print area to match the needed areas), and prints the column width that is specified? (since I am new, i don't think i can attach). I am at work and am not able to load a picture to a url site either.
My 2nd issue is this:
When I filter, it prints blank pages for items that were not used in the filter. I feel this should be easy, but I am missing something.
I will try and load an image from my personal computer as soon as I can.
