The simplest way to add a border

Open your spreadsheet in Excel and click on the cell or group of cells where you want a border. If you want to select multiple cells at once, click the first cell, hold Shift, and click the last cell in the range you want. You can also click and drag across cells to select them.

Once your cells are selected, look at the top menu and find the Home tab. In the toolbar, you'll see a small downward arrow next to an icon that looks like a grid or box outline — this is the border button. Click that arrow to open the border menu. A dropdown list will appear with border options. Click All Borders to put a border on all four sides of each cell. If you want only an outline around the entire selection, choose Outside Borders instead. Pick whichever matches what you're trying to do, and the border appears when ready.

Key Takeaways

  • Select the cells you want to border by clicking one cell and dragging to another, or by clicking the first cell, holding Shift, and clicking the last cell.
  • The border button is in the Home tab at the top, marked by a small downward arrow next to a grid icon.
  • All Borders puts lines around every cell in your selection, while Outside Borders puts a line only around the outer edge of the entire group.
  • You can remove borders by selecting the cells again and choosing No Border from the same dropdown menu.

Choosing between All Borders and Outside Borders

The difference between these two options matters depending on what your spreadsheet is for. All Borders draws a line between every single cell, which makes it easier to read data when you have many rows and columns. This is useful for tables where you want to see exactly which value belongs in which cell.

Outside Borders draws a line only around the perimeter of your selection, leaving the inside cells without dividing lines. This creates a cleaner look and is often used when you want to highlight a single block of information or a title area without making it look too busy.

Adding borders to just one side of a cell

Sometimes you only need a border on the bottom of a cell, or the right side, or the top. Click on the cells you want to modify, then open the border dropdown menu again. Instead of choosing a preset option, look for More Borders at the bottom of the menu. This opens a dialog box with more control.

In the dialog box, you'll see a preview of your cell in the center. Click directly on the edges of that preview — top, bottom, left, right, or diagonal — to add or remove borders from just those sides. You can also choose the line style and color from the options on the left side of the dialog before you click OK.

Removing borders you no longer want

Select the cells that have borders, open the border dropdown menu, and click No Border. All borders on those cells disappear when ready. If you only want to remove borders from one side, use the More Borders dialog again and click the edges in the preview to toggle them off.

There's no undo penalty for removing borders — you can always add them back the same way if you change your mind. Many people remove borders when they want to clean up a spreadsheet before sharing it, or when they realize a section no longer needs visual separation from the rest of the data.

Changing the line style or color of borders

The default border is a thin black line, but you can change this. Select your cells, open the border dropdown, and click More Borders. On the left side of the dialog, you'll see options for Line Style (solid, dashed, dotted) and Color. Pick the style and color you want, then click on the edges of the preview cell to explore that style to specific sides.

This is useful when you want to emphasize certain rows or columns — for example, using a thicker line or a different color to separate a header row from the data below it. A thicker border around a title section also helps readers understand where one table ends and another begins.

Borders on merged cells

If you've merged cells together (combined two or more cells into one), you can still add borders the same way. Select the merged cell, open the border menu, and choose your option. The border will appear around the outer edge of the merged area.

You can also use More Borders to add lines only to specific sides if you want a partial border on a merged cell. This works the same as with regular cells — click the edges of the preview to choose which sides get a border.

Frequently Asked Questions

Can I copy borders from one cell to another without copying the data?

Yes. Select the cell with the border you want to copy, then click the Format Painter button (it looks like a paintbrush) in the Home tab. Click on the cell where you want that border applied. The border copies over without changing any text or numbers in the destination cell.

Why do my borders look faint or disappear when I print?

Excel borders are thin by default and may not show clearly on a printed page. Open More Borders and choose a thicker line style before printing. You can also adjust print settings by going to File, then Print, and looking for options to print gridlines or borders — the exact wording depends on your Excel version.

What's the difference between borders and gridlines?

Gridlines are the faint gray lines you see on every cell by default in Excel — they help you see where cells are but don't print. Borders are actual lines you add that do print. You can turn gridlines on or off in the View tab without affecting any borders you've added.

Can I add a border to just the top and bottom of a cell?

Yes. Select the cell, open More Borders, and in the preview area click only the top and bottom edges. Leave the left and right edges unclicked. This creates a border only where you want it.