Excel Tables and Page Breaks

J

Joek

I have an issue on an Excel 2007 worksheet.

I have three Excel Tables (lists) on a sheet. Each table meeds to be
printed on a separate page.

I have inserted page breaks at the required sheet row. However when I
insert a row in a table - by right mouse click in a table and selecting
Insert, Table Row - a row is inserted in the table but the sheet page preaks
do not move accordingly i.e. as further roes are inserted the page break will
eventually be within the table.

Any advice would be greatly appreciated. I look forward to receiving
replies. Thanks in advance

JK
 
D

Don Guillett

You could use an identifier or a helper column with a number or text and
have a FINDNEXT in a before print macro set the page break at each one
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
Cover Page - Use "Next Page Break" rather then Page Break 0
Use "Next Page Break" instead of "Page Break" on the cover page. 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel --> Word 4
Space at end of multi page list to accommodate new entries 1
Repeating a row other than the 1st row as the header row in a table from next page 1
Section and Page numbering 0

Top