+ Reply to Thread
Results 1 to 6 of 6

Excel Default Font Colour

Hybrid View

  1. #1
    Registered User
    Join Date
    04-10-2016
    Location
    Bangladesh
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    68

    Excel Default Font Colour

    Hlw I wants to change my default excel colour will be black now it is Grey. And now I am using office 2010.
    What can i do ?

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Excel Default Font Colour

    Hi

    Try:-

    Click File on menu
    Select Options
    The first window allows a choice of Colourful, Grey, Black or white.

    This applies for 2016, I am not sure whether the same ability was available in 2010.

    Cheers

  3. #3
    Registered User
    Join Date
    04-10-2016
    Location
    Bangladesh
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    68

    Re: Excel Default Font Colour

    No option found on 2010

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,051

    Re: Excel Default Font Colour

    My 2016 just had color, Dk Grey or Wht, but 2010 should have the same options
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: Excel Default Font Colour

    One way to do this is to save a new version of Book1.xlsx to the XLStart folder after creating a new default theme

    1 Open a New File
    2 Click on Page Layout Tab
    3 Click on Colors
    4 Click on Customise Colors
    5 Change the first 4 lines (all text)
    6 Amend the name at the bottom
    7 And click on save
    This is now the theme of the current book

    Now you must save the workbook (the name must be Book1) to the your XlStart folder
    (search for it if you do not know where it is!)

    Close the file and close Excel

    When you next open a new file it will have the style of your new Book1


    CustomiseColors.jpg


    DefaultTextColour.jpg


    XLstart.jpg
    Last edited by Kevin#; 05-21-2016 at 11:57 AM.
    If a response has helped then please consider rating it by clicking on *Add Reputation below the post
    When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,051

    Re: Excel Default Font Colour

    It's under General/Personalize Your Copy

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change default font and font size on COMMENTS in cells
    By Thistledown in forum Excel General
    Replies: 4
    Last Post: 11-23-2012, 09:26 AM
  2. Default Comment format (colour, font)
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-12-2011, 03:20 AM
  3. Changed default font, previous font still shows when editing
    By Font/Editing Problem in forum Excel General
    Replies: 0
    Last Post: 05-18-2006, 11:45 AM
  4. [SOLVED] Setting default font and colour
    By Chandramouly in forum Excel General
    Replies: 1
    Last Post: 04-27-2006, 06:50 AM
  5. How do I set the default font for hyperlinks in Excel?
    By antbedy in forum Excel General
    Replies: 1
    Last Post: 04-24-2006, 03:40 PM
  6. Change permanantly default chart settings like colour, font..
    By utopian_sorceror in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-19-2005, 02:05 AM
  7. How can I set a default font for a comment in Excel?
    By Juliana in forum Excel General
    Replies: 1
    Last Post: 06-22-2005, 06:05 PM
  8. [SOLVED] Default font in Excel
    By DenverGal in forum Excel General
    Replies: 1
    Last Post: 06-08-2005, 11:05 AM

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