It looks like you have those 34 pages either vertically or horizontally, and for some reason the printing range has either additional column or row included. There may be several reasons for this:
a) You have additional column/row immediately at right/below of your table formatted with some format;
b) You have set a border for column/row immediately at right/below of your table;
c) You have a space entered into some cell immediately at right/below of your table;
d) In case you pages are placed horizontally and you use a footer, the height of footer is too much, and it doesn't fit into page;
e) ... (I'm sure there will be more!)
To check, you can use print preview. after you used it, the page breaks are displayed in Excel sheet as dashed lines.
To remove formatting of space issues, select a block of rows/columns adjacent to your datarange on sheet, and delete selection(s). When you use footer, you can try to make it's height lesser.
|