Page Break Removes Bottom Border of Table

CaptainFat

New Member
Joined
Apr 27, 2021
Messages
1
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
So I have made a table in my excel worksheet for a Purchase Order template. A user can insert as many rows as they want into the table. This causes an issue when the number of rows in the table exceeds the number of rows on the page. The page break that excel generates removes the bottom border of the table. So when users try to print off the template, the bottom border at every page break is missing (example attached). Is there a way to force excel to not remove the bottom border of a table at a page break? Also I don't have the option to write any sort of VBA to try and reinsert the bottom border of the table at every page break.

-Thanks
 

Attachments

  • example.PNG
    example.PNG
    31.2 KB · Views: 4

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
798
Office Version
  1. 365
Platform
  1. Windows
I assume you are not using an actual Excel Table structure and that you have manually formatted it.
My expectation is that if you were to look at the border setting of a cell that it would have have top border set but not a bottom border.
Simply add a bottom border to each row.

The way it looks to me, each individual cell's borders should look like this:-

1619591888976.png
 

Watch MrExcel Video

Forum statistics

Threads
1,132,708
Messages
5,654,854
Members
418,155
Latest member
demasisi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top