Page break preview in Excel 2008
ekf...@officeformac.com
Phil_...@officeformac.com
http://www.microsoft.com/mac/help.mspx?MODE=ct&CTT=PageView&clr=99-1-0&target=5f6264e5-25b1-4b85-9915-58b9d815ded91033&srcid=086c05b7-ca01-429a-85d4-bfd8dbdfb2851033&ep=8&rtype=2&pos=2&quid=9cb1b136-2289-47c0-a7d1-089712389d04
-Phil
JE McGimpsey
Phil_...@officeformac.com wrote:
> Page Break Preview is not available in Excel 2008 for Mac, but you can adjust
> page breaks in Normal view. Here's a help topic on how to do it. <br><br><a
> href="http://www.microsoft.com/mac/help.mspx?MODE=ct&CTT=PageView&clr=99-1-0&t
> arget=5f6264e5-25b1-4b85-9915-58b9d815ded91033&srcid=086c05b7-ca01-429a-85d4-b
> fd8dbdfb2851033&ep=8&rtype=2&pos=2&quid=9cb1b136-2289-47c0-a7d1-089712389d04">
> http://www.microsoft.com/mac/help.mspx?MODE=ct&CTT=PageView&clr=99-1-0
> &target=5f6264e5-25b1-4b85-9915-58b9d815ded91033&srcid=086c05b7-ca01-4
> 29a-85d4-bfd8dbdfb2851033&ep=8&rtype=2&pos=2&quid=9cb1b136-228
> 9-47c0-a7d1-089712389d04</a> <br><br>-Phil
I was about to chastise you for posting such an ugly message (no need
for html, plain text will do).
Then I saw the site referred to. You're off the hook...
Bo...@officeformac.com
It seems that the development team missed out some useful basic functions from XL 2004 when they created XL 2008 - was this deliberate or just an omission?
JE McGimpsey
wrote:
> The other thing that's missing is the straightforward "Print Preview"
> function, which was really useful in seeing and adjusting the page prior to
> printing. <br><br>It seems that the development team missed out some useful
> basic functions from XL 2004 when they created XL 2008 - was this deliberate
> or just an omission?
As I understand it, it was deliberate. For all Office apps, the OS
performs the printing functions - the apps call the OS print routines
and send them whatever needs to be printed.
Since Tiger and Leopard have full Preview functions, there's little or
no compelling reason to design and implement an internal Print Preview
that has to mimic system functions, and therefore runs the risk of
differing from the actual printed output if something changes in the
System.
While I liked Print Preview, it makes a certain sense to me.
alanitech
dynamically changed the print scaling while I manually dragged the page
breaks to where I wanted them. Using "insert page break" can't achieve that
sort of precision.
Maybe there's a way to reproduce this using Visual Bas --- oops! Guess not!
repe...@gmail.com
I would like to add my own disappointment over the removal of the
"Page Break Preview" function.
I used it all the time, and found it much easier than doing everything
manually. The Page Break
feature also helped to ensure that I could maximize my type size by
perfectly scaling the documenentt
based on where I placed the breaks. Will this manual insertion
automatically scale the text (usually
down in size) as I was able to achieve in previous versions with "Page
Break Preview"?
alanitech via MacKB.com
No, and that's my point. To scale the text (and everything else), you need to
use File...Page Setup, and enter either a percentage value for scaling or
"fit to" value for pages.
--
Message posted via MacKB.com
http://www.mackb.com/Uwe/Forums.aspx/excel/200801/1
jmac...@officeformac.com
guess that the kinks are till being worked on :(
alanitech via MacKB.com
Excel 2007. Same menu command: "View...Page Break Preview" as Mac (at least
when Windows Excel had menus -- now it's on one of the tabs).
JE McGimpsey
wrote:
> It's been on the Windows version, too, for as long as I can remember, and in
> Excel 2007. Same menu command: "View...Page Break Preview" as Mac (at least
> when Windows Excel had menus -- now it's on one of the tabs).
>
Print Preview and Page Break Preview are rather different.
Page Break Preview is mostly a reduced magnification view with guides
that allow one to drag page boundaries (and with non-printing
"watermarks" to identify pages.
Print Preview, OTOH, is a full-screen view that shows XL's
representation of how a page or pages will be printed, complete with
headers and footers, and guides that allow one to set column widths and
the page, header, and footer margins.
JE McGimpsey
jmac...@officeformac.com wrote:
> cannot believe that the "print preview" function was taken out- this is one
> of the things that MS had a "leg up" on MAC- i use this ALL the time- and
> although i semi-understand the reason, it BITES!- sorry to let this out here,
> but i HAD to. no one else i know understands what i am talking about- most
> people i know are either strict PC users, or MAC.<br>
> <br>
> guess that the kinks are till being worked on :(
Make sure you also "let this out" to MS - use Help/Send Feedback in XL.
Unknown
This sucks. Please bring this feature back.
Unknown
I still miss page break preview
jlo...@officeformac.com
This is so outrageous.
There is no way to duplicate this task.
WHY???????????
What can one do???????
jlo...@officeformac.com
I figured it out.
I know how to get back Page Break Preview...
Re-install Excel from Office 2004.
Worked fine for me.
In fact, I kept on Excel for 2008 also.
I don't think the 2008 version is that much better than 2004.
Problem solved.
Nice going Microsoft!
JE McGimpsey
Nikki <nikole....@interactcom.com> wrote:
> Unreal...As with others, I am too extremely disappointed that the Page Break
> Preview function is no longer...I often have to print things for my boss at
> the last minute because she's meeting with clients, and this completely
> destroyed any possibility of being able to get her what she needs in time in
> these situations. It's very annoying to have to flip back & forth between the
> first page & others because I'm no longer able to print everything on one
> page in one, easy click & drag.
Make sure you use Help/Send Feedback to explain what exactly you could
do in Page Break Preview that you can't to in Page Layout View.
Mag...@officeformac.com
10.5.2; Excel 12.0.1; Intel Core 2 Duo; 3GB; new Epson drivers;
Trashed all ~/library/preferences/com.microsoft.*
Excel won't let me print more than a Single Column per page -- either in portrait or landscape
Pat McMillan
details? Are you saying that only a single column prints out, regardless of
column width? Or is this a scenario where you have a very wide column and
you want to print more than just one column? Also, can you please give me
the model of the Epson printer you're printing to? Do you have access to
another printer, and if so, do you see the problem on that printer too?
If you have a file that shows the problem, feel free to email that to me
too: patm...@microsoft.com.
Thanks,
Pat
On 3/24/08 3:06 AM, in article ee888...@webcrossing.caR9absDaxw,
"Mag...@officeformac.com" <Mag...@officeformac.com> wrote:
--
Pat McMillan
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
Paul Honeywell
egl...@firstalliedcorp.com
> Even though I insert page breaks manually, it is still wrong when I try to print out. Even the "Fit to" does not work. This is really bad :angry:
With all do respect - removing page break preview is a disaster. its
impossible to get docs to print they way I want. Before I just moved
lines now im trying to insert page breaks, then file print preview
(this is nonsense also)
There is an old saying - leave well enough alone!!
clearly whomever removed these 2 features does not use excel for
business on a daily basis
Jim Gordon MVP
> On Apr 4, 7:27 am, "Paul Honeywell" <p...@the-storytellers.com> wrote:
>
Should be "With all due respect..."
I miss page break preview and print preview, too.
-Jim
--
Jim Gordon
Mac MVP
MVPs are independent experts who are not affiliated with Microsoft.
http://mvp.support.microsoft.com/
CyberTaz
On 4/6/08 1:12 PM, in article OKsvllAm...@TK2MSFTNGP03.phx.gbl, "Jim
Gordon MVP" <gold...@warmerthanwarmmail.com> wrote:
> MVPs are independent experts
<snip>
Speak for yourself, John - the last fool to call *me* an expert wound up
having to prove in court why he shouldn't be confined to an asylum;-)
Regards |:>)
Bob Jones
[MVP] Office:Mac
CyberTaz
> <snip>
>
> Speak for yourself, John
Obviously that should be *Jim* - see what I mean???
Phillip Jones
about this less than stellar upgrade to Office
That's even got MVP's Flustered. :D
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |pjo...@kimbanet.com, ICQ11269732, AIM pjonescet
------------------------------------------------------------------------
If it's "fixed", don't "break it"!
mailto:pjo...@kimbanet.com
<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>
Jim Gordon MVP
> Don't feel bad its all this angst, and tension of answering questions
> about this less than stellar upgrade to Office
>
> That's even got MVP's Flustered. :D
>
> CyberTaz wrote:
>>> <snip>
>>>
>>> Speak for yourself, John
>> <snip>
>>
>> Obviously that should be *Jim* - see what I mean???
>>
>> Regards |:>)
>> Bob Jones [MVP] Office:Mac
>>
>
Not a paid celebrity, either.
--
Jim Gordon
Mac MVP
MVPs are not affiliated with Microsoft.
http://mvp.support.microsoft.com/
Hayl...@officeformac.com
JE McGimpsey
Hayl...@officeformac.com wrote:
> I am livid about this, as it makes the forms I have worked hard to create
> basically unusable.
See my reply to your other post - there's no reason the forms should be
unusable.
pec3...@yahoo.com
> How do you adjust the print area like you would with page break preview on a pc?
If you select File>Page Setup, then "Adjust to", then select View, choose Page Layout, then switch back to Normal (Page Layout will now be unchecked), you will now see dotted lines in your worksheet that you can drag to force page breaks where you want them.