When I select to insert a page break, it is not inserting.

[Guest]

I have a spreadsheet that is set up to print to fit on one page. However,
when I try to insert a page break to split up that page, horizontally or
vertically, it is NOT inserting. However, if I set up to print at 100% its
size, it's 16 pages long, page breaks will appear, but I don't want to break
up 16 pages. Help!

 

[Dave Peterson]

Next time you're in file|page setup|page tab, set it to print 1 page wide by 1
page tall.

Ok your way out of the dialog.

Then go right back into that file|page setup|Page tab.

Note the "adjust to" percentage.

It's probably less than 100%.

Select the "adjust to" option and then see if your manual page break shows up.

(I think that sometimes I even reduce the percentage (slightly) to make it fit
pretty.)