Thank You!!

amington

New Member
Joined
Dec 11, 2014
Messages
1
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
amington,

Welcome to the MrExcel forum.

The following may help you find the thread.

At the top right area in the MrExcel opening/main screen, after you log in:

click on Advanced Search

in the Keywords box type in with the quote marks "Page Layout"

in the Additional Options area:

Find Posts Any date, and, pick A Month Ago

and click on the Search Now button
 
Last edited:
Upvote 0

Forum statistics

Threads
1,225,698
Messages
6,186,521
Members
453,361
Latest member
Stacas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top