Forum Discussion
Solved
page break for every line
my work involves inserting page break manually for every line upto 100 lines each time. Is there any shortcut key for that? I have attached sample file. Can i get help
So the Subtotal method provided works exactly as you need. All that you need to add is a Filter, then filter Text Contains 'Count' then select and delete those rows.
I'm imagining some sort of invoice system or similar. Using your Excel file as Data Source you could use Word Mail Merge to get each record on a page. This page, https://www.ablebits.com/office-addins-blog/2014/07/15/excel-page-break/, shows an interesting sample using Subtotals. Maybe that might work for you.
If not, please provide sample data.
I have attached sample file
So the Subtotal method provided works exactly as you need. All that you need to add is a Filter, then filter Text Contains 'Count' then select and delete those rows.
Thanks Chris, it worked