Excel cells have no borders by default: the faint lines on a blank worksheet are gridlines, not cell borders. To add actual borders, select the cells and use Home > Font > Borders; to have borders appear in new workbooks, save a formatted workbook as the appropriate Excel template.
What “default border” means in Excel
The phrase can refer to a few different things: the appearance of a blank worksheet, the border Excel applies when you choose a border command, or a border you want Excel to use in future workbooks. These are separate matters. In a standard new workbook, cells have the Normal style, which has no border. Excel does not offer a single global preference that automatically gives every cell in every workbook a border.
When you choose a border preset from the ribbon, Excel applies that border to the selected cells. The result depends on the preset you choose, the current border settings, and the cell selection. You can choose a line style and color in the Format Cells dialog before applying the border. The usual starting color is Automatic, which generally appears black when printed, but it is not the same as a border being present by default.
It also helps to distinguish a border from a cell style. A style can include several formatting attributes, such as number format, font, fill, and border. The built-in Normal style has no border in a standard blank workbook, but a workbook creator can change that style or use a custom template.
Gridlines are not cell borders
The pale lines visible between cells on a worksheet are gridlines. They help you see the cell layout while working, but they are not part of the cell formatting. By default, worksheet gridlines are not printed. A border, by contrast, is an explicit format attached to one or more cell edges. Borders normally print and remain visible when gridlines are hidden.
This difference explains a common surprise: a worksheet may look like it has a complete grid on screen, yet print with no lines between values. If you need lines in a printed report, apply borders to the relevant cells. If you only want to change the on-screen view, use View > Gridlines to show or hide gridlines. To print gridlines instead, go to Page Layout and, under Sheet Options, select Print in the Gridlines section. That print setting does not turn gridlines into cell borders.
For example, a list with values in A1:C10 may show faint gridlines while you edit it. If you apply All Borders to A1:C10, the cell boundaries become actual formatting and can print. Hiding worksheet gridlines will not remove those borders.
How to apply a border to cells
In Excel for Microsoft 365 on Windows, select the cells, then use the Borders menu on the Home tab. The small arrow beside the Borders button opens presets such as Bottom Border, Outside Borders, and All Borders. Choosing a preset applies it immediately. For example, select a table range and choose All Borders to outline every cell, including the internal row and column divisions.
For more control, open the Format Cells dialog with Ctrl+1 on Windows, then choose the Border tab. Select a line style and color, and use the preview or the border buttons to choose which edges to apply. You can set only an outside outline, add internal lines, or apply selected edges such as the bottom border. Choose OK to apply the format.
On a Mac, the Home tab also contains the Borders controls, and Format Cells can be opened with Command+1 in current Excel for Mac. Ribbon layout and keyboard behavior can differ slightly by Excel version and keyboard settings, so use the Format Cells command from the ribbon if that shortcut does not open the dialog.
- Bottom Border: useful for separating a heading or subtotal from the rows below.
- Outside Borders: draws a frame around the selected range without adding lines between every cell.
- All Borders: adds an outline and internal lines to the selected cells.
- No Border: removes borders from the selection; it does not hide worksheet gridlines.
Choosing the right border style
The best choice depends on what the worksheet is for. A border should make relationships easier to read, not compete with the data. A thin bottom border under column headings can create a clean separation without turning every cell into a boxed area. A heavier outside border can emphasize a report section or a small summary table. Double or thick lines are often used sparingly to distinguish totals, but there is no universal accounting rule that Excel enforces.
Consider these practical choices:
- Use a bottom border under headings when the data is a continuous list.
- Use All Borders when readers need to follow individual rows and columns, such as on a form or compact comparison table.
- Use Outside Borders when you want to mark the edge of a block but keep its interior visually open.
- Use a contrasting border color only when it remains easy to see on screen and in print.
Before applying a border, check that you selected the intended range. If a heading spans several columns, for instance, applying All Borders to the entire report may add unnecessary lines through merged or blank areas. You can remove or adjust individual edges later through the Border tab in Format Cells.
Making borders the starting format for a workbook
If you want a particular border arrangement whenever you create a new workbook, use a workbook template. Format a workbook as desired, then save it as an Excel template. In Excel for Windows, use File > Save As, choose Excel Template (*.xltx) as the file type, and save a copy named Book.xltx in Excel’s XLSTART folder. Excel can then use that template when creating new workbooks. The exact XLSTART location can vary by installation; a common Windows location is %appdata%\Microsoft\Excel\XLSTART.
A template is more dependable than changing a border each time, but it affects new workbooks created from that template, not workbooks that already exist. If the template includes borders on the whole worksheet, remember that this can make a large workbook visually busy and may affect printing. Often it is better to format a standard report area or set up a table layout than to add borders to every cell.
Excel also supports a default worksheet template named Sheet.xltx in XLSTART for new worksheets. This is useful when you want new sheets added to workbooks to start with a particular layout. It is distinct from Book.xltx, which is used for new workbooks. On Mac, templates can also be saved and reused, but the startup folder location and the steps for making a template the default can differ; use Excel for Mac’s template and startup-folder guidance rather than copying a Windows path.
Changing the Normal cell style
Another workbook-level option is to modify the Normal cell style. In Windows Excel, open Home > Cell Styles, right-click Normal, choose Modify, then use Format and the Border tab to set the border. This changes the style definition in that workbook. It may be useful if you want a consistent base format across a workbook without separately formatting every cell.
However, changing Normal is not identical to setting a universal Excel preference. The change belongs to that workbook, and cells that already use Normal may also take on the changed formatting. Cells with a different style or explicit formatting may not. Also, cells inserted near existing formatted data can inherit neighboring formatting, so a style change does not guarantee that every newly created cell will behave exactly alike. For predictable new-file behavior, a template is usually easier to manage.
Common border problems and fixes
If borders seem to disappear, first check whether you applied borders or were relying on gridlines. Then select the cells and inspect the Borders menu or Format Cells dialog. A border may be present but hard to see because its color blends into the worksheet, or because only some edges were selected. Print Preview is a useful check before printing, since borders and screen gridlines behave differently on paper.
- Lines appear on screen but not on paper: they may be gridlines. Apply borders, or enable the gridline print option under Page Layout > Sheet Options.
- Only some sides show: select the range again and use Format Cells > Border to inspect the edge selections.
- Old formatting remains after choosing No Border: confirm that the full intended range is selected. Also check whether conditional formatting or a table style is affecting the appearance.
- Copied cells bring unwanted lines: paste values or choose a paste option that does not copy source formatting, rather than using a normal paste.
- Table lines change when the table grows: Excel tables have their own table styles, which can affect the appearance of rows and columns. Review Table Design styles as well as individual cell borders.
Conditional formatting can also change cell appearance when rules are met, and it may include border formatting. If a border changes as values change, inspect Home > Conditional Formatting > Manage Rules. A table style, direct cell formatting, and conditional formatting can overlap, so the visible result may not come from the border preset you last selected.
Frequently Asked Questions
What is the default border in Excel?
There is no border on cells in a standard blank Excel workbook. The faint lines visible by default are worksheet gridlines, which are a viewing aid rather than cell formatting.
How do I make Excel show borders in every new workbook?
Format a workbook with the borders you want and save it as Book.xltx in Excel’s XLSTART folder. Excel can use it as the starting template for new workbooks. Existing files are not changed.
Do Excel gridlines print?
Not by default. To print lines, apply cell borders or select Print under Page Layout > Sheet Options > Gridlines. Applying borders is usually the better choice when you need a deliberate, controlled layout.
How do I remove borders but keep the gridlines?
Select the cells, open Home > Font > Borders, and choose No Border. This removes cell border formatting; it does not turn off worksheet gridlines.
Why do borders appear in one workbook but not another?
Border formatting is stored in the workbook, and different workbooks can use different templates, cell styles, table styles, or conditional-formatting rules. A blank new workbook and a custom-formatted workbook therefore need not look the same.
Can I set a different default border color?
You can choose a border color when formatting cells or modify a workbook’s style or template. Excel does not provide one universal border-color setting that changes every workbook and every cell automatically.
Related
- Customer Data Management Excel Template: Setup Guide
- Creating Shift Schedules in Excel: A Practical Guide
- CSV vs Excel: What’s the Difference?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Hide Commands: Shortcuts for Rows, Columns, and SheetsIn Excel for Microsoft 365 on Windows, select the row or rows and press Ctrl+9 to hide them;…
- Enable Circular References in Excel: Step-by-StepTo enable circular references in Excel for Microsoft 365 on Windows, open the workbook, select File > Options…
- PowerPoint Slideshow Loop: How to Repeat It AutomaticallyTo keep a PowerPoint slideshow looping, open the presentation in the desktop app and choose Slide Show >…
- Excel Import CSV Data: Steps, Settings, and FixesTo import CSV data into Excel for Microsoft 365 on Windows, open a blank workbook, select Data >…
- Track Changes in Word on iPad: A Step-by-Step GuideTo track edits in Word on an iPad, open your document, tap Review, and turn on Track Changes…
- Excel Solver: How to Add Parameters and ConstraintsTo add parameters in Excel Solver, open Data > Solver, choose the objective cell and the changing variable…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.