copy page break to multiple sheets

[jggsfl]

How do I copy page break to multiple sheets.
Thank you.

 

[Gord Dibben]

Select first sheet.

Right-click on that sheet tab and "select all sheets"

Select a row and Insert>PageBreak.

Will be inserted on all sheets.

Select any sheet but the active sheet to ungroup the sheets.


Gord Dibben MS Excel MVP

 

[jggsfl]

Thank you.

Select first sheet.

Right-click on that sheet tab and "select all sheets"

Select a row and Insert>PageBreak.

Will be inserted on all sheets.

Select any sheet but the active sheet to ungroup the sheets.


Gord Dibben MS Excel MVP