I had to register and lost the original location of the answer to my question.
I needed to delete blank pages from an Excel 2010 worksheet that did not show in page layout view, but did in print preview. The end users of this form were just as frustrated as I was trying to get those last sheets gone.
I want to thank the poster (and I apologize for not noting your name) who gave me the tip that worked!
The problem, as well as I could determine it, was that there was so much formatting within the document (I inherited this, not created it), that the last cell location was incorrect, and even when I was successful at moving the last cell, five extra pages were still ready for printing.
The poster suggested looking in the Page Layout tab, under Set Up, then click on Print Area. To reset the Home and Last cells, I cleared all and then using Control End set the last cell, and Control Home to set the first cell.
It works!! I couldn't be happier. I am very new to using Excel properly, so all tips and tricks are very much appreciated, and I felt this poster deserved props for the good and accurate advice. I followed other suggestions, including ones from Microsoft, and they couldn't solve the problem.
Thank you,
Amington
I needed to delete blank pages from an Excel 2010 worksheet that did not show in page layout view, but did in print preview. The end users of this form were just as frustrated as I was trying to get those last sheets gone.
I want to thank the poster (and I apologize for not noting your name) who gave me the tip that worked!
The problem, as well as I could determine it, was that there was so much formatting within the document (I inherited this, not created it), that the last cell location was incorrect, and even when I was successful at moving the last cell, five extra pages were still ready for printing.
The poster suggested looking in the Page Layout tab, under Set Up, then click on Print Area. To reset the Home and Last cells, I cleared all and then using Control End set the last cell, and Control Home to set the first cell.
It works!! I couldn't be happier. I am very new to using Excel properly, so all tips and tricks are very much appreciated, and I felt this poster deserved props for the good and accurate advice. I followed other suggestions, including ones from Microsoft, and they couldn't solve the problem.
Thank you,
Amington