Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
B Walsh
 
Posts: n/a
Default how do I change the default background color in excel?

I want to change the background to light gray instead of white as the default
setting for all cells.
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
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
how to change default comment format in excel (2000) superiorparties Excel Discussion (Misc queries) 1 February 3rd 05 12:43 AM
Change the default chart colours TonyJD Charts and Charting in Excel 2 January 20th 05 01:06 AM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 7th 05 11:43 PM
Where to stick macro to change default comment font? [email protected] Excel Discussion (Misc queries) 1 January 1st 05 12:57 AM
How can I change the default 'comma' format. Eg paranthesis inste. Duncan Excel Discussion (Misc queries) 1 December 4th 04 12:51 AM


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

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

About Us

"It's about Microsoft Excel"