SOLVED

how do I keep selected rows together when printing?

%3CLINGO-SUB%20id%3D%22lingo-sub-1938141%22%20slang%3D%22en-US%22%3Ehow%20do%20I%20keep%20selected%20rows%20together%20when%20printing%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938141%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20long%20document%20and%20I%20have%20pairs%20of%20rows%20that%20need%20to%20stay%20together%20on%20one%20page%20but%20Excel%20breaks%20them%20up.%20How%20do%20I%20keep%20them%20together%3F%20Word%20has%20a%20command%20that%20does%20that%20to%20selected%20rows%20but%20I%20can't%20find%20anything%20in%20Excel.%20Any%20help%20is%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1938141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938530%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20I%20keep%20selected%20rows%20together%20when%20printing%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938530%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F884499%22%20target%3D%22_blank%22%3E%40David_Orr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESwitch%20to%20Page%20Break%20Preview.%3C%2FP%3E%0A%3CP%3EWorking%20from%20the%20top%20down%2C%20if%20you%20see%20a%20row%20just%20above%20a%20page%20break%20that%20should%20be%20kept%20with%20the%20next%20row%2C%20right-click%20any%20cell%20in%20that%20row%20and%20select%20Insert%20Page%20Break%20from%20the%20context%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1980818%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20I%20keep%20selected%20rows%20together%20when%20printing%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1980818%22%20slang%3D%22en-US%22%3EThanks%2C%20Hans!%20Your%20assistance%20is%20very%20much%20appreciated.%3C%2FLINGO-BODY%3E
New Contributor

I have a long document and I have pairs of rows that need to stay together on one page but Excel breaks them up. How do I keep them together? Word has a command that does that to selected rows but I can't find anything in Excel. Any help is appreciated.

2 Replies
best response confirmed by David_Orr (New Contributor)
Solution

@David_Orr 

Switch to Page Break Preview.

Working from the top down, if you see a row just above a page break that should be kept with the next row, right-click any cell in that row and select Insert Page Break from the context menu.

Thanks, Hans! Your assistance is very much appreciated.