Template formatting disappears

G

GeoBrooks

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
 
G

GeoBrooks

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top