Adjust page breaks on multiple Sheets Excel 2013

djshakes

New Member
Joined
Jul 1, 2008
Messages
23
Seems our engineering friends at Microsoft are at it again. They love breaking things that work perfectly. I have a workbook with about 70 identical sheets. I wanted to print the same rows on each sheet. Well in the 2013 version you can no longer set the print area on multiple sheets. Fine, I just deleted the rows I didn't need. I then found out each worksheet has multiple page breaks that don't clear even when trying to adjust in a single workbook via the Breaks>remove page breaks. You must manual click and drag the breaks to get them to clear. The issue is you can't click and drag page breaks in multiple worksheets.

Does anyone know how to:
A: Set a print area for multiple sheets including setting the print titles
or
B: Remove page breaks on multiple worksheets at once.

This what happens when you have a monopoly on a product. It continues to get worse and worse.
 

djshakes

New Member
Joined
Jul 1, 2008
Messages
23
I think I have found a partial work around. If I highlight multiple sheets and adjust the width and height to 1 page it removes the multiple page breaks. However, page one is still 225 rows tall. I am still unable to pull the page break up to row 21 on multiple sheet (ridiculous). Is there any way to adjust all the page breaks to end at row 21 without manually dragging the page break up on 70 different worksheets? There is no data in the rows after 21. I even cleared the contents to see if that was the issue.
 
Last edited:

djshakes

New Member
Joined
Jul 1, 2008
Messages
23
I figured it out somehow. Stumbled through. Saved it as a non-macro book, had to make changes (deleting rows, etc) but it still wouldn't simple allow me to adjust the page break, save, select non-compatibility, re-open, appears to have adjusted. Makes no sense and I hope I never have to do it again. Excel really needs some competition. There has to be a better product. It gets worse and worse each revision. My co-worker and I swear there is a room full of engineers that has a large white board and they sit around and and try to figure out ways to break things or make them worse.

Engineer #1 : "I know, let's change the pivot table feature and appearance from the classic view to this crap view no one will use. On top of that, make it so it is near impossible to copy paste values and formats when you want to kill the pivot. We'll allow them to keep the values but the formatting will be gone. We'll create a work around with a lot more steps and it will only work sometimes depending on the size. Hahah. That'll get them!"

Room of engineers laugh as it is added to the board. More ridiculous changes are suggested while engineer #21 sits quietly in the back of the room. After all the suggestions and the board fills up engineer #21 raises his hands.

Engineer #21 : "I have something that will trump everything. Enable editing"

White board employee: "What do you mean....enable editing?"

Engineer #21 " "We require them to push a button if they wish to do anything in the workbook"

All the engineers eyes grow wide....silence fills the room.

White board employee: "Ummm.....folks.....I think we have a winner"

This has to be how Microsoft operates. Google or someone....please create another product to compete!!!
 

Forum statistics

Threads
1,082,373
Messages
5,365,074
Members
400,822
Latest member
Aldebaran13

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top