Display page breaks automatically

[Ice Man]

How can I cause excel files to always view page breaks rather than having to
go through 'Tools', 'Options', 'View' and select 'Page Breaks' under Window
Options every time I open a file?

 

[john]

You could always add the page break icon onto a toolbar then it is only one
click
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Ice Man]

This suggestion certainly eases the task.
Are you also saying there is no way to add a tag to the start string that
will automatically turn on the view page breaks?
Thanks.

 

[Gord Dibben]

Ice man

Tools>Options>View>Page Breaks just shows page breaks by dotted lines on the
sheet.

Do you mean "page break preview" which is a different animal and is found on the
menu bar under "View"?

Either one is window-only function.

To have either for each sheet and workbook would require VBA code.

You can store this setting in a Template for NEW books and Sheets but that won't
affect existing sheets and workbooks.


Gord Dibben MS Excel MVP

 

[Ice Man]

Thank you Gord. I was referring to the dashed line at the bottom and side of
the page, not the break line in the print preview.
I'll use John's short cut from now on.
Larry

 

[Gord Dibben]

Probably the easiest method.

Gord

Thank you Gord. I was referring to the dashed line at the bottom and side of
the page, not the break line in the print preview.
I'll use John's short cut from now on.
Larry