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?
 
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
 
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.