I see what I assume is a page break represented by a dotted line. Last edit at 03:08PM by NewtonMP2100. More experience with excel on the windows side, but isn't there a 'page break preview' where you.

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. External hard drive mac format. 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. Finally got it to work. It seems there are a lot of things that need to be 'aligned' in order for this to happen. If you try following the instructions above per Ms. Ergdegdeg's instructions, it may or may not work as I found out on one worksheet tab but not another.

It turns out one of the tabs had the 'Fit To' box checked (thus the blue lines did not show) but the other one didn't (the blue lines showed up right away). I've found that setting a 'Print Area' also helps, but boy this was far too complicated and too much effort for this simple function. I'd like to thank you all for your help and advice however, and for taking the time to respond! No page break preview in Excel 2008 for Mac users like windows.

I am a daily excel user. Recently i purchased Macbook pro. My question is why still Microsoft have not fixed the problem of page break preview for mac users. How one can leave this option out. This potential important tool in excel which you need every time when you print.

I use it almost whole day long, to fit my things well. I am very happy with my Macbook pro but i am only upset with this microsoft excel 2008 which is running on it. Why the developers left this option. I cant believe. Will the problem be fixed in a newer version for mac 2011.

Finally got it to work. It seems there are a lot of things that need to be 'aligned' in order for this to happen. If you try following the instructions above per Ms. Ergdegdeg's instructions, it may or may not work as I found out on one worksheet tab but not another. It turns out one of the tabs had the 'Fit To' box checked (thus the blue lines did not show) but the other one didn't (the blue lines showed up right away).

I've found that setting a 'Print Area' also helps, but boy this was far too complicated and too much effort for this simple function. I'd like to thank you all for your help and advice however, and for taking the time to respond! Click to expand.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.

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. 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.

Ms word for mac 2011 how to set standard fonts for all word documents. 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. I had already set my page breaks by supposedly inserting page breaks. I even told it 'one page wide by 5' tall.