Column width formatting

T

Trish

-----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:
Make a workbook template:

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.
 

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