Forum Discussion

David_Orr's avatar
David_Orr
Copper Contributor
Nov 29, 2020
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 ...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Nov 29, 2020

    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.

captdave1961's avatar
captdave1961
Copper Contributor
Oct 12, 2022

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:

https://docs.google.com/spreadsheets/d/1xvlYl2DmExApBcFTIa7ENpQqJ9Pn3m-a/edit?usp=sharing&ouid=109305136649436484745&rtpof=true&sd=true

 

I fell I am close to figuring it out but stuck on this usually print 15 pages

Any assistance would be appreciated

Thank You

 David_Orr 

 

 

HansVogelaar's avatar
HansVogelaar
MVP
Oct 12, 2022

captdave1961 

 

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<>" "),""))

Resources