View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default default gridlines style

Open a new workbook
Delete all except one sheet
Goto ToolsOptionsView tabGridlines color
Select the desired color/style
Goto FileSave As
File name: Book
Save as type: Template (*.xlt)
Save in: C:\Documents and Settings\username\Application
Data\Microsoft\Excel\XLSTART
Again
Goto FileSave As
File name: Sheet
Save as type: Template (*.xlt)
Save in: C:\Documents and Settings\username\Application
Data\Microsoft\Excel\XLSTART
Close & Reopen the Excel.
Do give me a feedback if any problem occurs

--

Best Regards,
FARAZ A. QURESHI


"mprothro" wrote:

I need to find out how to change the gridline style in Excel. The system I
am on has black dotted gridlines (like the dotted style borders) and I would
like to change them to the solid, light grey gridlines. I am in Excel 2003.