Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 26th 08, 07:38 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 553
Default Changing IN NEW SHEETS the default color of Grid Lines

About some time back T Valko & Gord quite helped me a lot in changing the
gridlines' by default to be to Pale Blue color upon everytime I open the
MS-Excel by using XLStart.

However, the only problem is that while the great idea is working great,
upon inserting an additional sheet (Shift+F11) the new sheet is again in the
old Excel format?

Any idea how to takeover the same!


  #2   Report Post  
Old February 26th 08, 08:26 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Changing IN NEW SHEETS the default color of Grid Lines

Open a new workbook
Delete all the sheets except Sheet1
Set the gridlines to the desired color
Now, save this file as filename Sheet.xlt
Also save this file in your XLStart folder

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
About some time back T Valko & Gord quite helped me a lot in changing the
gridlines' by default to be to Pale Blue color upon everytime I open the
MS-Excel by using XLStart.

However, the only problem is that while the great idea is working great,
upon inserting an additional sheet (Shift+F11) the new sheet is again in
the
old Excel format?

Any idea how to takeover the same!



  #3   Report Post  
Old February 26th 08, 10:01 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 553
Default Changing IN NEW SHEETS the default color of Grid Lines

Sorry Biff,

But still the same problem is faced!

"T. Valko" wrote:

Open a new workbook
Delete all the sheets except Sheet1
Set the gridlines to the desired color
Now, save this file as filename Sheet.xlt
Also save this file in your XLStart folder

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
About some time back T Valko & Gord quite helped me a lot in changing the
gridlines' by default to be to Pale Blue color upon everytime I open the
MS-Excel by using XLStart.

However, the only problem is that while the great idea is working great,
upon inserting an additional sheet (Shift+F11) the new sheet is again in
the
old Excel format?

Any idea how to takeover the same!




  #4   Report Post  
Old February 26th 08, 05:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Changing IN NEW SHEETS the default color of Grid Lines

Hmmm...

It works for me. I don't know any other way to do it.


--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
Sorry Biff,

But still the same problem is faced!

"T. Valko" wrote:

Open a new workbook
Delete all the sheets except Sheet1
Set the gridlines to the desired color
Now, save this file as filename Sheet.xlt
Also save this file in your XLStart folder

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
About some time back T Valko & Gord quite helped me a lot in changing
the
gridlines' by default to be to Pale Blue color upon everytime I open
the
MS-Excel by using XLStart.

However, the only problem is that while the great idea is working
great,
upon inserting an additional sheet (Shift+F11) the new sheet is again
in
the
old Excel format?

Any idea how to takeover the same!








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
Changing the default color of Grid Lines FARAZ QURESHI Excel Discussion (Misc queries) 4 February 23rd 08 07:06 PM
Excel 2002: How to reveal grid lines on color shaded worksheet? Mr. Low Excel Discussion (Misc queries) 3 April 27th 07 05:37 PM
printing grid lines when grid lines is checked fergos Setting up and Configuration of Excel 1 October 4th 05 02:55 AM
Be able to re-color INDIVIDUAL grid lines in excel charts John Canino Charts and Charting in Excel 1 May 15th 05 05:04 AM
Make default insert sheet to have grid lines Bruce Roberson New Users to Excel 4 January 20th 05 12:27 AM


All times are GMT +1. The time now is 10:06 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017