I have 10 sheets to a workbook and they are exactly the same. A1:L55 need to be on the same page. But my break is at K. How do i adjust multiple sheets as once?
I have 10 sheets to a workbook and they are exactly the same. A1:L55 need to be on the same page. But my break is at K. How do i adjust multiple sheets as once?
Good afternoon Taylorsm,
Hold Control and select all of the sheets you would like to adjust the page breaks for.
Remove the unwanted page break(s) from the active sheet and add the new one where desired. Excel should make your selection consistent across all selected workbooks.
Oh OK. I was trying to drag the page breaks. Which for whatever reason excel won't let me know when I have all sheets selected.
Thanks!
Absolutely, I'm glad it worked for you!
Feel free to hit the "Add Reputation" button if you're satisfied with the solution above![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks