Insert Page Breaks Excel How To Get Those

Not as straightforward as Excel for PC, but certainly do-able.

For a better experience, please enable JavaScript in your browser before proceeding.

I am trying to bring up the Page Break Preview on my Mac Excel (2011, Ver 14.1.4) but cant seem to do this.

There doesnt seem to be any way for me to manipulate the page breaks so that I can set the pages as I want them to be set.

In fact, the Page Break Preview option doesnt seem to appear anywhere.

Am I missing something Any help or advice would be greatly appreciated Thanks in advance.

The Page Layout is what you see now, but without the blue lines where page breaks appear.

At least for me, it then shows the blue lines for page breaks.

If youve moved them around and dont 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.

Insert Page Breaks Excel How To Get Those

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 its even worse on Windows.

It turns out one of the tabs had the Fit To box checked (thus the blue lines did not show) but the other one didnt (the blue lines showed up right away).

Ive found that setting a Print Area also helps, but boy this was far too complicated and too much effort for this simple function.

Id like to thank you all for your help and advice however, and for taking the time to respond Cheers.

My question is why still Microsoft have not fixed the problem of page break preview for mac users.

I am very happy with my Macbook pro but i am only upset with this microsoft excel 2008 which is running on it.

Hover over any one and a grabber appears -- you can use it to drag and drop the page breaks.

You say activate Layout ribbon but I cannot find it anywhere (Excel 2008 - Mac).

In 2008 what you want to do is bring up the document you want page breaks in (assuming youre in Normal mode under the View menu) and: Go to Preferences under the Excel menu, click the View item, and in the Window options section at top right, check the box next to Show page breaks (the very first item).

Click OK, and you should have the page breaks showing, which you can now drag if you hover the mouse over them.

Insert Page Breaks Excel For Mac