Dotted Line in Excel and Word: How to Add One

To add a dotted line at the bottom of a cell or selected range in Excel, select it, open Home > Borders > More Borders, choose a dotted line style, and click the bottom edge in the preview. In Word, put the cursor in the paragraph and use Home > Paragraph > Borders > Borders and Shading to choose a dotted bottom border. The right method depends on whether you mean the bottom of text, a cell, or a printed page.

First decide what bottom means

A dotted line can be a border attached to text or cells, a movable line shape, or a page-break indicator on screen. These look similar but behave differently. A border follows the paragraph or cell when content moves; a shape can be positioned independently; a page-break indicator shows where printing will split a sheet and is not a printed line.

For a rule immediately beneath a heading, label, or paragraph, use a Word paragraph border. For the bottom edge of a table cell or a worksheet range, use a cell border. For a decorative divider you may want to drag into place, insert a line shape. If you mean the physical bottom margin of a printed page, use a footer or carefully positioned shape rather than a border on the last visible line of text.

Under a paragraph: Word bottom paragraph border.
Under worksheet data: Excel bottom cell or range border.
At a chosen position on a page: a line shape, or a footer in Word.
Dashed mark visible in Excel: possibly a page-break guide, not a dotted border.

Add a dotted bottom border in Excel

In Excel for Microsoft 365 on Windows, select the cell or range that needs the line. On the Home tab, open the arrow beside the Borders button in the Font group and choose More Borders. This opens the Format Cells dialog on its Border tab. Under Style, choose the dotted sample you want. If several dotted or dashed samples are shown, pick the one that best matches the document. You can also set a border color before applying it.

Select the cells whose bottom edge should be marked.
Choose Home > Borders arrow > More Borders.
Pick a dotted style under Style, and optionally choose a color.
In the preview diagram, click the bottom edge, then select OK.

The preview matters: choosing a style does not apply it until you click the relevant edge in the diagram. If the range already has borders, inspect the preview so you do not replace or add unwanted sides. For a single line below a table, select the final row or the exact cells along the intended edge, rather than applying an all-borders setting to the entire table.

For a quick solid bottom border, the Borders menu offers a direct command, but a dotted style is easiest to control through More Borders. To revise it later, select the same cells and return to the Border tab. The dotted line is cell formatting, so it moves with the cells and normally prints as part of the worksheet.

Put a dotted line under a paragraph in Word

In Word for Microsoft 365 on Windows, click in the paragraph that should have the line below it. You do not need to select the paragraph text. Go to Home, find the Paragraph group, open the Borders menu, and choose Borders and Shading. In the dialog’s Borders tab, choose a dotted line under Style. Set Apply to to Paragraph, then use the preview to turn on only the bottom border. Click OK.

A paragraph border spans the paragraph’s text area, usually between the document’s left and right margins. It is often more reliable than typing a row of dots: the border remains a single formatting element even if you edit the text, change the font, or reflow the paragraph. To create a line beneath a heading, apply the border to the heading paragraph. To create one beneath a blank line, click in that blank paragraph and apply it there.

Word’s Borders menu may also show a Bottom Border command. That command quickly adds the currently configured bottom border, but it may use a solid style. Use Borders and Shading when you need to select the dotted pattern, color, width, or whether the border applies to a paragraph or a selected group of paragraphs. On Mac, the same controls are available from the Home tab’s Paragraph border controls, though the menu arrangement can differ slightly by Word version.

When the line must sit at the page bottom

A paragraph border sits beneath a paragraph; it does not automatically stay at the bottom of the sheet of paper. If you want a recurring rule near the bottom of every Word page, edit the footer: double-click the footer area, insert or select a paragraph there, and apply a bottom or top paragraph border as appropriate. A line above footer text is commonly made with a top border on the footer paragraph. Footer content is designed to repeat across pages, subject to the document’s section and first-page settings.

For a line at one particular location on a page, use Insert > Shapes > Line, then draw it where needed. Select the line and use the Shape Format controls to set its outline color, weight, and dash style. Shapes offer more placement freedom, but can shift when text changes or when page layout changes. If precise alignment is important, use the layout and positioning options for the shape and check the page in Print Preview.

