nomadboutique.blogg.se

How to do dotted underline in excel
How to do dotted underline in excel





  1. HOW TO DO DOTTED UNDERLINE IN EXCEL HOW TO
  2. HOW TO DO DOTTED UNDERLINE IN EXCEL FREE
  3. HOW TO DO DOTTED UNDERLINE IN EXCEL WINDOWS

Microsoft Word offers presets for many shapes, including dotted lines, in many styles.

HOW TO DO DOTTED UNDERLINE IN EXCEL HOW TO

RELATED: How to Remove Automatic Horizontal Lines in Word How to Add a Dotted Line from a Shape Preset

HOW TO DO DOTTED UNDERLINE IN EXCEL WINDOWS

You can also undo each line that you make by pressing Ctrl+Z on Windows or Command+Z on Mac.Īnd if these automatic horizontal lines ever get on your nerves, you can turn them off completely in Word’s AutoCorrect options.

HOW TO DO DOTTED UNDERLINE IN EXCEL FREE

Make sure only the bottom line is displayed.Besides asterisks, you can also use the following characters for other dotted-line styles:įeel free to experiment with these and see which one you like best. In the diagram under Preview, click or tap between the lower margin markers to add the bottom border. Under Style, select the line type, color, and width that you want. On the Design tab, select Borders > Borders and Shading. To change the length of the line, move the pointer over the end of the table until it becomes a resize pointer, and then move the arrow right or left to lengthen or shorten the line.Ĭlick or tap in the table (or in the second table cell if you created a 2x1 table). If you want to add introductory text, such as a name or Social Security Number, before the underline, insert a 2x1 Table.

how to do dotted underline in excel

Select the upper-left box to insert a 1x1 Table. This method ensures that when someone types on the line, the line stays in place.Ĭlick or tap where you want to insert a blank underline.

how to do dotted underline in excel

To create an underline in an online document or form, insert a table cell with the bottom border turned on. Underline blank spaces for an online document Select Underline style to choose a different underline style. To apply a different style of underline, go to Home and select Font dialog box launcher. Press Ctrl+U to apply a simple underline. A tab character looks like a small arrow. Select the tab characters that you want to underline. Go to Home > Show/Hide ¶ so that you can see the marks that indicate spaces and tab stops. To underline blank spaces for a printed document, use the Tab key and apply the underline formatting to the tab characters. Underline blank spaces for a printed document When you want to create an underline in an online form, insert table cells with the bottom border turned on. Also, if the AutoFormat option for changing underscore characters into border lines is turned on, pressing Shift+Hyphen (-) three or more times in a row will result in a line that extends the width of the paragraph, which may not be what you want.Ī better way to underline blank spaces for a printed document is to use the Tab key and apply the underline formatting to the tab characters. You can underline blank spaces by pressing Shift+Hyphen (-), but it is difficult to line up the underlines - if you are creating a fill-in form, for example. Select double underline in the Underline style drop-down list. Use the Underline color drop-down list to change the color of the line. Use the Underline style drop-down list to select an underline style. Tip: You can also use the keyboard shortcut Ctrl+D. Go to Font and select Words only in the Underline style drop-down list. Go to Home and select Font dialog box launcher. Select the text that you want to underline. Underline words, but not the spaces between them

how to do dotted underline in excel

You can also underline text and spaces in several other ways. When you want to stop underlining, press Ctrl+U again. The quickest way to underline text is to press Ctrl+U and start typing.

how to do dotted underline in excel

Underline words and the spaces between them







How to do dotted underline in excel