Thread: Excel Template
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel Template

Start a new workbook.
Format the cells the way you want.
Save it as a template file named book.xlt in your XLStart folder.

Excel will use that template workbook when you create a new workbook by clicking
on the new icon on the standard toolbar.

You can create a workbook named Sheet.xlt in the same XLStart folder and any new
worksheet added to an existing workbook will inherit those settings.

Ps. Remember where you saved this file--you'll want to find it and delete it
when you realize how irritating it will be <vbg.

Mari wrote:

Hi,

is there any way to change the excel "new" (blank) template, like you can
with Word? The reason I ask is that I would like each new excel workbook to
automatically be formatted with all the cells in "date" format, instead of
"general". Is this possible?

m-


--

Dave Peterson