Hi,
1. If you want it for all future workbooks then Bob's solution is best.
Note you never need to manually open the template because it will be the
default workbook that opens when you start Excel and it will open anytime you
click the New button.
2. If you want the changes for a specific workbook - select all the sheet
tabs, click the top left corner of any one, and set the alignment and wrap
text options. The deselect and ungroup.
3. If you want it for a single sheet - Click the top left corner of the
spreadsheet to select the entire worksheet, as above, and then set the
options. This will apply to all the cells on the selected sheet.
4. You could make a regular template - meaning that it is not stored in the
XLStart folder, and open that whenever you wanted these features. (this
sounds like just what you don't want).
5. There are no built in Excel settings for setting these two features as
the defaults.
