Excel Move Page Breaks 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.

That same Ribbon tab also includes the print to fit options farther to the right.

Excel Move Page Breaks 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.

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.

Click on the row or column where you would like your page break to be 4.

Excel For Mac Move Page Breaks