View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Styles are stored with each workbook.

So you could create a workbook that has the normal style you want. Then save
this workbook as a template for all new workbooks.

If that's what you want to do:
Start a new workbook.
Format|style|Modify
(and modify it to your heart's content)

Also, modify anything else you want as a standard--header/footers, page
orientation, number of worksheets in that workbook???

Now save it as a template in your XLStart folder as book.xlt

Then when you click on that New icon, the new workbook will inherit all those
settings.

===
You could create another template named sheet.xlt (stored in the same XLStart
folder) and any new worksheet you add to an existing workbook will inherit those
properties.


Randy Maheux wrote:

How can I chnage the Normal style in Excel 2000 so that new worksheets begin
with the cell formatting set to center vertically?


--

Dave Peterson