Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Margins do not fit page size
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Margins do not fit page size
On 10 Sep, 10:11, Laura wrote:
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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Margins do not fit page size
In article , Laura wrote:
On 10 Sep, 10:11, Laura wrote: 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. =A0When I click away from the page and click back it is unscrambled and all in order again, but it will not print. =A0Also, when I pres the save button I get the same message, although the file seems to be saving fine. =A0I have had to resort to taking screen prints of these particular pages and printing them in word, not ideal! =A0I 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?? 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 ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Margins do not fit page size
On 11 Sep, 00:40,
(Bruce Sinclair) wrote: In article , Laura wrote: On 10 Sep, 10:11, Laura wrote: 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. =A0When I click away from the page and click back it is unscrambled and all in order again, but it will not print. =A0Also, when I pres the save button I get the same message, although the file seems to be saving fine. =A0I have had to resort to taking screen prints of these particular pages and printing them in word, not ideal! =A0I 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?? 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i fix error message 'margins do not fit page size' | Excel Discussion (Misc queries) | |||
margins and page size in worksheet | New Users to Excel | |||
margins do not fit page size | Excel Discussion (Misc queries) | |||
Margins do not fit page size! | Excel Discussion (Misc queries) | |||
"Margins do not fit page size" error, but I'm not printing! | Excel Discussion (Misc queries) |