Shrinking Back Page

Occasional Visitor

I PDF a workbook and the front page stays the same size as it's been but the 2nd page back shrinks and its hard to read the text... what is the best fix here or setting?

1 Reply

@Hollywood40 In the Page Lay-out ribbon, choose Page Setup (alternatively File, "Page Setup..." in the top menu). Choose the correct setting for each of the worksheets, i.e. portrait or landscape, zoom level or perhaps one sheet needs to 1 page wide and 2 tall. Or the other way around, or leave one of them blank to let Excel automatically paginate it.

You can also insert page breaks on every single sheet where you want them to be.

When you then select all sheets and Print to PDF, each sheet's individual settings are taken into account.