Forum Discussion
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.
4 Replies
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.
