Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .