print preview

[bjm]

Is there a multipage print preview?
Or just the one-at-a-time with next/previous options?

I'd like to get an overall eyeball view (as I can in, say, Word).
Thanks.
bj

 

[Don Guillett]

If you mean multiSHEET, this may help

for each ws in worksheets
ws.printpreview
next

 

[bjm]

If you mean multiSHEET, this may help

for each ws in worksheets
ws.printpreview
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

No, multi-sheet preview didn't even occur to me.
I mean one sheet that's multipage when printed.
I also don't understand your answer anyway.
Where do you type in/choose (?) ws.printpreview?
Is that a menu option? function? program (where?) other????

Note that I am *not* an "advanced user" -- I'm very basic & plodding. I've
never gone through figuring out how to do automatically (i.e. "program") a
lot of things I need to do only occasionally (maybe only once), I just futz
around using the brute-force method & that's that. I don't use a lot of
complicated functions, lists, calls, etc. etc. etc.
Thanks.
bj

 

[Klemen25]

You could try under menu view- page break privew, and than zoom out to
get a better view (use ctrl + scroll on your mouse).
Otherwise I dont think you can see for instance 6 sheets at once in
print preview lik in word.

Excel 2007 on other hand has this noew function under view- page
layout- here you can see many sheets as in word.
Hope this helps

 

[bjm]

Yes, thank you, that is a big help.
Maybe "next time" they could add the multi-page print-preview like in Word
but at least this is something.
bj