ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting the default properties for cells in all new spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/259436-setting-default-properties-cells-all-new-spreadsheets.html)

Bon Bon

Setting the default properties for cells in all new spreadsheets
 
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?

Bernard Liengme[_2_]

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?




All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com