How to Add Borders in Google Sheets: A Step-by-Step Guide


Michael Collins

Adding borders in Google Sheets can help organize your data and make your spreadsheet look more professional. It’s a simple process that involves selecting the cells you want to apply borders to, choosing the border style, and customizing the color and thickness if desired. After reading this overview, you’ll have a basic understanding of how to add borders to your Google Sheets.

Step by Step Tutorial: How to Add Borders in Google Sheets

Before we dive into the steps, let’s understand what we’re aiming for. Adding borders can help differentiate between different sections of your data, highlight important information, or simply make your spreadsheet more visually appealing. Let’s get started:

Step 1: Select the Cells

Click and drag to select the cells to which you want to add borders.

Selecting the cells is the first step in adding borders. You can select a single cell, a range of cells, or even entire rows or columns depending on your needs.

Step 2: Open the Borders Menu

Click on the "Borders" icon in the toolbar.

The borders icon looks like a grid and is usually located in the toolbar at the top of your screen. Clicking on it will open a dropdown menu with border options.

Step 3: Choose the Border Style

Select the border style you want to apply to the selected cells.

The border menu offers various options, including outer borders, inner borders, and individual border sides. You can also choose to clear any existing borders.

Step 4: Customize the Border (Optional)

Customize the border color and thickness if desired.

If the default black, one-pixel border doesn’t suit your needs, you can change the color and thickness. This is an optional step but can be useful for matching your company’s branding or simply adding a personal touch.

After completing these steps, your selected cells will now have the borders you applied. The changes will be visible immediately, and you can adjust or remove the borders at any time by revisiting the borders menu.

Tips for Adding Borders in Google Sheets

  • Use different border styles for different sections of your data to create a clear distinction.
  • Consistency is key, so try to use the same border style for similar types of data.
  • Use thicker borders for the outer edges of your data range to create a solid frame.
  • For a cleaner look, avoid using too many different colors or styles within the same sheet.
  • Remember that borders are not just for looks; they can also help readers understand the structure of your data.

Frequently Asked Questions

How do I apply borders to an entire row or column?

To apply borders to an entire row or column, click on the row or column header to select it, then follow the same steps to apply the borders.

Can I apply diagonal borders in a cell?

No, currently Google Sheets does not support diagonal borders within a cell.

What should I do if the borders icon is not visible?

If the borders icon is not visible, you may need to customize your toolbar by adding the icon or accessing the borders menu through the "Format" dropdown in the menu bar.

Can I save my custom border style to use again later?

Google Sheets does not have a feature to save custom border styles, but you can easily replicate the style by noting down the color code and thickness you used.

Will adding borders affect how my data is printed?

Borders will be visible when you print your spreadsheet, so they can be useful for creating print-ready documents.


  1. Select the cells you want to apply borders to.
  2. Open the borders menu by clicking on the borders icon in the toolbar.
  3. Choose your desired border style.
  4. (Optional) Customize the border color and thickness.


Adding borders in Google Sheets is a breeze once you know the ropes. Not only do they enhance the visual appeal of your data, but borders also play a crucial role in the readability and organization of your spreadsheets. Whether you’re prepping data for a big presentation, organizing your monthly expenses, or just trying to make sense of a jumble of numbers, borders can be your best friend.

Remember, the key to professional-looking sheets is consistency and simplicity. Stick to a color scheme, don’t go overboard with different styles, and use borders thoughtfully to guide your reader’s eye. With the tips and steps outlined above, you’re well on your way to becoming a Google Sheets border wizard.

Now, don’t just stop at borders—Google Sheets has a plethora of features waiting to be explored. Play around with cell colors, text formatting, and even conditional formatting to make your data not just readable, but enjoyable to look at. And if you ever get stuck or want to learn more, there’s a whole community of spreadsheet enthusiasts out there ready to share their knowledge. So go ahead, add those borders, and take your Google Sheets game to the next level!