Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

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

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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