- #HOW TO DOUBLE UNDERLINE IN EXCEL HOW TO#
- #HOW TO DOUBLE UNDERLINE IN EXCEL UPDATE#
- #HOW TO DOUBLE UNDERLINE IN EXCEL FREE#
- #HOW TO DOUBLE UNDERLINE IN EXCEL WINDOWS#
To underline blank spaces for a printed document, use the Tab key and apply the underline formatting to the tab characters. Go to Home > Show/Hide ¶ so that you can see the marks that indicate spaces and tab stops. Select the tab characters that you want to underline. A tab character looks like a small arrow.
Press Ctrl+U to apply a simple underline. To apply a different style of underline, go to Home and select Font dialog box launcher. Underline blank spaces for an online document Select Underline style to choose a different underline style. To create an underline in an online document or form, insert a table cell with the bottom border turned on. 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. Select the upper-left box to insert a 1x1 Table. If you want to add introductory text, such as a name or Social Security Number, before the underline, insert a 2x1 Table. 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). On the Design tab, select Borders > Borders and Shading. Under Style, select the line type, color, and width that you want. In the diagram under Preview, click or tap between the lower margin markers to add the bottom border.
#HOW TO DOUBLE 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.
#HOW TO DOUBLE 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 DOUBLE 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 HOW TO DO DOTTED UNDERLINE IN EXCEL HOW TO Microsoft Word offers presets for many shapes, including dotted lines, in many styles. HOW TO DO DOTTED UNDERLINE IN EXCEL WINDOWS.HOW TO DO DOTTED UNDERLINE IN EXCEL FREE.
#HOW TO DOUBLE UNDERLINE IN EXCEL UPDATE#
Update – As of late February 2017, a double underline is available in Google sheets without needing to use any workarounds. None of them are perfect, but you should be able to get the effect that you are looking for. What is one to do? Before you abandon ship, you should realize that there are a few decent work arounds for the issues. This is one of the few ways in which Sheets is inferior to Excel. There has been much gnashing of teeth for those making the switch to Google Sheets when they find that their faithful double underline function is not there. Lots of spreadsheet users can’t imagine life without their double underline feature.