View Single Post
 
Old 04-27-2022, 03:25 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote