Margins, footers etc

[Stoat]

Hello

I am trying to print a landscape page, with headers and footers, with
the sheet fit to 1x1 page. I want to have footnotes at the bottom of
the page, which I am doing just by inserting enough rows manually
until the sheet starts to get squashed width-wise (before footnotes,
the sheet is significantly wider than it is tall, so it is the width
that is driving the shrinkage factor)

However, it does not let me get the footnotes at the bottom of the
page. When in Page Layout view (in 2007) it includes six blank rows
below the bottom line (outside of the print area). It is as if the
margin for the active area of the worksheet (ie excluding any headers
or footers) ends about an inch above the top of the footer. My margin
settings are not unusual, as far as I know (Top and Bottom are 2.5,
Header and Footer are 1.3).

Can anyone help?

Robert

 

[Pete_UK]

Check that your print area includes all the cells that you want to
print.

Hope this helps.

Pete

 

[Stoat]

Unfortunately the print area is not the solution. Whether I define
the print area to be just the area I want (ie no extra lines below the
bottom footnote), or allow Excel to work out the active area to be
printed and fit on one page, the same occurs.

When in Page Layout view, if I select a cell, it selects the whole
range from the cell selected to the bottom row of the page (ie the row
~6 rows below the bottom footnote). I assume that this is related,
but a symptom of the same problem.

 

[Pete_UK]

I thought that you meant that your footnotes are not being printed,
but now it seems that they are, so what's the problem? Under Page
Setup | Margins tab you can choose to Center the printed page
horizontally and/or vertically. Is this what you want?

Pete

 

[Stoat]

Thanks for getting back to me.

Yes, my footnotes are being printed. In a way, the fact that they are
footnotes is irrelevant, it's just that I want them to be at the
bottom of the printed page, so have inserted rows accordingly.

I have done everything I can think of to resolve this, and am a fairly
advanced Excel user, so am comfortable with all the print area etc
sort of things. I am less sure about headers, footers, margins etc,
so have assumed that this is where it is going wrong.

Maybe the easiest way to explain the problem is this. If I look at
the sheet, on Print Preview, and show the margins, there are two
horizontal lines, one about 1cm from the bottom of the screen, and
another about 1.5cm above that line. These lines are (1) the bottom
of the printable area, and (2) the top of the footer, I assume. Above
the second line, there is a gap of about an inch or so, of blank
space. My footnotes appear above this gap. It prints as if I had
included an extra six rows of blank space within the print area, under
my bottom footnote. Obviously I have checked that I have not done
this!

I can set up a new document, and don't have the same problem, but it
affects a few files I am working on, and don't really want to have to
do this. Also, I'd like to get to the bottom of what it causing it,
to stop it if it happens again.

Robert

 

[Pete_UK]

I see what you mean now. You said earlier that it is the width of the
sheet which determines the scale applied to the page as your page is
not very deep, so the only way around your problem that I know of is
to insert blank rows above your footnotes to move them down. Check on
what this looks like in Print Preview, and keep adjusting until you
are happy with the result.

Your comments about the (bottom) margins are correct - one governs the
space allowed for the footer and the other determines how much of the
sheet will get printed on that page. These can overlap.

Another approach might be to put your footnotes within the footer. You
won't be able to see them in the normal view, but at least this will
keep them at the bottom of the printed page, and they can spill over
to new lines.

Hope this helps.

Pete

 

[Stoat]

Thanks. I had thought about footnotes in the footer, it might work
but it's useful to have them on-screen as well.

As I say in my first message, I tried inserting extra rows, simply in
order to end up with an active printed area that has dimensions
roughly A4 in size, as that means my footnotes would end up printing
at the bottom.

The problem I have, is that if I insert any additional rows, the blank
space at the bottom stays the same, and the width of the page
decreases. If I insert 500 rows between table and footnote, but still
made to fit to one page, the printed table is tiny in the top left
hand corner of the page, and the footnotes are tiny, but still are not
at the bottom of the page (ie they are still about 1 inch above the
top of the footer).

I should probably give up on this, but it is really quite annoying!

Robert

 

[Pete_UK]

Why don't you adjust the bottom margins (by dragging them) to reduce
that 1" of space between the footnotes and the footer?

Another way of getting space between the table and footnotes instead
of inserting rows is just to increase the row height of a few rows
between them.

Pete