Forum Discussion
Solved
how do I keep selected rows together when printing?
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 ...
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.
Do you have Microsoft 365 or Office 2021, or do you use Excel Online? If so, you can use the FILTER function.
On another sheet:
=IF(FILTER(Sheet1!A11:G523,(Sheet1!A11:A523>0)*(Sheet1!A11:A523<>" "),"")="","",FILTER(Sheet1!A11:G523,(Sheet1!A11:A523>0)*(Sheet1!A11:A523<>" "),""))
thanks will try this