Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How to create default template in Excel 2002

Hey there,

I am using Excel 2002 on Window 2000 version.

I already have an Excel template called "abc".

It contains four worksheets with fonts and colors I want.

I want to save this "abc" template to the default one.

So that, when I am in Excel, I just need to click "New", this "abc"
template will come up by default.

I don't want to waste time selecting from a list of template. Just
click "new" icon.


Any way to do this?

Which folder should I tackle?

Thanks

cheers

  #2   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default How to create default template in Excel 2002

Place it as book1.xls in the XLSTART folder.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...
Hey there,

I am using Excel 2002 on Window 2000 version.

I already have an Excel template called "abc".

It contains four worksheets with fonts and colors I want.

I want to save this "abc" template to the default one.

So that, when I am in Excel, I just need to click "New", this "abc"
template will come up by default.

I don't want to waste time selecting from a list of template. Just
click "new" icon.


Any way to do this?

Which folder should I tackle?

Thanks

cheers



  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How to create default template in Excel 2002

I bet Anne meant: Book.xlt (not book1.xls)

And save it as a template file.

Anne Troy wrote:

Place it as book1.xls in the XLSTART folder.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...
Hey there,

I am using Excel 2002 on Window 2000 version.

I already have an Excel template called "abc".

It contains four worksheets with fonts and colors I want.

I want to save this "abc" template to the default one.

So that, when I am in Excel, I just need to click "New", this "abc"
template will come up by default.

I don't want to waste time selecting from a list of template. Just
click "new" icon.


Any way to do this?

Which folder should I tackle?

Thanks

cheers


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How to create default template in Excel 2002

And don't hit the FileNew...(note the ellipsis)

Just use FileNew(no ellipsis) or the New File Icon.


Gord Dibben MS Excel MVP

On Fri, 27 Jan 2006 08:47:16 -0600, Dave Peterson
wrote:

I bet Anne meant: Book.xlt (not book1.xls)

And save it as a template file.

Anne Troy wrote:

Place it as book1.xls in the XLSTART folder.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...
Hey there,

I am using Excel 2002 on Window 2000 version.

I already have an Excel template called "abc".

It contains four worksheets with fonts and colors I want.

I want to save this "abc" template to the default one.

So that, when I am in Excel, I just need to click "New", this "abc"
template will come up by default.

I don't want to waste time selecting from a list of template. Just
click "new" icon.


Any way to do this?

Which folder should I tackle?

Thanks

cheers


  #5   Report Post  
Posted to microsoft.public.excel.misc
Anne Troy
 
Posts: n/a
Default How to create default template in Excel 2002

LOL. I tested book1 and it worked. But I'm sure book would be better! :)
Thanks, Dave!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Dave Peterson" wrote in message
...
I bet Anne meant: Book.xlt (not book1.xls)

And save it as a template file.

Anne Troy wrote:

Place it as book1.xls in the XLSTART folder.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...
Hey there,

I am using Excel 2002 on Window 2000 version.

I already have an Excel template called "abc".

It contains four worksheets with fonts and colors I want.

I want to save this "abc" template to the default one.

So that, when I am in Excel, I just need to click "New", this "abc"
template will come up by default.

I don't want to waste time selecting from a list of template. Just
click "new" icon.


Any way to do this?

Which folder should I tackle?

Thanks

cheers


--

Dave Peterson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Create Excel Log automatically from Template CaymanCarrie Excel Worksheet Functions 0 October 12th 05 04:40 PM
Setting a default save folder for a template postitnote100 Excel Discussion (Misc queries) 1 July 8th 05 09:30 PM
Excel 2003 formats different that excel 2002 Rich Excel Discussion (Misc queries) 0 April 22nd 05 05:43 PM
Template in Excel prettytwin1 New Users to Excel 1 March 9th 05 10:22 PM


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"