Display page breaks automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ice Man - 22 Feb 2007 14:40 GMT

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?

Reply to this Message

john - 22 Feb 2007 14:48 GMT

You could always add the page break icon onto a toolbar then it is only one
click

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> 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?

Reply to this Message

Ice Man - 22 Feb 2007 14:54 GMT

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.

> You could always add the page break icon onto a toolbar then it is only one
> click
>
> > 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?

Reply to this Message

Gord Dibben - 22 Feb 2007 18:53 GMT

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

>This suggestion certainly eases the task.
>Are you also saying there is no way to add a tag to the start string that
[quoted text clipped - 7 lines]
>> > go through 'Tools', 'Options', 'View' and select 'Page Breaks' under Window
>> > Options every time I open a file?

Reply to this Message

Ice Man - 22 Feb 2007 19:46 GMT

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

> Ice man
>
[quoted text clipped - 24 lines]
> >> > go through 'Tools', 'Options', 'View' and select 'Page Breaks' under Window
> >> > Options every time I open a file?

Reply to this Message

Gord Dibben - 22 Feb 2007 20:24 GMT

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.
[quoted text clipped - 29 lines]
>> >> > go through 'Tools', 'Options', 'View' and select 'Page Breaks' under Window
>> >> > Options every time I open a file?

Reply to this Message