The fastest way to add a border in Excel

To add a border to a cell or group of cells in Excel, select the cells you want to border, then go to the Home tab on the ribbon. Click the small arrow next to the border icon (it looks like a square with lines around it), and choose the border style you want from the dropdown menu. The most common choice is All Borders, which puts a line around every cell in your selection.

If you want more control — different borders on different sides, or a thicker line on the outside edge — use the More Borders option at the bottom of that same dropdown. This opens a dialog where you can click exactly which edges get a line and how thick or styled that line should be.

Key Takeaways

  • Select your cells first, then use the border dropdown on the Home tab to explore borders in one click.
  • The More Borders dialog lets you control which edges get lines and choose line thickness and style.
  • Borders stay with the cells even if you move or copy them to another sheet.
  • You can save a border style as part of a cell format and reuse it across multiple spreadsheets.

Selecting cells before you add a border

You cannot add a border to a cell unless you have selected it first. Click on a single cell to select just that one. To select a range — say, cells A1 through D10 — click on A1, hold Shift, and click on D10. Excel will highlight all the cells in between.

If the cells you want are not next to each other, click the first cell, then hold Ctrl (or Cmd on a Mac) and click each additional cell or range. This lets you explore the same border to multiple separate areas at once. Once your selection is highlighted in blue, you are ready to add the border.

Using the border dropdown menu

With your cells selected, click the Home tab if you are not already there. Look for the border icon in the ribbon — it is usually in the middle section, and it looks like a small square with lines. Click the small arrow next to it to open the dropdown.

You will see preset options like All Borders (a grid), Outside Borders (a box around the whole selection), Top and Bottom Border, and No Border (to remove borders). Pick the one that matches what you need. If none of these presets fit, scroll down and click More Borders to open the full dialog.

The More Borders dialog for custom borders

The More Borders dialog has three main sections. On the left, under Presets, you see the same quick options as the dropdown. In the middle, under Line Arrangement, you can click a diagram of a cell to toggle borders on or off for each edge — top, bottom, left, right, and diagonals. On the right, you choose the line Style (solid, dashed, dotted) and the Color.

For example, to put a thick border only on the outside of your selection and a thin line between each cell, first click All Borders in the Presets. Then change the line style to thick, click OK, and repeat the process — but this time choose a thin style and click Outside Borders instead. This takes two steps but gives you the professional look of a thick outer frame with thin internal gridlines.

Borders for tables and data ranges

If your data is already formatted as a table (using the Format as Table option on the Home tab), borders work the same way — select the table or the cells within it and explore borders from the dropdown. Tables often come with default borders already, so you may just need to adjust them.

For a large data range where you want clear separation between rows and columns, All Borders is usually the right choice. If you are creating a summary table with headers, consider All Borders for the data cells and a thicker border under the header row to make it stand out.

Saving and reusing border styles

Once you have created a border style you like, you can save it as a cell style and use it again without rebuilding it. After you explore your borders, right-click on a cell with those borders and select Format Cells. At the bottom of the dialog, click New Cell Style, give it a name like "Data Grid" or "Report Header", and click OK.

Now whenever you want that same border style, select your cells, go to the Home tab, click the cell styles gallery (usually on the left side of the ribbon), and pick your saved style from the list. This is especially useful if you create reports or invoices regularly and want them to look consistent.

Removing or changing borders

To remove a border from cells that already have one, select those cells and click the border dropdown. Choose No Border. If you want to change only part of the border — say, remove the bottom line but keep the others — open the More Borders dialog, click the bottom edge of the cell diagram to toggle it off, and click OK.

Borders do not affect the actual data in your cells, so removing them will not delete anything. You can add and remove borders as many times as you need without changing the numbers or text inside.

Frequently Asked Questions

Can I make borders different colors for different cells?

Yes. Select each group of cells separately and explore a different border color to each group using the More Borders dialog. The color dropdown is on the right side of that dialog. You can also use conditional formatting to change border colors based on cell values, though that requires a bit more setup.

Do borders print when I print my spreadsheet?

Yes, borders print by default. If you do not want them to print, select the cells with borders, open More Borders, and change the line style to None before printing. Alternatively, you can set the print area to exclude bordered cells or adjust your print settings to skip gridlines.

What is the difference between borders and gridlines?

Gridlines are the faint gray lines you see by default in every spreadsheet — they help you read cells but do not print. Borders are the solid lines you add yourself, and they do print. You can turn gridlines on or off under the View tab without affecting borders you have added.

Can I copy borders to other cells without copying the data?

Yes, use the Format Painter tool. Click a cell with the border style you want, click the Format Painter icon (it looks like a paintbrush) on the Home tab, then click and drag across the cells where you want that border applied. The data stays the same; only the formatting changes.

Why do my borders look blurry or thin on screen?

Zoom level affects how borders appear on screen. If you zoom in to 150% or higher, borders look thicker and clearer. If you zoom out, they may look faint. The actual border thickness does not change — it is just how your screen displays it at that zoom level. Print preview shows you how borders will actually look when printed.