up vote 1 down vote favorite
share [g+] share [fb]

I have a Protected Microsoft Excel Spreadsheet. Every time I open it and try to print, Excel wants to split into 8 pages. If I cancel the print and drag the dashed line to the right, then I can make it print in just 2 pages. Unfortunately this information is not saved when I save the file.

Is there any way to save this information?

link|improve this question
83% accept rate
feedback

1 Answer

up vote 1 down vote accepted

You might try dragging the page break as you have, then create a custom view that saves the current state as 'normal' or some other name. It may be you print settings or page setup and margins are overriding things.

View>Custom Views>

Custom View Dialog

Then Name it

Name the view

Saving custom views are a great way to assert a page setup in a macro

But I would further investigate page setup and margins as well, because that may be the cause of the problem

link|improve this answer
That's interesting; how do you create a custom view? – vy32 May 27 '11 at 21:16
sorry, this is Excel 2003, and the same can be done in the later versions – datatoo May 27 '11 at 21:26
And so it can. Thank you very much. This seems to do it! – vy32 May 28 '11 at 22:23
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.