View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Changing the default color of Grid Lines

Default is generally

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 01:06:15 -0500, "T. Valko" wrote:

If you want the colored gridlines to be the default for *every new
workbook*:

Open a new workbook
Goto ToolsOptionsView tabGridlines color
Select the desired color
OK out

Save this file as your default:
Goto FileSave As
File name: Book
Save as type: Template (*.xlt)
Save in: your XLStart directory

Where that is on your computer I don't know. On my machine its path is:

C:\Program Files\Microsoft Office\Office10\XLStart