Insert or remove cell borders on a worksheet

Insert or remove cell borders on a worksheet

You can add a border around cells to distinguish specific values, outline summarized values, or separate data into ranges of cells. To quickly add an outside border, simply select the cells that you want to include and press Ctrl+Shift+7 on your keyboard.

Follow these steps to add borders by selecting different line styles and colors:

  1. Select the cell or range of cells.

  2. On the Home tab, click the arrow next to the Borders icon, and from the dropdown menu, choose the border option that you want to apply.

    Tip: The Borders button shows the most recently used border style. To apply the same style, click the Borders button (not the arrow).

    The Borders option

To remove all borders: Select the cells from which you want to remove borders, and then choose No Border from the menu.

More on borders

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Get support
Contact us
Expand your Office skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×