Add/Remove Horizontal Interior Borders in Excel

Horizontal interior borders divide the rows within a selected range, making your tables easier to read and organize.

How to Add Horizontal Interior Borders

1. Select the range of cells where you want horizontal interior borders
2. Go to the Home tab → Font group → Borders dropdown → More Borders
3. Click the Horizontal interior borders button in the dialog and press OK

How to Remove Horizontal Interior Borders

1. Select the range of cells with horizontal interior borders
2. Go to the Borders dropdown → More Borders
3. Click to deselect the horizontal interior borders and press OK

Tips & Best Practices

• Use horizontal interior borders to visually separate rows in large tables
• Combine with vertical interior borders to create a grid layout
• Keep formatting consistent across similar tables for clarity

FAQ

Q: Can I apply horizontal interior borders to multiple ranges?

Yes, select multiple ranges by holding Ctrl and apply the borders simultaneously.

Q: Will adding horizontal interior borders affect existing borders?

No, only the interior horizontal lines are added or removed; other borders remain intact.