Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Dec 30, 2011, 04:22 PM   #1
Jonny Macleseed
macrumors newbie
 
Join Date: Dec 2011
Page Break Preview in Excel ...

Hi All!

I've done a search online and can't seem to find the answer to this question. I am trying to bring up the 'Page Break Preview' on my Mac Excel (2011, Ver 14.1.4) but can't seem to do this. There doesn't 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 doesn't seem to appear anywhere. Am I missing something?

Any help or advice would be greatly appreciated!

Thanks in advance!
Jonny Macleseed is offline   0 Reply With Quote
Old Dec 30, 2011, 04:27 PM   #2
iSaint
macrumors 603
 
iSaint's Avatar
 
Join Date: May 2004
Location: South Mississippi y'all, near the water!
Send a message via AIM to iSaint
I don't think it's available in the newer versions for Mac. I remember looking for it as well. The Page Layout is what you see now, but without the blue lines where page breaks appear.
__________________
Not Applicable
iSaint is offline   0 Reply With Quote
Old Dec 30, 2011, 04:30 PM   #3
ergdegdeg
Moderator emeritus
 
ergdegdeg's Avatar
 
Join Date: Oct 2007
Location: Nebraska
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.
ergdegdeg is offline   1 Reply With Quote
Old Dec 31, 2011, 08:24 AM   #4
Jonny Macleseed
Thread Starter
macrumors newbie
 
Join Date: Dec 2011
Arg, that's somewhat annoying ... is there any way to make the adjustments necessary to put the pages as I like? It seems strange that this feature isn't included seeing as it's been in the Windows version forever ...
Jonny Macleseed is offline   0 Reply With Quote
Old Dec 31, 2011, 08:27 AM   #5
ergdegdeg
Moderator emeritus
 
ergdegdeg's Avatar
 
Join Date: Oct 2007
Location: Nebraska
Like I said, if you go to the print dialog and cancel out of it, you can adjust the blue lines that appeared.
ergdegdeg is offline   0 Reply With Quote
Old Dec 31, 2011, 02:47 PM   #6
Makosuke
macrumors 603
 
Join Date: Aug 2001
Location: The Cool Part of CA, USA
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.
Makosuke is offline   0 Reply With Quote
Old Dec 31, 2011, 04:37 PM   #7
Jonny Macleseed
Thread Starter
macrumors newbie
 
Join Date: Dec 2011
OK, phew! 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!

Cheers!
Jonny Macleseed is offline   0 Reply With Quote
Old Jan 2, 2012, 11:40 AM   #8
farrers
macrumors newbie
 
Join Date: Jan 2012
Thanks!

Quote:
Originally Posted by ergdegdeg View Post
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.
This worked like a charm! Once I did this, I could click and drag the page breaks quite easily. Thanks a bunch!
farrers is offline   0 Reply With Quote
Old Aug 18, 2012, 05:22 AM   #9
lipsonferns
macrumors newbie
 
Join Date: Aug 2012
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
lipsonferns is offline   0 Reply With Quote
Old Dec 8, 2012, 10:28 AM   #10
randlord
macrumors newbie
 
Join Date: Dec 2012
Setting page breaks in Excel for Mac

If you activate the Layout ribbon and then tweak the scale slider (eg 99%, 98%) the blue dotted lines around the pages appear. Hover over any one and a grabber appears -- you can use it to drag and drop the page breaks.
randlord is offline   1 Reply With Quote
Old Jan 21, 2013, 08:21 PM   #11
Peter Reimann
macrumors newbie
 
Join Date: Jan 2013
Excel 2008 How to adjust page breaks -where is Layout ribbon?

Quote:
Originally Posted by randlord View Post
If you activate the Layout ribbon and then tweak the scale slider (eg 99%, 98%) the blue dotted lines around the pages appear. Hover over any one and a grabber appears -- you can use it to drag and drop the page breaks.
I've been reading all the posts and am still stumped in trying to find a way to simply drag the page breaks to where I want them. You say "activate Layout ribbon" but I cannot find it anywhere (Excel 2008 - Mac) . I would appreciate your help. /thanks
Peter Reimann is offline   0 Reply With Quote
Old Jan 22, 2013, 03:46 PM   #12
Makosuke
macrumors 603
 
Join Date: Aug 2001
Location: The Cool Part of CA, USA
Quote:
Originally Posted by Peter Reimann View Post
I've been reading all the posts and am still stumped in trying to find a way to simply drag the page breaks to where I want them. You say "activate Layout ribbon" but I cannot find it anywhere (Excel 2008 - Mac) . I would appreciate your help. /thanks
The ribbon is in Office 2011.

In 2008 what you want to do is bring up the document you want page breaks in (assuming you're 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.
Makosuke is offline   0 Reply With Quote
Old Apr 1, 2014, 09:58 AM   #13
jezfernandez
macrumors newbie
 
Join Date: Apr 2014
You can do it!

1. Go to the Layout tab
2. Click on Page Layout under the View section
3. Click on the row or column where you would like your page break to be
4. Click on Insert (top menu) and select Page Break. Hey presto, it creates a break.

Not as straightforward as Excel for PC, but certainly do-able. Hope that helps.
jezfernandez is offline   0 Reply With Quote
Old Apr 2, 2014, 04:56 PM   #14
WilliamBos
macrumors member
 
Join Date: Oct 2009
Location: Innisfil, ON
Send a message via Skype™ to WilliamBos
Quote:
Originally Posted by Jonny Macleseed View Post
OK, phew! 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!

Cheers!
THANK YOU!! Unchecking this box worked like a charm!!
__________________
Thanks, Will
2011 Mac Mini, OSX 10.9.1, 500GB, 4GB Ram.
iPod Touch 4
iPhone 4S
WilliamBos is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Print multiple copies on one page (in pages or in preview) sttlr Mac Applications and Mac App Store 4 Mar 13, 2014 10:24 AM
When you delete a PDF page in Preview, is it gone for good? HarryPot OS X Mavericks (10.9) 3 Feb 4, 2014 01:44 PM
How to inserta page number of a pdf file in Preview hajime Mac Basics and Help 0 Dec 2, 2013 10:44 PM
MS Word - Insert landscape page (page break not working) foxdougan Mac Applications and Mac App Store 2 Jun 17, 2013 08:28 AM
Page numbers in Excel for Mac khowell Mac Applications and Mac App Store 4 Feb 28, 2013 06:00 PM

Forum Jump

All times are GMT -5. The time now is 02:27 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC