In Excel 2011 at least, you can go to the print dialog and then cancel out of it. At least for me, it then shows the blue lines for page breaks.
I can't get the blue lines at all. I can get the little move the page break box, but only in page layout view. When I try to drag the page break, it freezes my scrolling so I can't drag the page break out of the view, which completely defeats the purpose.
Besides. I had already set my page breaks by supposedly inserting page breaks. I even told it "one page wide by 5" tall. It made my document one wide and three tall, completely ignoring all the manual page breaks I set, and furthermore, I can't view my page breaks at all. any help?
[doublepost=1475165959][/doublepost]
ergdegdeg told you how to do it, but for reference, if you want to show them without canceling out of the print dialogue, go to the "Layout" tab of the ribbon and check "Breaks" under the "View" segment (second from the left). If you've moved them around and don't like where they ended up, you can also use the "Breaks" button (as opposed to checkbox) under the Page Setup segment (leftmost one); the drop down includes a "Reset all page breaks" item.
That same Ribbon tab also includes the "print to fit" options farther to the right.
I always thought it was hilarious that everyone--including myself until I got so frustrated I went digging in the Ribbon--only knew how to get those to appear by canceling out of a print dialogue. The interface of Office is a complete abomination now, and it's even worse on Windows.
[doublepost=1475166048][/doublepost]it does not either give the blue lines!! arrrrrgh.
[doublepost=1475167539][/doublepost]
I can't get the blue lines at all. I can get the little move the page break box, but only in page layout view. When I try to drag the page break, it freezes my scrolling so I can't drag the page break out of the view, which completely defeats the purpose.
Besides. I had already set my page breaks by supposedly inserting page breaks. I even told it "one page wide by 5" tall. It made my document one wide and three tall, completely ignoring all the manual page breaks I set, and furthermore, I can't view my page breaks at all. any help?
[doublepost=1475165959][/doublepost]
[doublepost=1475166048][/doublepost]it does not either give the blue lines!! arrrrrgh.
that doesn't work either. argh!
[doublepost=1475167814][/doublepost]
I can't get the blue lines at all. I can get the little move the page break box, but only in page layout view. When I try to drag the page break, it freezes my scrolling so I can't drag the page break out of the view, which completely defeats the purpose.
Besides. I had already set my page breaks by supposedly inserting page breaks. I even told it "one page wide by 5" tall. It made my document one wide and three tall, completely ignoring all the manual page breaks I set, and furthermore, I can't view my page breaks at all. any help?
[doublepost=1475165959][/doublepost]
[doublepost=1475166048][/doublepost]it does not either give the blue lines!! arrrrrgh.
that doesn't work either. argh!
[doublepost=1475168014][/doublepost]Ok Excel fans. It makes me sick to say this, but after a couple of hours I gave up, highlighted the entire thing, copied it to Word and added all the page breaks I needed. Not my fav or most efficient way to do things, but at least the programs talk enough for Word to understand the Excel table. It makes no sense. Like page breaks are kind of important right? I hope Microsoft will fix this soon.