How To Set Default Line Color In Excel

If the regular blackness borders are not doing it for you lot and your organization senses are screaming for gild, color sorting will practice what nothing else tin. Many a fourth dimension information technology may not be practical to change the font color. While colour fill is another good sorting friend, this tutorial is all well-nigh changing border colors.

Why switch out of blackness borders? Yous could be befitting to a format (all receipts ink in blue), color-coding columns, or maybe your fancy rainbow streak is on. Today y'all will learn how to change border colors using your cursor like a digital color pencil, using some quick keys and Format Cells, and fifty-fifty changing the default border color. All that sits right below, so let's start digging.

• Change Border Color From Ribbon
• Alter Border Color Using Format Cells Dialog
• Alter Border Color Using Keyboard Shortcut
• Change the Default Border Colour
  • Change the Gridlines Colour
  • Set a Custom Tabular array Style

Alter Edge Color From Ribbon

The easiest approach on the Excel horizon is the ribbon with its all-encompassing menu. The little border icon will instantly tell you where to await. Let's find out what lies there.

• The Font section in the Home tab has a small border icon with a little arrow for a drop-down menu; click it.

• From the drop-down menu, hover on to Line Color and click on your choice of edge color.

• Once chosen, you will notice the cursor has inverse to a pencil icon.
• Click on the borders to change their color.

• Printing the Esc cardinal to return to the original cursor. The border pen can be used equally a pen and not just as a color-irresolute tool.
• To add new borders, click on the gridlines where y'all want to add together borders.

• Clicking and dragging volition add a square border.

• Clicking and dragging beyond a prison cell tin add a square border and with a chip of corner-to-corner angling, you can add a diagonal border beyond a cell.

Treatment borders from the ribbon is a very open option equally you speedily become to switch between colors, edge styles and add or erase borders in a matter of a few clicks, non to mention the ease of admission.

This was the mouse-savvy way of changing border colors from the ribbon. The keyboard-savvy way is in the segment beneath.

Change Border Color Using Format Cells Dialog

Borders come under the band of cell formatting and then we can employ the Format Cells options to change edge colors. Here'southward how to arrive at the edge settings using the Format Cells dialog:

• Select the cells with the borders requiring color modify.
• Printing Ctrl + i to launch the Format Cells dialog box or click the arrow with the border icon in the Home tab's Font Select More Borders… from the bill of fare.

• In the Border tab, pick the color of choice from the Color menu and the style (if need be) from the Style department
• Utilise the Border buttons surrounding the sample field to enter the borders.
• For each change in colour and/or manner, y'all will need to choose from the respective menus and add them using the Edge buttons.

• Click OK when done.

Equally y'all tin come across, ease of access for our case is a scrap hindered by this option, having to make separate selections for separate edge styles every time.

Still, for dealing with a repetitive border or a big number of cells, Format Cells would fare well with all the options open in display in one window.

Change Border Color Using Keyboard Shortcut

The shortcut keys for changing the jail cell border colour are:

Alt, H, B, I

Enter the keys 1 later the other, not together.

Alt displays the shortcut keys for the ribbon tabs.

H selects the Home tab.

B opens the border bill of fare.

I selects Line Color from the bill of fare.

This is how to apply this keyboard shortcut to alter border color:

• Press the keys Alt, H, B, I one later the other.

• Select the color of choice from the Line Color

• One time the color is selected, the cursor will change to a pencil icon which will exist your border pen until you printing the Esc key.
• Click on the borders to modify their color.
• Select the style of the edge from the border menu, if need be.

Recommended Reading: How to Rotate Text in Excel

Change the Default Border Color

Let's say you're not floating well with having to modify the edge color to the aforementioned color every time! With a bit of background tweaking, you can have your go-to border color ready to default. Ane method is to hack the color of the gridlines forcing border colors to follow suit. The other is to ready a Table Style. Permit'south look into them.

Change the Gridlines Color

When you lot modify the color of the gridlines, the default colour of the borders (which is black) changes to the same color every bit the gridlines but a darker tone. Hence, the colour yous cull for the gridlines should exist lighter than the default color y'all want to set up for the borders. Find the steps for this below:

• Go to the File tab on the worksheet.
• Select Options from the left pane.

• Select Advanced from the left panel of the Excel Options
• Ringlet down to the Brandish options for this worksheet: section and select the color for the gridlines (a shade lighter than the intended default border colour).

• Click OK.

The color of the gridlines will be inverse now:

When you lot add a border, by default it will exist a darker shade than the color of the gridlines:

Ready a Custom Table Style

Setting a custom table style can accept your borders come out the same way every time you lot select them from Tabular array Modes. Follow these steps to prepare a custom table format:

• Select the dataset to be fabricated into a tabular array.
• From the Habitation tab, in the Styles grouping, click on the Format as Table
• Select New Table Mode… from its menu.

• In the New Table Way dialog box, select:
  • Whole Table from the Table Element listing
  • the Ready as default table manner for this document checkbox
  • the Format button to open the Format Cells dialog box.

• Set the border colors and border styles of preference.
• Then click OK on both windows.

• At present select the custom fashion from the Domicile tab > Styles group > Format equally Tabular array

• A pop-upwardly will appear to confirm the tabular array selection.
• Cheque the My table has headers checkbox if the selected dataset has headers.
• Click OK.

The borders will appear in the ready color and style:

This method is quite handy for bordering tables and tabular data. Y'all may even choose a preset style.

Permit's current of air upwardly things up now. This tutorial showed y'all a few options to change the cell border color in Excel. The Excel ribbon serves as a very free-hand option for quick borders in multiple colors and styles. The other options are helpful for repeating tasks and set ways. There'due south a shoe for every fit! We're working on more than shoes and will exist quick for the fitting, your Excel example very much similar our Cinderella!

Source: https://exceltrick.com/how_to/change-border-color/

Posted by: georgeowere1993.blogspot.com

Share this post