+ Reply to Thread
Results 1 to 4 of 4

Setting page breaks on multiple sheets at once?

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Setting page breaks on multiple sheets at 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?

  2. #2
    Registered User
    Join Date
    02-15-2016
    Location
    United States
    MS-Off Ver
    2010
    Posts
    33

    Re: Setting page breaks on multiple sheets at 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.

  3. #3
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: Setting page breaks on multiple sheets at once?

    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!

  4. #4
    Registered User
    Join Date
    02-15-2016
    Location
    United States
    MS-Off Ver
    2010
    Posts
    33

    Re: Setting page breaks on multiple sheets at once?

    Absolutely, I'm glad it worked for you!

    Feel free to hit the "Add Reputation" button if you're satisfied with the solution above

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] [Solved] Split into multiple sheets by page breaks, preserving formatting
    By tecsbrain in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2014, 03:24 PM
  2. Setting page breaks with VBA
    By philozelda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2014, 03:43 PM
  3. Setting page breaks
    By silverxx12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 11:56 AM
  4. Setting Page Breaks
    By dongman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-03-2008, 06:24 PM
  5. setting page breaks.
    By Rod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2006, 07:35 PM
  6. [SOLVED] Setting page breaks (another)
    By Ian W in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2005, 09:06 AM
  7. [SOLVED] Are conditional formats available for setting page breaks?
    By Nicky Armstrong in forum Excel General
    Replies: 1
    Last Post: 02-20-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1