View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GeoBrooks GeoBrooks is offline
external usenet poster
 
Posts: 24
Default 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