Add/Remove Top Border in Excel
Adding or removing a top border helps separate rows or highlight the beginning of important sections in your worksheet.
How to Add a Top Border
- Select the cell(s) or range where you want the top border
- Go to the Home tab → Font group → Borders dropdown
- Click Top Border to add the border
How to Remove a Top Border
- Select the cell(s) that have the top border
- Go to the Borders dropdown
- Click No Border or toggle the top border off
Keyboard Shortcut
On Windows, you can quickly apply a top border using: Alt + H → B → T
Tips & Best Practices
- Use top borders to highlight headings or separate sections of data
- Combine with bottom borders for boxed rows
- Use sparingly to keep your worksheet clean and readable
FAQ
- Q: Can I remove a top border without affecting other borders?
- Yes, toggle the top 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 top border will apply to the entire selection.