Nov 28 2020 04:29 PM
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.
Nov 29 2020 03:58 AM
SolutionSwitch 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.
Dec 11 2020 11:06 AM
Apr 18 2022 07:53 AM
This 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?
Apr 18 2022 08:31 AM
It 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.
Apr 18 2022 08:49 AM - edited Apr 18 2022 09:52 AM
Thanks Hans, I was just hoping for a method similar to Word: select the rows and choose "keep rows together".
Apr 18 2022 11:20 AM
I'm afraid that Excel does not have a similar feature.
Oct 12 2022 12:17 PM - edited Oct 12 2022 12:23 PM
I have a grocery list I am working on that is 14 pages long, many items are not required. I did edit column a under conditional formatting for any number greater than 0 to be highlighted and bolded. Is there a formula that excel can select rows greater than 0 in column a ?
for printing only what I want to look for in store.
example of page JPG
https://drive.google.com/file/d/13eGiuE65O6HTT2ajzd39to69Td2XYoO-/view?usp=sharing
Excel File:
I fell I am close to figuring it out but stuck on this usually print 15 pages
Any assistance would be appreciated
Thank You
Oct 12 2022 01:52 PM
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<>" "),""))
Oct 14 2022 02:27 AM
thanks will try this
Nov 29 2020 03:58 AM
SolutionSwitch 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.