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
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
ASKER
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.
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.
ASKER
If you could check it would be most appreciated
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.
ASKER
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.
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.
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.
ASKER
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.
If you turn it off, they don't appear. (note they only appear in normal view)
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
Glad to help. 2008 is a lot like 2007 in Windows - have to keep patching it to make it behave! :)
There is no Excel 2010 for Mac. Are you using 2011 or 2008 on the Mac, or 2010 for Windows?