How can I keept Excel from splitting cells on print page?

I know this function exists somehow, I've seen it, but can't find it. Basically, I have some cells that take up several rows within the same cell. Some of these cells end up at the bottom of the page, and carry partially over to the next page. How can I tell Excel to never split the information? As in, if the entire cell doesn't fit on the first page, then send ALL of the cell to the second page, not just part of it.





Thanks in advance.How can I keept Excel from splitting cells on print page?
Move your page break line. If you move the page break line up it will force your cell down onto the top of the next page.How can I keept Excel from splitting cells on print page?
thats not what you need to do...

Report Abuse

ok this is what i think you need to do.. once your done with your spreadsheet. highlight everything you want to get printed. Before you print, to go file, select print area, and select set print area. Before you print, go to print preview and see if you want it landscape or portrait. Then it would show exactly how it will show up.
You need to select your print area. Select the information, then go to File...Print Area...set Print Area. Then if it is still doing it you need to go to Page Setup and change the scaling to a lower %...that should do it. If you still have problems email me....bmoviegurl@yahoo.com
Go to ';File'; ';Page Setup'; and click on ';fit to: 1 pages tall by 1 pages wide';...
make do not split on page set up and remember to do print preview to make sure
Make do not split on page setup.