copy page break to multiple sheets

  • Thread starter Thread starter jggsfl
  • Start date Start date
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
 
Thank you.

Gord Dibben said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Delete Multiple Page Breaks w/in Selected Rows 6
Printing multiple sheets... 1
Page break dosen't break 4
Page break issues 1
How to disable page break 1
Macro to determine row of page break on modified presentation sheet? 2
Multiple Page Breaks 4
How can I copy page set up options from one sheet to another 1

Back
Top