Margins do not fit page size

[Laura]

Hi, all of a sudden, for no apparent reason whenever I try to print
one of the pages of my excel workbook I get the following error
message pop up "margins do not fit page size", and the page looks
scrambled. When I click away from the page and click back it is
unscrambled and all in order again, but it will not print. Also, when
I pres the save button I get the same message, although the file seems
to be saving fine. I have had to resort to taking screen prints of
these particular pages and printing them in word, not ideal! I have
looked at view / page break, and the blue lines are nicely situated
around the small amount of text that I want to print, I have also
tried highlighting the cells I want to print (not that man of them),
and gone to file, print area / set print area/ then adusted the
margins and asked it to print to one page etc etc, and all the other
variations of that sort of activity you can think of, but still it
keeps coming back with this message.

I have used this file with no problems for months, and I am not aware
of anything specific being changed including the printers themselves.

Please help!

 

[Laura]

Hi, all of a sudden, for no apparent reason whenever I try to print
one of the pages of my excel workbook I get the following error
message pop up "margins do not fit page size", and the page looks
scrambled.  When I click away from the page and click back it is
unscrambled and all in order again, but it will not print.  Also, when
I pres the save button I get the same message, although the file seems
to be saving fine.  I have had to resort to taking screen prints of
these particular pages and printing them in word, not ideal!  I have
looked at view / page break, and the blue lines are nicely situated
around the small amount of text that I want to print, I have also
tried highlighting the cells I want to print (not that man of them),
and gone to file, print area / set print area/ then adusted the
margins and asked it to print to one page etc etc, and all the other
variations of that sort of activity you can think of, but still it
keeps coming back with this message.

I have used this file with no problems for months, and I am not aware
of anything specific being changed including the printers themselves.

Please help!

Hi, further to this I have just looked at another workbook that seems
to be doing exactly the same thing, I have gone to preview page
breaks, and it looks like each cell is being definded as a page, I
suppose this would account for why it thinks it cant print all these
'pages' on one A4 sheet like I am asking it to, but does anyone know
how I can tell it that the infomation belongs to one page, not 500
individual ones??

 

[Bruce Sinclair]

Hi, further to this I have just looked at another workbook that seems
to be doing exactly the same thing, I have gone to preview page
breaks, and it looks like each cell is being definded as a page, I
suppose this would account for why it thinks it cant print all these
'pages' on one A4 sheet like I am asking it to, but does anyone know
how I can tell it that the infomation belongs to one page, not 500
individual ones??

Sounds like you have somehow inserted page breaks between each cell (insert/
break/page break while a group of cells is selected perhaps ?). Either that
or your 'zoom' is set 6000 % + ?
What do you see when you look at the print preview ?

 

[Laura]

Sounds like you have somehow inserted page breaks between each cell (insert/
break/page break while a group of cells is selected perhaps ?). Either that
or your 'zoom' is set 6000 % + ?
What do you see when you look at the print preview ?- Hide quoted text -

- Show quoted text -

Hi Bruce, you are right, zoom is normal at 100% but when I went to the
page break preview page I could see that each cell was somehow a page,
I dont know how that happened, but I couldnt find a way of removing
the breaks, so what I have just done is copied it onto a new page
without thousands of page breaks, and that seems to have done the
trick. Thanks for giving me the lead.