+ Reply to Thread
Results 1 to 2 of 2

change default fill color

Hybrid View

  1. #1
    Shawn
    Guest

    change default fill color

    I have been searching the net and the KB but can not find answer or
    solution to this problem. I want my excel cell auto fill color to default
    to light grey instead of yellow. Is this possible? And if so, how do I do
    it?

    Thanks for any help you can provide.

    Shawn

  2. #2
    Debra Dalgleish
    Guest

    Re: change default fill color

    You can create a new default template, with grey as the default fill
    colour:

    Create a new, blank workbook.
    Choose Tools>Options
    On the Colour tab, click on the yellow square
    Click Modify, select light grey that you want to use as the default,
    click OK
    To make yellow available, select the light grey square, and change it to
    yellow, click OK.
    Choose File>Save As
    From the Save As Type dropdown, choose Template (*.xlt)
    Name the File "Book.xlt"
    Save it in the XLStart folder
    (you can search for this -- in Windows XP it may be in
    C:\Documents and Settings\UserName\
    Application Data\Microsoft\Excel)

    When you start Excel, or click the New button on the toolbar, the new
    workbook will be based on this template.


    Shawn wrote:
    > I have been searching the net and the KB but can not find answer or
    > solution to this problem. I want my excel cell auto fill color to default
    > to light grey instead of yellow. Is this possible? And if so, how do I do
    > it?
    >
    > Thanks for any help you can provide.
    >
    > Shawn



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1