Excel has no paragraph footer border equivalent for arbitrary worksheet content. For a line that should appear on a printed page, insert a line shape and check its position in Page Layout view or Print Preview. Page scaling, print area, margins, and repeated print titles can affect what appears on each printed page. A border on the worksheet’s last data row is simpler when the line should follow the data rather than stay at the paper’s bottom edge.

Use a line shape for a movable divider

In either application, a shape is useful when a line needs to cross only part of the text area, sit between objects, or be positioned independently of a paragraph or cell. Choose Insert > Shapes and select the straight line, then drag to draw it. Hold Shift while dragging if you need to constrain the line to a horizontal or vertical direction. Use the format controls for the selected shape to choose a dashed or dotted outline.

Shapes are less convenient than borders for forms and tables. They may overlap text, move when nearby content changes, or be excluded if they are outside the print area in Excel. In Word, text wrapping and anchoring influence how a shape behaves. Use a border for a line that should follow a particular paragraph, row, or cell; use a shape when visual placement is the main requirement.

Check the line in print and avoid look-alikes

Excel’s dashed page-break marks are a frequent source of confusion. They indicate where printed pages divide, often after Print Preview or a change to page setup. They are not cell borders and do not print as dotted rules. To examine page divisions, use View > Page Break Preview; to return to a normal worksheet view, choose View > Normal. A genuine dotted cell border is set through the Borders controls and is included in printing unless the relevant cells or sheet are excluded.

For both programs, inspect the result at the size it will be used. Fine dotted patterns may look faint on screen or on a low-resolution printout. A darker color or slightly heavier line can improve legibility, but check that it does not compete with nearby text. In Excel, use File > Print to preview page breaks, margins, and scaling. In Word, use Print Layout and File > Print to review the page and footer placement.

If the line seems missing, check that the intended edge was selected in the border preview, that the correct cells or paragraph are active, and that the line color contrasts with the background. In Word, a paragraph border may span the paragraph width rather than the selected words; that is expected. If a shape disappears in print, check its position relative to the page or Excel print area, and confirm that it is not behind another object.

Excel borders, Word borders, and shapes compared

Excel applies borders to cells, while Word applies paragraph or table-cell borders. A border is best when the line has a structural relationship to the content: for example, the bottom of a price row in Excel or the underside of a section heading in Word. It participates in the document’s normal layout and is easier to maintain than an independently placed graphic.

A shape is better for a decorative or deliberately offset line. It allows you to choose endpoints and position, but may require adjustment after edits. Neither an Excel page-break guide nor a line made from repeated typed periods is a substitute for a proper border. Repeated periods change spacing with font and text edits, while page-break guides are only visual layout indicators.

On Windows, Ctrl+1 opens Format Cells in Excel, where you can work with the Border tab after selecting cells. On Mac, Command+1 opens Format Cells. These shortcuts open the formatting dialog; you still need to choose the dotted style and bottom edge. Word’s border controls are accessed through the ribbon rather than the Excel Format Cells dialog.

Frequently Asked Questions

How do I make a dotted line under text in Word?
Click in the paragraph, choose Home > Paragraph > Borders > Borders and Shading, select a dotted style, set Apply to Paragraph, and turn on the bottom edge in the preview.

How do I add a dotted line to the bottom of an Excel cell?
Select the cell, open Home > Borders > More Borders, choose a dotted style, click the bottom edge in the preview, and select OK.

Why does Excel show a dotted line across my worksheet?
It may be a page-break indicator showing where printing will split the sheet. It is not a printable cell border. Check View > Page Break Preview or return to View > Normal to identify the view.

Will a dotted border print?
Cell and paragraph borders normally print. Confirm in Print Preview, because print area, page layout, scaling, color, and printer resolution can affect whether a fine dotted line is visible.

How do I put a dotted line at the bottom of every Word page?
Place the line in the footer and apply a paragraph border there, or insert a line shape in the footer. Check section settings if the footer differs between pages or the first page.

Can I make the line only as wide as a few words?
A paragraph border generally spans the paragraph area, not just the selected words. Use a line shape for freely chosen endpoints, or place the text in a table cell and format that cell’s border.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.