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? |
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