Default view for new worksheets

[Mauricio]

I like my worksheets at 150%, in normal view, and without page break lines. Excel thinks it is best for me to have them at 100% and in page view. Converting them takes three steps - change to normal view, change to 150%, and go to preferences and remove page breaks.

My standard template (the workbook file) is set so that any new file I create will display empty worksheets just as I like them. Any additional worksheets, however, follow the Excel defaults rather than the template defaults. Unchecking the "display page breaks" box in the view preferences only seems to affect the active worksheet.

What I want is that any worksheet I add (by clicking on the + tab at the bottom of the window) appear just as the ones in the template - 150% view, normal view, no page breaks. Is there a way to accomplish this?

 

[Bob Greenblatt]

I like my worksheets at 150%, in normal view, and without page break lines.
Excel thinks it is best for me to have them at 100% and in page view.
Converting them takes three steps - change to normal view, change to 150%, and
go to preferences and remove page breaks.

My standard template (the workbook file) is set so that any new file I create
will display empty worksheets just as I like them. Any additional worksheets,
however, follow the Excel defaults rather than the template defaults.
Unchecking the "display page breaks" box in the view preferences only seems to
affect the active worksheet.

What I want is that any worksheet I add (by clicking on the + tab at the
bottom of the window) appear just as the ones in the template - 150% view,
normal view, no page breaks. Is there a way to accomplish this?

Just like you built your workbook template, make one for a worksheet, and
store it in the same place. Name it worksheet (no extension). Now when you
add a worksheet, it will use the new template.

 

[Mauricio]

That sounded like a good idea, but it doesn't work. I duplicated the Workbook template (which contains a single worksheet) and renamed it worksheet. I made sure there was no extension (even adding one and then removing it), and I tried both capital and lowercase w for the beginning of the name. I restarted Excel several times. The path where the files are stored is Applications - Microsoft Office 2008 - Office - Startup - Excel. Is there something wrong?

 

[JE McGimpsey]

That sounded like a good idea, but it doesn't work. I duplicated the Workbook
template (which contains a single worksheet) and renamed it worksheet. I made
sure there was no extension (even adding one and then removing it), and I
tried both capital and lowercase w for the beginning of the name. I restarted
Excel several times. The path where the files are stored is Applications -
Microsoft Office 2008 - Office - Startup - Excel. Is there something wrong?

Your template name is incorrect.

From XL08 Help ("Control how workbooks and sheets are created" topic,
"Change the format and settings for new sheets" section):

 

[Mauricio]

Thanks, that worked. The only glitch is that all new sheets, instead of being named Sheet2, Sheet3, etc, are now named Sheet2 (2), Sheet3 (2), etc. That I can live with.

 

[JE McGimpsey]

The only glitch is that all new sheets, instead of being named Sheet2,
Sheet3, etc, are now named Sheet2 (2), Sheet3 (2), etc. That I can live with.

I'll bug it anyway...