| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting custome RGB properties to specific cells | Excel Discussion (Misc queries) | |||
| Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
| How do I set default footer setting on excel spreadsheets? | Excel Worksheet Functions | |||
| Setting Tab Properties in Excel | Excel Discussion (Misc queries) | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Hybrid Mode
