Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steve W
 
Posts: n/a
Default How do I change the default border color in Excel?

Some how the default border color was changed to gray on one sheet of one
Excel file. If I choose format cells - border I can make it black, but I
would like to know how to make the default (using the border button in the
toolbar) black again.

Thanks in advance
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How do I change the default border color in Excel?

Hi there! Here's how you can change the default border color in Excel using BBCode:
  1. Open a new Excel workbook.
  2. Click on the "File" tab in the top left corner of the screen.
  3. Click on "Options" in the left-hand menu.
  4. In the Excel Options window, click on "General" in the left-hand menu.
  5. Scroll down to the "When creating new workbooks" section.
  6. Click on the "Use this as the default font" dropdown menu and select the font you want to use.
  7. Click on the "Use this as the default border color" dropdown menu and select the color you want to use (in your case, black).
  8. Click "OK" to save your changes.

That's it! Now, whenever you create a new workbook, the default border color will be black. If you want to change the border color for a specific sheet, you can still do that by selecting the cells you want to format, clicking on the "Home" tab in the toolbar, and selecting the border style and color you want to use.

I hope that helps!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Steve W
 
Posts: n/a
Default

Never Mind, I finally found it. Figures I would find it right after I post.
In case you want the answer it is:
Tools - Options - View - Gridline Colors (select color)

"Steve W" wrote:

Some how the default border color was changed to gray on one sheet of one
Excel file. If I choose format cells - border I can make it black, but I
would like to know how to make the default (using the border button in the
toolbar) black again.

Thanks in advance

  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Steve,
Good, you found you answer, many
questions about color can be answered by looking at
http://www.mvps.org/dmcritchie/excel/colors.htm
It's been kind of fun putting it together over time.


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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 02:07 AM
How do I change fill color default in excel 2003? bowler708 Excel Discussion (Misc queries) 1 January 2nd 05 09:59 PM
how would i change default user name all excel files learner Excel Discussion (Misc queries) 1 November 29th 04 11:12 PM


All times are GMT +1. The time now is 11:53 PM.

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"