Share via

INSERTING A PAGE BREAK IN A SHEET

Anonymous
2025-01-02T17:29:24+00:00

I SAVED A WORKBOOK AS A PDF TO FIT THE PAGE, NOW I CAN NOT ADD IN PAGE BREAKS TO MY EXCEL?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2025-01-02T19:57:23+00:00

    If you set a worksheet to fit on 1 page wide and 1 page tall, inserting page breaks makes no sense: there is only one printed page.

    On the Page Layout tab of the ribbon, in the Scale to Fit group, set Width and Height to Automatic. You should then be able to insert page breaks.

    1 person found this answer helpful.
    0 comments