Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 14th 07, 09:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 12
Default Change Default Font in Excel for Document Only?

Does anyone know how to/if I can change the font for an entire document
without changing it for every document thereafter?

  #2   Report Post  
Old March 14th 07, 09:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Change Default Font in Excel for Document Only?

Start a new workbook.
Set up everything you want--headers/footers/layout/font...
Save it as book.xlt in your XLStart folder.

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

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.


exflirt wrote:

Does anyone know how to/if I can change the font for an entire document
without changing it for every document thereafter?


--

Dave Peterson
  #3   Report Post  
Old March 15th 07, 09:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 12
Default Change Default Font in Excel for Document Only?

Thanks, but I'm don't think that's what I'm trying to do. I don't want to
change how every document operates, just a specific document. For example, I
have a document titled Client Information and I would like to set it so that
every cell I type in has Garamond font, but I don't want to change my default
font for Excel documents. Does that make sense? Does anyone know how to do
this?

"Dave Peterson" wrote:

Start a new workbook.
Set up everything you want--headers/footers/layout/font...
Save it as book.xlt in your XLStart folder.

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

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.


exflirt wrote:

Does anyone know how to/if I can change the font for an entire document
without changing it for every document thereafter?


--

Dave Peterson

  #4   Report Post  
Old March 15th 07, 10:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Change Default Font in Excel for Document Only?

Right-click on a sheet tab and "Select all sheets"

CTRL + a(twice in 2003) to select all cells.

FormatCellsFontGaramondOk your way out.

Right-click on a sheet tab and "ungroup sheets"


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 13:20:35 -0700, exflirt
wrote:

Thanks, but I'm don't think that's what I'm trying to do. I don't want to
change how every document operates, just a specific document. For example, I
have a document titled Client Information and I would like to set it so that
every cell I type in has Garamond font, but I don't want to change my default
font for Excel documents. Does that make sense? Does anyone know how to do
this?

"Dave Peterson" wrote:

Start a new workbook.
Set up everything you want--headers/footers/layout/font...
Save it as book.xlt in your XLStart folder.

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

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.


exflirt wrote:

Does anyone know how to/if I can change the font for an entire document
without changing it for every document thereafter?


--

Dave Peterson


  #5   Report Post  
Old March 15th 07, 10:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 12
Default Change Default Font in Excel for Document Only?

By golly, I think that did it! Thank you SO much - little by little you guys
are helping me with my Excel issues!!

"Gord Dibben" wrote:

Right-click on a sheet tab and "Select all sheets"

CTRL + a(twice in 2003) to select all cells.

FormatCellsFontGaramondOk your way out.

Right-click on a sheet tab and "ungroup sheets"


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 13:20:35 -0700, exflirt
wrote:

Thanks, but I'm don't think that's what I'm trying to do. I don't want to
change how every document operates, just a specific document. For example, I
have a document titled Client Information and I would like to set it so that
every cell I type in has Garamond font, but I don't want to change my default
font for Excel documents. Does that make sense? Does anyone know how to do
this?

"Dave Peterson" wrote:

Start a new workbook.
Set up everything you want--headers/footers/layout/font...
Save it as book.xlt in your XLStart folder.

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

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.


exflirt wrote:

Does anyone know how to/if I can change the font for an entire document
without changing it for every document thereafter?

--

Dave Peterson





  #6   Report Post  
Old March 15th 07, 11:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Change Default Font in Excel for Document Only?

I thought you wanted to change that setting once and never have to change it
again.


Glad Gord helped you.

exflirt wrote:

Thanks, but I'm don't think that's what I'm trying to do. I don't want to
change how every document operates, just a specific document. For example, I
have a document titled Client Information and I would like to set it so that
every cell I type in has Garamond font, but I don't want to change my default
font for Excel documents. Does that make sense? Does anyone know how to do
this?

"Dave Peterson" wrote:

Start a new workbook.
Set up everything you want--headers/footers/layout/font...
Save it as book.xlt in your XLStart folder.

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

If you want the same thing when you add a new worksheet to an existing workbook,
save another workbook (probably a single sheet???) in that same XLStart
folder--but name it Sheet.xlt.


exflirt wrote:

Does anyone know how to/if I can change the font for an entire document
without changing it for every document thereafter?


--

Dave Peterson


--

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
How do I change the default font color in Excel? DaveT Excel Discussion (Misc queries) 2 May 31st 06 06:49 PM
Change default font format in Excel Michael Lortz Excel Discussion (Misc queries) 3 December 17th 05 02:47 AM
Is it possible to change the default font in Excel comments? GZul Excel Discussion (Misc queries) 1 December 6th 05 01:30 AM
Change default font and size in Comments box in Excel. ArtieF Setting up and Configuration of Excel 3 September 19th 05 05:27 PM
How do I change the default font for comment boxes in Excel cljforbes Excel Discussion (Misc queries) 2 July 19th 05 12:29 PM


All times are GMT +1. The time now is 07:56 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017