Default format settings

[Bob]

I would like to be able to set Cell Format defaults of:
- Text alignment>Vertical>TOP
- Text control>Wrap text
for every blank spreadsheet I start.

Can I determine these defaults? How?

 

[Bernie Deitrick]

Bob,

Open a new workbook, and delete all but one sheet.

Select all the cells, and set the formatting as you want it.

Then save the workbook as a template named Sheet.xlt in your default startup
folder (look in Tools | Options | General tab, Alternate startup file
location OR in your default xlstart folder, which you can find using
Find)

HTH,
Bernie
MS Excel MVP