View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default Setting the default properties for cells in all new spreadsheets

The basic answer is to save the workbook as Sheet.xlt and Book.xlt (or
Sheet.xltx and Book.xltx in Excel 2007) in the XLSTART folder.
More details at
http://office.microsoft.com/en-us/ex...548151033.aspx
This is for Excel2000 but the ideas are the same fro all versions
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Bon Bon" <Bon wrote in message
...
How can I set the default properties of spreadsheet cells (e.g.- always
vertically centred, word wrap, Aerial 10point) so that the cells in all
new
spreadsheets are created with these attributes?