You need to add borders to cells in Excel to make your data tables easier to read and print. Borders create visual separation between rows and columns, turning a wall of numbers into a clean, organized grid. This article explains the different border tools and provides step-by-step instructions for applying them effectively.
Key Takeaways: Adding Borders in Excel
- Home > Font > Borders: The main ribbon button provides quick access to common border styles like outside and inside borders.
- Format Cells > Border dialog: Offers complete control over line style, color, and placement for each side of a cell.
- Draw Border tool: Lets you manually draw borders around cells or create a custom grid by clicking and dragging.
Understanding Excel’s Border Tools
Excel provides several methods for adding borders, each suited for different tasks. The simplest is the Borders button on the Home tab, which applies preset combinations like a full outside border or gridlines inside a selection. For more detailed formatting, the Format Cells dialog gives you control over every individual line. You can also use the Draw Border tool for a freehand approach, which is useful for quickly outlining irregular cell ranges. Before you start, select the cells you want to format. Borders are a cell formatting property, so they move and copy with the cell contents.
Steps to Apply Borders to Your Table
Follow these steps to add professional-looking borders to your data tables.
- Select your cell range
Click and drag to highlight all the cells in your table that need borders. - Open the main Borders menu
Go to the Home tab on the ribbon. In the Font group, click the small arrow next to the Borders button, which looks like a square divided into four. - Choose a preset border style
From the dropdown menu, select a style like “All Borders” to apply a thin grid to every cell in your selection. Choose “Outside Borders” to put a box only around the outer edge of the selected range. - Open the detailed Border dialog for more control
From the same Borders dropdown menu, click “More Borders” at the bottom. This opens the Format Cells dialog with the Border tab selected. - Set line style and color
In the dialog, first choose a line Style, such as a thick solid line or a dashed line. Then, click the Color dropdown to select a color other than black. - Apply borders to specific sides
Click the preset buttons like “Outline” or “Inside,” or click directly on the diagram in the Border section to add lines to the top, bottom, left, or right of the cells. Click OK to apply.
Using the Draw Border Tool
For a more manual method, use the Draw Border tool.
- Access the drawing tools
On the Home tab, click the Borders dropdown arrow and hover over “Draw Border.” A flyout menu will appear. - Select a drawing mode
Choose “Draw Border” to draw a single border line around a block of cells. Choose “Draw Border Grid” to automatically create a full grid as you drag. - Draw your borders
Your cursor will change to a pencil. Click and drag across the cells where you want borders to appear. Release the mouse to apply them. - Change line color or erase
From the same “Draw Border” flyout, select “Line Color” to pick a new color, or “Line Style” for a different dash pattern. Select “Erase Border” and drag over borders to remove them.
Common Mistakes and Limitations
Avoid these issues to ensure your borders work as expected.
Borders Print as Faint or Missing
If borders look correct on screen but print poorly, check your printer settings and Excel’s page setup. Go to Page Layout > Page Setup > Sheet. Ensure the “Black and white” option is not checked, as this can cause colored borders to print as gray. Also, in File > Print > Page Setup, check the print quality setting.
Borders Disappear When Sorting or Filtering
Borders are tied to individual cells. If you sort a column, the bordered cells move to their new sorted position. This is normal behavior. To keep a header row bordered at the top, convert your range to a formal Table using Ctrl+T. The table will maintain its header formatting during sorts and filters.
Cannot Apply Diagonal Borders
Diagonal borders are only available through the Format Cells > Border dialog. In the Border tab, click the two diagonal line buttons in the lower corner of the preview diagram. These are often used to indicate a cell is not in use.
Border Tool Comparison
| Item | Ribbon Borders Button | Format Cells Dialog | Draw Border Tool |
|---|---|---|---|
| Best For | Quick, common border styles | Precise, custom border design | Manual, freeform border drawing |
| Line Color Control | No | Yes | Yes, via separate menu |
| Individual Side Control | Limited presets | Full control per side | Depends on drawing action |
| Speed | Fastest | Slower, detailed | Medium, interactive |
You can now add clean grid lines to any Excel table using borders. Use the ribbon for speed and the Format Cells dialog for detailed control. Try using a subtle gray line color for inside borders and a solid black line for the outside border to make your tables stand out. For advanced formatting, use the Format Painter to copy border styles from one cell range to another quickly.