Excel 2010 for Mac - Cannot adjust page breaks - curly brackets do not appear on hover over even in Normal View

Hi EE

I am using Excel 2010 for Mac.

I cannot adjust page breaks - the curly brackets do not appear on hover over, even in the Normal View.  The page breaks are certainly visible (as black dashed lines) but I cannot adjust them.

I have followed the Excel Help instructions, but they must be missing something as the application is not working as indicated.  

Can you provide assistance as to why I cannot adjust my page breaks i.e. why the curly brackets that are supposed to be used for that exact purpose, do not appear when I hover over the page break dashed line?

Thanks
FH
Flying_High_71Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rory ArchibaldCommented:
Hi,
There is no Excel 2010 for Mac. Are you using 2011 or 2008 on the Mac, or 2010 for Windows?
0
Flying_High_71Author Commented:
Oh I am sorry.  I have Office 2010 on the mind.  It is indeed Excel 2008 for the Mac.  This is the version where they killed off the Page Break Preview at any rate.
0
Rory ArchibaldCommented:
I'm afraid I only have 2008 installed for testing on one machine at home (because it's so awful) so won't be able to check until I get home this evening. Hopefully someone else may have an answer in the meantime.
0
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Flying_High_71Author Commented:
If you could check it would be most appreciated
0
Rory ArchibaldCommented:
I'm afraid I did not get a chance to check last night, but I notice you mentioned Normal view - you can't drag page breaks in normal view, only in page break preview.
0
Flying_High_71Author Commented:
Hi rorya

This is MS Office 2008 for Mac, not MS Office for PC.  In their infinite wisdom, MS removed the Page Break preview feature on the Mac version which, reading various posts on the web, has caused no end of consternation.  Apparently adjustments to the Page Breaks are now made in the Normal view where the Page Breaks are presumably shown.  

My issue is that although I can see what appear to be page breaks, when I hover over them to get the curly brackes that are supposed to appear so you can move them, the curly brackets do not appear and I cannot adjust the page breaks.
0
Rory ArchibaldCommented:
Under Excel-Preferences, in the Edit section, do you have the 'enable fill handle and cell drag and drop' enabled? If not, that's the problem.
0
Flying_High_71Author Commented:
I would have thought that option is only for how to copy and drag cells or data.  However I tried that option on and off and it did not seem to make a difference to the handles appearing for moving the page break dashed lines.
0
Rory ArchibaldCommented:
If you turn it off, they don't appear. (note they only appear in normal view)
0
Flying_High_71Author Commented:
I have it turned on and I am in Normal view.  I can clearly see the page break which is a dashed black line.  What is supposed to happen is that when you hover over the page break i.e. the dashed black line)  there should be curly brakets and within those an 'up' and 'down' arrow heads that appear.  If they actually did apprear these would allow you to move the page break, thereby changing it to a 'manual pagebreak'.  It is this appearance of curly brackets that is not occuring. Even if I insert a manual page break, I cannot move it.      
0
Rory ArchibaldCommented:
I know - that is what happens for me, unless I turn off the option I mentioned. Is your copy of Office fully up to date?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Flying_High_71Author Commented:
Hi rorya

It appears the Mac Office 2008 suite was quite out of date, as unbeknowns to me I must have deselected the auto update feature quite some time ago.  I updated it (which I did manually and had to repeat a number of times to get all the updates - presumably in some sort of synchronous order) and then I also ensured the option 'enable fill handle and cell drag and drop'  (in the Excel preferences) was ticked and voila I can now see the grab handles on the page breaks in Excel in Office 2008 for Mac.  

Thanks so much for your continued help here - you muchly deserve these points.
0
Rory ArchibaldCommented:
Glad to help. 2008 is a lot like 2007 in Windows - have to keep patching it to make it behave! :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.