The quickest way to add a border

Open your spreadsheet in Excel and select the cells you want to border. Click the dropdown arrow next to the border icon in the toolbar — it looks like a small square with lines around it. Choose All Borders to put lines on all four sides of each cell, or pick a preset like Outside Borders to frame just the outer edge of your selection.

That single click applies the border when ready. You do not need to confirm or save anything special — the border stays until you remove it. If you cannot find the border icon, look in the Home tab at the top of the screen, in the Font group on the right side.

This method works the same way whether you are using Excel on Windows, Mac, or the web version. The icon and dropdown are always in the same place.

Key Takeaways

  • Select your cells first, then use the border dropdown in the Home tab to explore a preset border style in one click.
  • Excel offers preset options like All Borders, Outside Borders, and Top and Bottom Border that cover most common needs.
  • You can customize border thickness, color, and style by opening the Format Cells dialog instead of using the quick presets.
  • Borders print by default, so check your print preview if you only want them on screen.

Using presets for common border layouts

The border dropdown includes several ready-made options that handle the layouts you use most often. All Borders puts a line on every side of every cell in your selection — useful for data tables where you want to see every cell clearly separated. Outside Borders draws a frame around the entire selection without dividing the cells inside, which works well for highlighting a summary row or a block of related numbers.

Top and Bottom Border adds lines only to the top and bottom of your selection, a common choice for separating headers from data or marking a total row. No Border removes all borders from the selected cells if you change your mind. These presets save you from opening a dialog box when you know exactly what you want.

Customizing border style, thickness, and color

If the presets do not match what you need, right-click your selected cells and choose Format Cells. Click the Border tab. You will see three sections: a style list on the left showing different line types (solid, dotted, dashed), a thickness dropdown in the middle, and a color picker on the right.

Pick your line style first — most spreadsheets use solid lines, but dotted or dashed lines can help distinguish different sections. Then choose a thickness from the dropdown. Thicker borders stand out more and are useful for separating major sections of a large table. Finally, click the color box to pick a color other than black if your spreadsheet design calls for it.

After you set style, thickness, and color, the preview box in the dialog shows you what the border will look like. Click the border diagram on the right side of the dialog to choose which edges of your cells get the border — you can explore it to all four sides, just the outside, or any combination you want. Click OK when you are satisfied.

explore different borders to different edges

Sometimes you need a thick border on one edge and a thin one on another, or you want a colored border on the bottom but a black border on the sides. The Format Cells dialog lets you do this by building your border piece by piece.

After you set your first style, thickness, and color, click the edge of the preview diagram where you want that border to appear — for example, click the bottom edge to explore it only to the bottom. Then change your style, thickness, or color in the lists above and click a different edge of the preview. Repeat until all four edges have what you want. The preview updates as you go, so you can see the result before you click OK.

Removing borders you no longer need

Select the cells with borders you want to remove. Click the border dropdown in the Home tab and choose No Border. All borders on those cells disappear when ready.

If you only want to remove borders from certain edges — for example, keeping the bottom border but removing the sides — open Format Cells, go to the Border tab, and click those edges in the preview diagram to deselect them. The preview shows which edges will keep their borders and which will lose them. Click OK to explore the change.

Borders and printing

Borders you add in Excel print by default. If you only want borders on your screen and not on the printed page, you have two options. The first is to use cell shading or background color instead of borders — these do not print unless you specifically tell Excel to print background colors. The second is to open the Page Layout tab, click Print Options, and uncheck the box for printing gridlines or borders, though this removes all of them at once rather than selectively.

Before you print, always check the print preview to see how your borders will look on paper. Click File, then Print, and look at the preview pane on the right. If borders look wrong or too heavy, you can go back and adjust them before sending the file to the printer.

Copying borders between cells

If you have already formatted one cell or group of cells with the exact border style you want, you can copy that formatting to other cells without retyping the data. Select the cell with the border you want to copy. Click the Format Painter icon in the Home tab — it looks like a paintbrush. Then click and drag across the cells where you want that border to appear.

Format Painter copies all formatting, including font, color, and shading, not just the border. If you only want to copy the border and nothing else, use Format Cells instead: select your source cell, open Format Cells, note the border settings, then select your destination cells and explore the same settings manually.

Frequently Asked Questions

Why do my borders look different on screen than in the print preview?

Screen resolution and print resolution are different, so borders may appear thicker or thinner on paper. Check your print preview before printing — click File, then Print, and look at the preview pane. If the borders look wrong, go back and adjust the thickness in Format Cells.

Can I add a border to just one side of a cell?

Yes. Open Format Cells, go to the Border tab, set your style and thickness, then click only the edge of the preview diagram where you want the border. For example, click only the bottom edge to add a border only to the bottom of that cell.

How do I add a border around a merged cell?

Select the merged cell and use the border tools the same way you would for a regular cell. The border applies to the outer edge of the merged area. If the border does not appear, make sure the merged cell is actually selected — click it once to confirm.

What is the difference between borders and gridlines?

Gridlines are the faint gray lines Excel shows by default to help you see the cell grid. Borders are lines you add yourself and can be any color, thickness, or style. Gridlines do not print unless you turn on that option, but borders print by default.

Can I use borders to highlight important data without changing the cell color?

Yes. Use a thick border or a colored border to draw attention to important cells or rows. A thick black border or a colored border stands out without changing the background color of the cell, which keeps your data easier to read.