pivot table problem

[sterio]

I have problem which is when I use pivot table which is I need to assign each code to size as the size column is very long and when I make print preview as landscape some pages is blank from quantity so it print some pages without quantity so I need each page print with different codes and its size only not all size in horizontal view and its own quantity like image 2 not like image 1

[dflak]

How are you getting the pivot table to give you column values that do not exist in the data?

[shirleyxls]

Notwithstanding the query about your pivot table, would using Scaling and "Fit all columns on one page" in the print settings solve your problem?

[ChemistB]

I think this is what you are looking for...
Right click on the table and choose "Pivot Table Options"> "Display" tab
Uncheck "show items with no data on Columns"

[sterio]

I want item with no data in value area to not appear in sheet when I print the sheet
chemist b I try this but not work

[newdoverman]

It looks like all the columns are wider than they need be. Select all the columns that the pivot table occupies (the entire columns are selected and not just the pivot table) then double click the dividers between the column letters. That should shrink the column widths to the minimum for your data unless you have something written above or below the pivot table that we don't see.
Double click where I have circled in red.
Example.JPG