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.

How to create dotted line in Excel Picture 1

 

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.

How to create dotted line in Excel Picture 2

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.

 

How to create dotted line in Excel Picture 3

Step 3:

To display the new interface, click on the Number tab , then look down and click on the Custom category .

How to create dotted line in Excel Picture 4

 

Now look to the side in the Type box, we will enter the character @*. then click OK below to save.

How to create dotted line in Excel Picture 5

Step 4:

As a result you will see the dotted line below, with the length we have chosen.

How to create dotted line in Excel Picture 6

Now we just need to fill in the content in the dotted line as usual.

How to create dotted line in Excel Picture 7

 

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.

How to create dotted line in Excel Picture 8

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.

How to create dotted line in Excel Picture 9

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

4 ★ | 2 Vote

May be interested

  • MS Excel - Lesson 4: Working with lines, columns, sheetsMS Excel - Lesson 4: Working with lines, columns, sheets
    in addition to the content of tables in excel, operations with lines, columns and sheets in this program are also important. in this article, tipsmake.com will guide you to simple operation to add or remove lines, columns or sheets in excel tables.
  • How to Make a Line Graph in Microsoft ExcelHow to Make a Line Graph in Microsoft Excel
    this wikihow teaches you how to create a line graph from microsoft excel data. you can do this on both windows and mac versions of excel. open microsoft excel. double-click the excel program icon, which resembles a white 'x' on a green...
  • Instructions on how to create diagonal lines in Excel boxInstructions on how to create diagonal lines in Excel box
    manipulating 1 cell into 2 diagonal triangles with a line on excel is a very basic operation and is often performed during the process of creating tables on excel.
  • How to Create a Multi-Line Chart in ExcelHow to Create a Multi-Line Chart in Excel
    drawing a multi-line chart in excel is very simple! if your spreadsheet has multiple groups of data, you can view the data visually by creating a chart with multiple lines. you can create a new chart or add lines to an existing chart. this article will show you how to create a multi-line chart
  • How to create a newline in Excel 2020How to create a newline in Excel 2020
    simple way down line in excel 2020. during data entry in excel, there is much longer content than the width of the cell, so the data is overflowed to other cells. so you want to go down the line so that the data is displayed in a full cell, help ch
  • How to disable Hyperlink in ExcelHow to disable Hyperlink in Excel
    when you want to copy a certain line of text in excel, you have hyperlink. if the link is contained, when we check the text, we will access the inserted web page. so how to do it?
  • Instructions for adding alternate blank lines on Microsoft ExcelInstructions for adding alternate blank lines on Microsoft Excel
    in the process of performing operations on excel spreadsheet, how do you add a white line to the spreadsheet?
  • How to adjust line spacing and line spacing in ExcelHow to adjust line spacing and line spacing in Excel
    how to adjust line spacing and line spacing in excel line spacing (the height of the line) makes your spreadsheet look better and more synchronized. today dexterity software will guide you how to adjust the height of the line so fast and most beautiful offline!
  • How to fix 'Dotted Circle Animation Not Showing' error when turning off screen on Windows 10?How to fix 'Dotted Circle Animation Not Showing' error when turning off screen on Windows 10?
    the 'dotted circle animation not showing' error occurs when you restart your computer and a white dotted circle appears on the windows 10 screen that moves continuously without turning off. this is a rare error, but few people know how to fix it completely.
  • How to change spreadsheet color lines in ExcelHow to change spreadsheet color lines in Excel
    the default line on excel spreadsheets has quite fuzzy colors, which confuse users if used for a long time. however, you can also change the cell line color in excel.