Excel 2016 - Remove stubborn page break

Dancarro

Board Regular
Joined
Feb 23, 2013
Messages
65
Hi,

I have an issue with a page break on a worksheet and I tried everything to remove but nothing of nothing happens.

I tried Page Layout< Breaks< Remove Page Break (does nothing, the page break lines still there)

I again, tried placing cursor under the page break line and backspace and the step above (nothing again). I also tried to reset All Page Breaks and desperate I tried clear print areas, nothing happens. I still see the page breaks, I think I am going crazy.

Please, any help to solve this will be much appreciated.

Regards,
Dan
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,036
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Then by the sounds of it you column widths/font size/margins etc. are too big to fit on the one page for your paper size and so you are getting the automatic page breaks.

If that is the case I'm surprised with the below if you set the paper size to A3

changing the paper size nothing happens

If that is what is happening then you need to adjust them.

I delete it and now the page break has gone to the last column in the worksheet.
The above makes it sound like you have data/hidden characters/possibly formatting in cells past those columns.
What does
VBA Code:
ActiveSheet.UsedRange.Columns.Count
give you?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Watch MrExcel Video

Forum statistics

Threads
1,129,320
Messages
5,635,559
Members
416,864
Latest member
geordieben

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