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
- 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
May be interested
- MS Excel - Lesson 4: Working with lines, columns, sheetsin 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 Excelthis 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 boxmanipulating 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 Exceldrawing 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 2020simple 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 Excelwhen 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 Excelin 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 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?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 Excelthe 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.