Add/Remove Bottom Border in Excel
Adding or removing a bottom border helps separate rows or highlight the end of important sections in your worksheet.
How to Add a Bottom Border
- Select the cell(s) or range where you want the bottom border
- Go to the Home tab → Font group → Borders dropdown
- Click Bottom Border to add the border
How to Remove a Bottom Border
- Select the cell(s) that have the bottom border
- Go to the Borders dropdown
- Click No Border or toggle the bottom border off
Keyboard Shortcut
On Windows, you can quickly apply a bottom border using: Alt + H → B → O
Tips & Best Practices
- Use bottom borders to highlight totals or summary rows
- Combine with top borders for boxed rows or sections
- Keep borders minimal to maintain a clean worksheet
FAQ
- Q: Can I remove a bottom border without affecting other borders?
- Yes, toggle the bottom border button or choose No Border to remove it selectively.
- Q: Can I apply this to multiple rows at once?
- Yes, select multiple rows or columns, and the bottom border will apply to the entire selection.