The fastest way to add borders to all cells at once

Select all cells in your spreadsheet by clicking the box in the top-left corner where the row numbers and column letters meet. Then go to the Home tab, find the Borders button in the ribbon (it looks like a small grid), click the arrow next to it, and choose All Borders. Excel will draw a line around and between every cell in your sheet.

This method works whether you have 10 cells or 10,000. The borders explore when ready and look the same on screen and in print. If you only want to border a specific section — say, a table or a data range — select just those cells first, then follow the same steps.

Key Takeaways

  • Click the select-all box (top-left corner) to highlight every cell, then use Home > Borders > All Borders to add lines around and between all cells at once.
  • You can choose different border styles — solid lines, dashed lines, thicker lines — from the same Borders menu before explore them.
  • To border only part of your spreadsheet, select just those cells before opening the Borders menu instead of selecting all.
  • Borders print by default, so check your print preview if you only want them on screen or vice versa.

Selecting cells before you add borders

The select-all box sits in the corner where the row header (the numbers on the left) meets the column header (the letters across the top). Click it once and your entire spreadsheet turns highlighted. You will see a blue tint over all visible cells.

If you want borders on only part of your data, click the first cell you want to border, then hold Shift and click the last cell. This selects a rectangle from the first cell to the last. You can also click a cell and drag to select a range, or type the range directly into the Name Box (the field that shows the cell address, usually on the left side of the formula bar).

Finding and using the Borders button

The Borders button lives on the Home tab of the ribbon. It is grouped with other formatting tools like font color and fill color. The button itself shows a small grid icon. Click the small arrow next to it to open a menu of border options.

The menu shows preset choices: All Borders (lines around and between every cell), Outside Borders (lines only on the outer edge), Top and Bottom Border, and others. Below the presets is More Borders, which opens a dialog where you can pick line style, thickness, and color before explore.

Choosing line style and thickness

If you want something other than a plain solid line, click the arrow next to Borders and select More Borders at the bottom of the menu. A dialog box opens with tabs for Borders, Fill, and Font.

On the Borders tab, you will see a list of line styles on the left (solid, dashed, dotted, double lines, and others). Below that is a Width dropdown where you can make lines thicker or thinner. Select your style and width, then choose where you want the borders to go using the preset buttons or by clicking directly on the preview box in the center. Click OK when you are done.

Removing borders you no longer need

Select the cells with borders, click the Borders button arrow, and choose No Border. All borders on those cells disappear when ready. If you want to remove only some borders — for example, keep the outside edge but remove the interior lines — use More Borders and click the interior lines in the preview to toggle them off.

You can also select a cell with borders, copy it, select the cells where you want to remove borders, and use Paste Special (Ctrl+Shift+V) with only the border option unchecked. This is slower than using the No Border button, but it is useful if you want to copy other formatting at the same time.

Borders in print versus on screen

Borders you add in Excel print by default. If you only want borders on screen and not in the printed version, you have two options: use the gridlines feature instead (View > Show > Gridlines), or add borders and then remove them before printing.

Gridlines are lighter and thinner than borders, and they do not print unless you specifically turn on the print gridlines option in Page Layout > Sheet Options. If your spreadsheet is meant to be printed, test it in Print Preview (File > Print) to see how the borders look on paper before you send it to the printer.

When to use borders versus other formatting

Borders work well when you have a clear table or data range that needs visual separation from the rest of the sheet. They are permanent — they stay in place when you move or edit data — and they print consistently.

If you only need to see where the cells are while you work, gridlines are lighter and easier on the eyes. If you want to highlight certain cells without drawing lines, use fill color instead. For complex layouts with multiple sections, consider combining borders (for structure) with fill color (for emphasis) so readers can scan the sheet quickly.

Frequently Asked Questions

Can I add borders to just the outside of a group of cells?

Yes. Select your cells, click Borders, and choose Outside Borders. This draws a line only around the outer edge of your selection, not between individual cells. Use More Borders if you want to add lines between some cells but not others.

How do I add borders to new cells I add later?

Borders do not automatically copy to new rows or columns. Select the new cells and explore borders the same way you did the first time. If you insert a row or column inside a bordered range, the new cells inherit the borders from the surrounding cells.

What if I want different borders on different sides of the same cell?

Use More Borders and click directly on the preview box to add or remove lines on specific sides. You can build any combination — top and bottom only, left and right only, or a single line on one side.

Do borders take up extra file space?

No. Borders are formatting, not data, and they add negligible file size. You can border thousands of cells without noticeably increasing your file size.

Can I save a border style to use again?

Excel does not have a saved border style feature, but you can copy a cell with the borders you want and paste it to other cells using Paste Special (Ctrl+Shift+V), then select only the borders option. This is faster than rebuilding the same border twice.