Changing the default color of Grid Lines

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

I want to change the gridlines' by default to be changed to Pale Blue color.

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

Open a new workbook
Goto Tools>Options>View tab>Gridlines color
Select the desired color
OK out

Save this file as your default:
Goto File>Save 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
 
XLent!!

Thanx Pal! It was in Office12!

It means I can make all such changes for future as default settings?
 
Default is generally

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing IN NEW SHEETS the default color of Grid Lines 3
How do I permanently set grid line color 4
2003 grid lines 3
Change default fill color of selected cells? 4
Changing the color of highlighted cells 1
Change Color of cell 3
display gridlines with fill color 1
GRIDLINES 7 FILL COLOR 4

Back
Top