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.
|