Add/Remove Vertical Interior Borders in Excel

Vertical interior borders divide the columns within a selected range, improving table readability and organization.

How to Add Vertical Interior Borders

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

How to Remove Vertical Interior Borders

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

Tips & Best Practices

• Use vertical interior borders to visually separate columns in large tables
• Combine with horizontal interior borders to create a clean grid layout
• Keep formatting consistent for clarity in reports and dashboards

FAQ

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

Yes, select multiple ranges by holding Ctrl and apply the borders to all at once.

Q: Will adding vertical interior borders affect existing borders?

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