T
Trish
Make a workbook template:-----Original Message-----
Upon opening a spreadsheet, my column width formatting
seems to have a life of its own and resets column widths,
regardless of how they were set prior to saving and
closing. This requires me to reset the width every time I
re open the file. It does not happen on all files. Is
there a "super" default or some bug causing this?
Any help would be appreciated.
.
This might help:
Workbook template
Create a workbook that contains one worksheet. On the
worksheet, include the formatting, styles, text, and other
information you want to appear on all new sheets of the
same type.
On the File menu, click Save As.
In the Save as type box, click Template and save it where
you want to retreive it from
To create the default workbook template or default
worksheet template, select either the XLStart folder or
the alternate startup folder. The XLStart folder is
usually
C:\Program Files\Microsoft Office\Office10\XLStart
To create a custom workbook or worksheet template, select
the Templates folder, which is usually
C:\Documents and Settings\user_name\Application
Data\Microsoft\Templates
Enter the name of the template in the File name box. Do
one of the following:
Workbook template
Type book to create the default workbook template.
To create a custom workbook template, type any valid file
name.
Worksheet template
Type sheet to create a template for default worksheets.
To create a custom sheet template, type any valid file
name.
Click Save, and then click Close on the File menu.