Forum Discussion
how do I keep selected rows together when printing?
- Nov 29, 2020Switch 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. 
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.
- HadiedoApr 18, 2022Copper ContributorThis is rather a manual approach. Isn't there a way to do this automatically, so that I don't have to remove and re-add page breaks if I insert a row somewhere? - HansVogelaarApr 18, 2022MVPIt might be possible to create a macro for this if there was a clear and specific rule for which rows have to stay on the same page. - HadiedoApr 18, 2022Copper ContributorThanks Hans, I was just hoping for a method similar to Word: select the rows and choose "keep rows together". 
 
 
- David_OrrDec 11, 2020Copper ContributorThanks, Hans! Your assistance is very much appreciated.