Saving changes to option to apply all the time.

  • Thread starter Thread starter Stuart A
  • Start date Start date
S

Stuart A

I would like to make changes in excel options, to select 'set precision as
displayed' which i can do in each time, but i want this option selected for
each time i open a new sheet and to apply to all my previous sheets when
opened and to update the sheet with this option in mind.

Using Excell 2000 and 2007. Home/Work

Thanks
 
Since it is a workbook setting, existing workbooks could not be changed.

--Open a new workbook.

--From menu File>Save As Type>select 'Excel Template(*.XLT). Save as Book so
that the file is saved as Book.XLT

--Place this workbook in the XLSTART folder
C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART

--This will be the default workbook if you go by File>New

I am currently using 2003..You can try the same in 2007.

If this post helps click Yes
 
Back
Top