Middle Align: Aligns content an equal distance from the top and bottom borders of the cellīottom Align: Aligns content to the bottom border of the cell Top Align: Aligns content to the top border of the cell Right Align: Aligns content to the right border of the cell For example, holding down Ctrl + Shift and pressing the Spacebar five times would create an underline five characters long. Next, click inside the last empty dialog box and enter a number higher than your first entry. Press and hold this keyboard shortcut combination to add multiple underlines next to each other, creating an underline. Click on the first empty dialog box and enter any number. Left align: Aligns content to the left border of the cellĬenter align: Aligns content an equal distance from the left and right borders of the cell Another option that can give a similar effect as adding underline format is to add a bottom border to the cell which contains the text. To create an underline without any text in Microsoft Word, press Ctrl + U to start the underline, then, press Ctrl + Shift + spacebar to create non-breaking spaces. Changing the alignment of your cell content allows you to choose how the content is displayed in any cell, which can make your cell content easier to read.Ĭlick the arrows in the slideshow below to learn more about the different text alignment options.
Text alignmentīy default, any text entered into your worksheet will be aligned to the bottom-left of a cell, while any numbers will be aligned to the bottom-right. In your case, (if I understand you right) you would highlight all cells from A1 to K10 (assuming a maximum of ten rows), and then make the conditional formatting formula as follows: AND (NOT (ISBLANK (A1)),ISBLANK (A2)) Then just apply the border by setting it up in the 'Format.' options as shown in the examples. Select the text that you want to underline. You can also underline text and spaces in several other ways. Apply a bottom border to just that cell, and no borders to the. Make the right column the width that will fit both the text in question and the lengthy of they border. If you want greater separation, insert a table in the header (at least two columns). When you want to stop underlining, press Ctrl+U again. Type the text and click Right Align from the Home tab and Underline (select text and Ctrl+U). You can also press Ctrl+B on your keyboard to make selected text bold, Ctrl+I to apply italics, and Ctrl+U to apply an underline. The quickest way to underline text is to press Ctrl+U and start typing.