Add/Remove Right Border in Excel

Adding or removing a right border helps highlight or separate specific columns in a worksheet.

How to Add a Right Border

1. Select the cell(s) or range where you want the right border
2. Go to the Home tab → Font group → Borders dropdown
3. Click Right Border to add the border

How to Remove a Right Border

1. Select the cell(s) that have the right border
2. Go to the Borders dropdown
3. Click No Border or toggle the right border off

Keyboard Shortcut

On Windows, you can quickly apply a right border using: Alt + H → B → R

Tips & Best Practices

• Use right borders to mark the end of important data columns
• Combine with left or top borders for a boxed effect
• Be careful not to overuse borders, as too many lines can make the worksheet look cluttered

FAQ

Q: Can I remove a right border without affecting other borders?

Yes, click on the Right Border button again or use No Border to remove it selectively.

Q: Can I apply this to multiple rows at once?

Yes, select multiple rows or columns, and the right border will apply to the entire selection.