You would like to control the page
breaks regularly for a printable
configuration of tables and so you are
looking for an option to turn on the
page break display.
In Excel you can easily view the page breaks by selecting the Page Break Preview option. You can also change to normal view again and see the dotted markings of the paging there. However, it remains only so long as the worksheet is open. Once you reopen the worksheet you will have to redo the Page Break Preview in order to see the page breaks. You can easily automate the Page Break Preview option with the help of a simple Macro.
Open the relevant workbook and then VBA editor with the key combination [Alt] + [F11]. Now search the open file to the upper left in the project explorer and find “This workbook” in the structure below it.
Open the related code window on it with a double click. If the code frame is no prepared yet, open via the upper combination fields “Workbook” and “Open”. Then enter the code as under:
Private Sub Workbook _ Open()
Dim i As Integer
For i = 1 To ThisWorkbook.
Sheets.Count
Sheets(i).
DisplayAutomaticPageBreaks =
True
Next i
End Sub
Save the macro and close the workbook. Make sure that the Macros are active for the workbook, when you open the file next time the sheets will automatically have the page breaks. If you have added new sheets you will have to save the workbook and reopen them to see the changes. If the preview is not required later, remove the Macro from the workbook.
In Excel you can easily view the page breaks by selecting the Page Break Preview option. You can also change to normal view again and see the dotted markings of the paging there. However, it remains only so long as the worksheet is open. Once you reopen the worksheet you will have to redo the Page Break Preview in order to see the page breaks. You can easily automate the Page Break Preview option with the help of a simple Macro.
Open the relevant workbook and then VBA editor with the key combination [Alt] + [F11]. Now search the open file to the upper left in the project explorer and find “This workbook” in the structure below it.
Open the related code window on it with a double click. If the code frame is no prepared yet, open via the upper combination fields “Workbook” and “Open”. Then enter the code as under:
Private Sub Workbook _ Open()
Dim i As Integer
For i = 1 To ThisWorkbook.
Sheets.Count
Sheets(i).
DisplayAutomaticPageBreaks =
True
Next i
End Sub
Save the macro and close the workbook. Make sure that the Macros are active for the workbook, when you open the file next time the sheets will automatically have the page breaks. If you have added new sheets you will have to save the workbook and reopen them to see the changes. If the preview is not required later, remove the Macro from the workbook.
0 comments:
Post a Comment
please write your comment
Note: Only a member of this blog may post a comment.