Template formatting disappears

  • Thread starter Thread starter GeoBrooks
  • Start date Start date
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
 
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

Similar Threads

Set default cell format while retaining overrides 3
Importing data from Excel worksheet into Excel template 2
Insert sheet template loses page setup (2010) 2
blank lines in text cells 4
2003/2007 Compatibility Question 5
Is there a template option for Workbooks.Add(xlWBATWorksheet)? 6
Problem with Time Format when using a Template 2
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top