Remove page break

Hi,
There is one page break between Column A and column B below. How to remove the page break?6a
LVL 11
HuaMin ChenSystem AnalystAsked:
Who is Participating?
 
akbCommented:
You could try increasing the margins or select fit columns to page when printing.
0
 
matrix8086Commented:
Depending on you Excel version ...

Look at Layout section ...
0
 
ProfessorJimJamCommented:
run this in a module.

Sub test()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets

ws.Cells.PageBreak = xlPageBreakNone

Next ws
End Sub

Open in new window

0
 
ProfessorJimJamCommented:
or if you want it automatic , when everytime excel opens then

Private Sub Workbook_Open()

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets

ws.Cells.PageBreak = xlPageBreakNone

Next ws


End Sub

Open in new window

0
 
Rob HensonFinance AnalystCommented:
If you put the file into Page Break Preview mode, the fixed page breaks will be a solid line and the variable breaks based on page size and print settings will be hashed lines.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.