How to Change Cell Border Color in Google Sheets

Ever found yourself staring at a wall of numbers and data in Google Sheets, wishing you could make it more visually appealing? One simple way to do this is by changing the border color of your cells. Let's explore how you can achieve this in a few easy steps.

How to Automatically Change Cell Color in Google Sheets
How to Automatically Change Cell Color in Google Sheets

Before we dive in, ensure you're working with Google Sheets and have a basic understanding of how to select cells. Once you're ready, let's get started!

How to color cells and alternate row color in Google Sheets
How to color cells and alternate row color in Google Sheets

Changing Individual Cell Border Color

If you want to change the border color of a single cell, you can do so with just a few clicks.

How to change certain cells borders color at once in Google Spreadsheets
How to change certain cells borders color at once in Google Spreadsheets

First, select the cell whose border color you wish to change. Then, click on the 'Format' menu in the toolbar above. In the dropdown, select 'Conditional formatting'.

Using Pre-set Border Colors

How to Change Your Google Sheets Theme Color
How to Change Your Google Sheets Theme Color

Google Sheets provides a range of pre-set border colors. To use one of these, follow these steps:

  1. In the 'Conditional formatting' panel, under the 'Format cells if...' dropdown, select 'No formatting rules'.
  2. Under 'Formatting style', select 'Custom format'.
  3. In the 'Custom format' field, click on the format icon (pipe-shaped symbol).
  4. In the 'Border' section, choose the border style you want (like 'Thick border').
  5. Click on the colored box next to 'Border color'. A palette will appear. Choose the color you like.
  6. Click 'OK'. The selected cell's border will now sport the color you chose.

Creating Custom Border Colors

How to Merge or Split Cells and Tables in Google Sheets
How to Merge or Split Cells and Tables in Google Sheets

If you can't find the color you want in the palette, you can create your own custom color. Here's how:

  1. After clicking on the colored box in step 5 above, click 'More colors...' at the bottom of the palette.
  2. In the 'Custom color' field, you can input the RGB or HEX color code you want to use. Alternatively, you can adjust the sliders to create your desired color.
  3. Once you've created your color, click 'OK' to apply it to the border.

Changing Multiple Cell Border Colors

Google Sheets: How to Alternate Row or Column Colors
Google Sheets: How to Alternate Row or Column Colors

Changing the border color of multiple cells at once is even easier than changing a single cell. Here's how:

First, select the cells whose borders you want to change. Then, click on the 'Borders' option in the toolbar. A palette will appear.

How to Use Alternate Colors in Google Sheets
How to Use Alternate Colors in Google Sheets
How to Highlight Duplicated Cells in Google Sheets
How to Highlight Duplicated Cells in Google Sheets
How to Color Code in Google Sheets - ModernSchoolBus.com
How to Color Code in Google Sheets - ModernSchoolBus.com
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
📊 Color Coded Dropdowns in Google Sheets
📊 Color Coded Dropdowns in Google Sheets
How to hide cells in Google Sheets
How to hide cells in Google Sheets
How to Make Negative Numbers Red in Google Sheets - ModernSchoolBus.com
How to Make Negative Numbers Red in Google Sheets - ModernSchoolBus.com
How to get the HTML color codes in Google Sheets - Plus every color in the color picker!
How to get the HTML color codes in Google Sheets - Plus every color in the color picker!
Change Cell Colour using Conditional Formatting
Change Cell Colour using Conditional Formatting
Google Keep
Google Keep
How Do You Highlight Cells of the Same Color - Teacher Tech with Alice Keeler
How Do You Highlight Cells of the Same Color - Teacher Tech with Alice Keeler
Create Custom Color Swatches for Google Drive
Create Custom Color Swatches for Google Drive
How to Change Your Font in Google Sheets
How to Change Your Font in Google Sheets
How to Highlight Duplicates in Google Sheets
How to Highlight Duplicates in Google Sheets
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
How to Highlight a Row in Google Sheets Based on a Checkbox
How to Highlight a Row in Google Sheets Based on a Checkbox
How to change the page color or Document Background Color in Google Docs
How to change the page color or Document Background Color in Google Docs
Google Sheets Tips Progress Bar
Google Sheets Tips Progress Bar
Alternating Colors for Rows in Google Sheets
Alternating Colors for Rows in Google Sheets
CHECK the Conditional Formatting - Teacher Tech with Alice Keeler
CHECK the Conditional Formatting - Teacher Tech with Alice Keeler

Using Pre-set Border Colors for Multiple Cells

To use a pre-set border color for multiple cells:

  1. In the 'Borders' palette, choose the border style you want (like 'Thick border').
  2. Click on the colored box next to 'Border color' to choose your color.
  3. All the selected cells' borders will now sport the color you chose.

Creating Custom Border Colors for Multiple Cells

To create a custom border color for multiple cells, follow the same steps as creating a custom border color for a single cell, but after selecting your cells in the 'Borders' palette.

And there you have it! Now you know how to change the border color of cells in Google Sheets, from individual cells to multiple cells at once. Happy formatting!

Related Articles

How To Remove Color In Excel Shortcut How To Color Every Other Row In Excel Online How To Change The Color Of A Table In Google Docs How To Filter By Fill Color In Google Sheets How To Color Code In Excel Based On Drop Down List How To Count Cells By Color In Excel How To Change Color Of Cells In Google Sheets How To Fill Color In Excel Keyboard Shortcut How To Change Cell Color In Google Sheets Based On Checkbox How To Color Every Other Row In Excel Mac