copy page break to multiple sheets
 

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

copy page break to multiple sheets
 

Select first sheet.

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

Select a row and InsertPageBreak.

Will be inserted on all sheets.

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


Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 13:48:00 -0700, jggsfl
wrote:

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

copy page break to multiple sheets
 

Thank you.

"Gord Dibben" wrote:

Select first sheet.

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

Select a row and InsertPageBreak.

Will be inserted on all sheets.

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


Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 13:48:00 -0700, jggsfl
wrote:

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