I thought I actually posted about this some time back, but I don’t see it. It’s driven me nuts before, and is doing it again.
I have to print out our massive financial model for a meeting tomorrow. It’s almost 120 pages, and is laid out in a mix of colour and black and white, landscape and portrait settings.
The first time I ever saw this I was floored, as I thought Excel was turning each page just to drive me nuts. As it happens, it’s a little more predictable (although no less annoying.)
When I print my model, here’s the output of the pages:
Colour pages (landscape):
Colour pages (portrait):
Okay, so no biggie. I’d rather have the top of the colour landscape pages on the left so I didn’t need to turn them before putting in a left hand binding, but at least it’s consistent. At least, it is until I start mixing in some non-colour worksheets:
Black & white (landscape):
Rotated 180 degrees from the colour worksheet! What the heck is that about? (Yes, Top should be written the other way up, I just wanted this to be easy to read.)
Black & white (portrait):
Seriously? 180 degree rotation from colour again?
Run that out for a bit…
So now picture that you’ve got 120 pages, mixed colour and black and white, mixed landscape and portrait. I need to bind at the left, and want the top of the pages to be consistently like the colour landscape and portrait black and white, so the I can bind them on the left side. I’m going dizzy trying to sort this out!
There’s no setting to change this that I can find, so it’s a process of going through each pile of paper, one sheet at a time, to make sure none get missed. What a waste of time!
I’m not sure if this is a printer thing, or an Excel thing. It did it in Excel 2010, and is doing it in 2013.
I’m curious, if you have a colour printer, do you see similar effects?