Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to change the background to light gray instead of white as the default
setting for all cells. |
#2
![]() |
|||
|
|||
![]()
Open a new workbook. Customize as you wish. FileSave As Type: scroll down
to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for FileNewWorkbook. Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP On Wed, 16 Mar 2005 06:45:04 -0800, "B Walsh" <B wrote: I want to change the background to light gray instead of white as the default setting for all cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to change default comment format in excel (2000) | Excel Discussion (Misc queries) | |||
Change the default chart colours | Charts and Charting in Excel | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
Where to stick macro to change default comment font? | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) |