Updated: November 21, 2026

If you need to know how to add cell borders in Google Sheets, the fix is built into the toolbar and takes only a few clicks. You can add a border to one cell, a whole table, or just the outside edge of a range, then change the line style or remove it later if the sheet gets crowded. The same tools also handle border edits, so you do not need a separate menu for every small change.

Add borders to cells in Google Sheets

To add borders in Google Sheets, select the cells first. Then use the border button in the toolbar to apply a border style to the selected range. This is the fastest way to put border in Google Sheets when you are formatting a table, a schedule, or a list.

  1. Select the cell or range of cells you want to format.
  2. Click the Borders icon in the toolbar.
  3. Choose the border placement you want, such as all borders, outer border, or inner borders.
  4. If needed, choose the line style and border color from the same menu.

Common border choices

If you are asking how do I add borders in Google Sheets for a simple table, use All borders. If you only want a frame around the outside of a range, use Outer borders. For data grids, Inner borders draws lines between cells without boxing every cell separately.

Change or edit borders in Google Sheets

If you need to edit borders in Google Sheets, select the same cells again and reopen the border menu. You can change the border color, switch from a thin line to a thicker one, or replace a plain line with a dashed style. This is the cleanest way to change borders in Google Sheets without rebuilding the whole layout.

How to edit border style and color

Use the border menu to adjust three parts of the border: where it appears, how thick it is, and what color it uses. If your sheet needs a stronger visual break, choose a thicker line. If you want the border to match a theme, pick a color that fits your header row or brand palette.

When you apply border in Google Sheets to a selected range, the new setting replaces the older one on the same cells. That makes it easy to update a table after you change its structure or formatting.

Remove borders from cells

To remove border in Google Sheets, select the cells with the lines you want to clear, then open the border menu and choose the option that removes borders from the selected range. This answers the same task people search for as how to delete border in Google Sheets, how to get rid of border on Google Sheets, and how to clear borders in Google Sheets.

  1. Select the cells, rows, or columns with the border lines.
  2. Click the Borders icon.
  3. Choose the no border option, or the option that clears all visible borders from the selection.

Remove only part of a border

If you want to remove border lines in Google Sheets without erasing every edge, select the range again and choose a specific border placement. For example, if only the outer frame looks cluttered, clear the outer border and leave the inner grid lines in place. If you want to remove border on Google Sheets from one side only, use the border tool to target just that edge.

Use borders for tables, headers, and clean layouts

Borders are most useful when they separate a header row from the rest of the data or make a block of numbers easier to scan. A simple spreadsheet usually needs only one outer border and a bottom border under the header row. For dense data, add cell borders in Google Sheets across the full range so each row and column stays readable.

Good places to use borders

  • Header rows in budgets, lists, and trackers
  • Price tables and inventory sheets
  • Sign-up lists and class rosters
  • Any range you want to print cleanly

If you are building a shared sheet, borders also help other people see where one section ends and another begins. That makes it easier to apply border in Google Sheets consistently across a team file.

Fix border problems in Google Sheets

If your border does not look right, the most common cause is that the wrong range was selected before you clicked the border tool. Another common issue is overlapping formatting, where a later border choice changed only part of the cell edge. Re-select the exact range you want and apply the border again from the toolbar.

When borders seem missing

If you cannot see a border after adding one, check that the line color is not the same as the cell fill or background. Also check whether the border was applied to one side only, while you expected a full box. For merged cells, borders behave around the merged area, not around each original cell inside it.

Frequently Asked Questions

How do you add borders in Google Sheets?

Select the cells, click the Borders icon, and choose the border type you want. Use All borders for a full grid, Outer borders for a frame, or Inner borders for lines between cells.

How do I remove borders in Google Sheets?

Select the cells with borders, open the Borders menu, and choose the no border option to remove them. This clears the visible lines from the selected range.

How do I turn off borders in Google Sheets?

Turning off borders means removing them from the cells. Select the range, open the border tool, and choose the option that clears borders from that selection.

How do I edit borders in Google Sheets?

Select the cells again, then reopen the border menu to change line style, thickness, color, or placement. The new choice replaces the current border formatting on the selected cells.

How do I get rid of a border in Google Sheets?

Select the cells or range, then use the border tool to remove the specific border or clear all borders from that selection. If only one side is causing trouble, choose the edge you want to remove instead of clearing the whole range.