Template formatting disappears
 

In XL2007, sp1:

I've created a worksheet template for adding a sheet of instructor comments
to student workbooks. The template has formulas in A1:A10 to add a comment
number. Both columns A & B are formatted for top vertical alignment. Column
B is formatted for column width = 60 and word wrapping. The tab is named
"Instructor Comments".

The template is applied by right-clicking on the worksheet tabs, selecting
Insert and my template. Yet when added to the student's workbook, column B's
formatting for top alignment and word wrap is missing. All the other formats
and contents are present.

Is this expected behavior, or did I miss something in class that day?

George

Template formatting disappears
 

Additional info:

In a previous version of this template, there was no formula in A1:A10. And
all formatting remained when the template is applied.

gwb

"GeoBrooks" wrote:

In XL2007, sp1:

I've created a worksheet template for adding a sheet of instructor comments
to student workbooks. The template has formulas in A1:A10 to add a comment
number. Both columns A & B are formatted for top vertical alignment. Column
B is formatted for column width = 60 and word wrapping. The tab is named
"Instructor Comments".

The template is applied by right-clicking on the worksheet tabs, selecting
Insert and my template. Yet when added to the student's workbook, column B's
formatting for top alignment and word wrap is missing. All the other formats
and contents are present.

Is this expected behavior, or did I miss something in class that day?

George