Excel 2010 ignoring bottom margin when printing.

Lythande

Board Regular
Joined
Oct 3, 2006
Messages
160
I selected two pages worth of rows and "Print Selection" printed them, but Excel 2010 printed on top of the stuff I put in the footer--in fact it ignored the margin settings altogether for the bottom for some reason--it printed right up the edge of the paper. It didn't do this with the same set up in Excel 2007--what am I overlooking?
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Lythande

Board Regular
Joined
Oct 3, 2006
Messages
160
I selected 1.9 for both the top and bottom. In the print preview under for the 200 page document Excel honours the margins nicely, but when I select two pages worth of rows and print/print preview (with Print Selection selected under Settings) the bottom margin gets blown out, so to speak, and the text appears on top of my footer right to the bottom edge of the page. Very odd.
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
The Bottom margin needs to be greater than the Footer margin, because the former includes the latter (although I can't reproduce your problem in Print Preview).
 

Lythande

Board Regular
Joined
Oct 3, 2006
Messages
160

ADVERTISEMENT

The problem didn't occur in XL2007 under the same setting circumstances--another part of the mystery is in custom footer I inputted stuff* to make it label the pages 1 of 200, 2 of 200, etc..., but even though I selected enough rows for two pages the print prieview shows 1 of 1 with the bottom margin blown out as described. Most annoying.

*PAGE &[PAGES] OF &[PAGES]

Again, when Print Active Sheets is selected under Settings, the margins as is work as they should...even when I scroll down to to where the two pages work of lines are. It's only when I have Print Selection selected for highlighted cells that the bottom margin is disrespected by XL10.

I appreciate your attempt to help though, thanks Andrew.
 

Lythande

Board Regular
Joined
Oct 3, 2006
Messages
160
Okay, if I select the cells and rows (A-Q, 98-184) the bottom margin is honoured. It's only when I select these cells via highlighting the row numbers alone (i.e. the column of numbers to the left of A column) that the margin gets messed up. It worked fine in XL2007, but not so in XL10. I can live with the workaround though.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,431
Messages
5,528,734
Members
409,831
Latest member
KT50

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top