How do I insert a page break between every row and column?
 

I am making flash cards and the info is on excel. How do I insert a page
break between every row and column? I did it once but have no idea how is
happened.
Thanks
Ashley

How do I insert a page break between every row and column?
 

With a macro like

Sub insertPageBreak()
For i = 2 To 10
ActiveSheet.Rows(i).PageBreak = xlPageBreakManual
ActiveSheet.Columns(i).PageBreak = xlPageBreakManual
Next
End Sub

Change 10 to whatever you want...

"Ashley" wrote:

I am making flash cards and the info is on excel. How do I insert a page
break between every row and column? I did it once but have no idea how is
happened.
Thanks
Ashley

How do I insert a page break between every row and column?
 

thanks for the reply! i am very new to excel and do not really understand
what u are saying, is it possible for u to put it in a simpler term
ash

"Sheeloo" wrote:

With a macro like

Sub insertPageBreak()
For i = 2 To 10
ActiveSheet.Rows(i).PageBreak = xlPageBreakManual
ActiveSheet.Columns(i).PageBreak = xlPageBreakManual
Next
End Sub

Change 10 to whatever you want...

"Ashley" wrote:

I am making flash cards and the info is on excel. How do I insert a page
break between every row and column? I did it once but have no idea how is
happened.
Thanks
Ashley