How to create dotted line in Excel
To create a dotted line in Excel is very simple, not as complicated as when you create a dotted line in Word . We can create a dotted line in Excel to fill in information, or you can also create a horizontal line in Excel, depending on your needs and the purpose of creating data. The following article will guide you to create a dotted line in Excel, with all versions of Excel.
Instructions for creating dotted lines in Excel
Step 1:
First you also create content in Excel as usual.

Next, we need to merge multiple cells into one in Excel by clicking on the Merge & Center feature. Note, you want to create a dotted line, then merge the line to that point.

Step 2:
Next, we highlight the entire data area to the position where you want to create a dotted line in Excel. Then right-click and select Format Cells… in the displayed list.
Step 3:
To display the new interface, click on the Number tab , then look down and click on the Custom category .
Now look to the side in the Type box, we will enter the character @*. then click OK below to save.
Step 4:
As a result you will see the dotted line below, with the length we have chosen.
Now we just need to fill in the content in the dotted line as usual.
How to create horizontal lines in Excel
To create horizontal lines in Excel is as simple as creating dotted lines in Excel.
Step 1:
We also select the data area where we want to create horizontal lines and then select Format Cells… Next, in the new interface, you will enter the character @*_ in the Type box and press OK.
Step 2:
The result will show horizontal lines instead of dots in the data area as shown below. Finally, you can write content as usual.
With the operation of creating horizontal lines in Excel or dotted lines, our information survey table or information table will be much more professional.
Video tutorial on creating dotted lines in Excel
You should read it
- 3 ways down the line in Excel, line break, down row in 1 Excel cell
- How to create newlines in Excel
- Line breaks in Excel
- How to Insert a Dotted Line in Word
- How to fix the error is not down the line in Excel
- Create dotted lines (......) in Word
- How to draw a straight line, draw an arrow in Excel
- How to Insert a Dotted Line in Word
- MS Excel - Lesson 4: Working with lines, columns, sheets
- Instructions on how to create diagonal lines in Excel box
- How to Make a Line Graph in Microsoft Excel
- Instructions for adding alternate blank lines on Microsoft Excel
Maybe you are interested
Documenting a Rust project with mdBook Compare 3D Touch and Haptic Touch technology on iPhone Some tips and tricks on using Camera on iPhone (part 1) Did you know the tricks to use 3D Touch on iPhone? Tips for using 3D Touch on iPhone 6S as electronic scales Experience 3D Touch on iPhone 6S applications