| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Display page breaks automatically
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? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Display page breaks automatically
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" wrote: 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? |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Display page breaks automatically
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. "john" wrote: 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" wrote: 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? |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Display page breaks automatically
Ice man
ToolsOptionsViewPage 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 On Thu, 22 Feb 2007 06:54:10 -0800, Ice Man wrote: 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. "john" wrote: 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" wrote: 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? |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Display page breaks automatically
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" wrote: Ice man ToolsOptionsViewPage 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 On Thu, 22 Feb 2007 06:54:10 -0800, Ice Man wrote: 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. "john" wrote: 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" wrote: 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? |
|
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Display page breaks automatically
Probably the easiest method.
Gord On Thu, 22 Feb 2007 11:46:45 -0800, Ice Man wrote: 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" wrote: Ice man ToolsOptionsViewPage 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 On Thu, 22 Feb 2007 06:54:10 -0800, Ice Man wrote: 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. "john" wrote: 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" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
| Automatically enter page breaks? | Excel Worksheet Functions | |||
| Page breaks | Excel Worksheet Functions | |||
| Page Breaks | Excel Worksheet Functions | |||
| How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Hybrid Mode
