how to indent second line in excel cell

2. Elapsed time, in minutes. We have a great community of people providing Excel help here, but the hosting costs are enormous. On the "Home" tab, in the "Alignment" section, click "Increase Indent" (an icon with four lines . From beginner-friendly tutorials to advanced formulas and VBA guides, this site offers a wealth of information to help you work more efficiently and effectively. Select the cells with the content you want to indent. Select the style of the date from the Type list box. If you would like to add a staircase type look, you can select the cell, indent once and continue to add indents to the rest of the lines manually. Click the Home tab.3. Here are the keyboard shortcuts for indentation. Repeats the contents of the selected cell until the cell is full. At the bottom of the dialog box, you can see a Preview of how the options will look before you apply them. Under the Text alignment heading, you can specify the number of characters you want for your indent by typing it manually or using arrows to choose it (in our case, we selected 3). Choose Double to double-space text. How can I set the 2nd line of a word wrapped merge cell to indent? You can also right-click the cells to launch the Format Cells window, where you'll find the option to manually adjust your indentation settings. What makes this automatic? Use this method if your text extends beyond the right side of the cell. Place the cursor before the word in the text where you want the line break (weve chosen the word Tabby). When increasing the indent, the text will jump to the left side and start aligning from the left towards the right. % of people told us that this article helped them. Manually press space as many times as you want the indent size . Note: One-half inch is the typical measurement for indenting a hanging paragraph. To quickly create a first line indent using the ruler, see Create a first line indent. 4. To do this, select the characters in the formula bar and click Cells on the Format menu. Aligns cell contents along the top of the cell. The text will shift into two lines within the selected cell. Position the cursor where you want to apply Indentation. Highlight all the text (other than the first line of the paragraph) you want to indent. 4. This bar shows the current status of indents. Or press Shift + Alt + Left Arrow which is the Ungroup shortcut in Excel. Microsoft Excel displays a number according to the format of the cell that contains it. 3. Indents the paragraph on the right by the amount you choose. And thats how you change your cell contents appearance in Excel. Applies a border with the currently selected style and color to the top of the cell(s) in the selected region. The color palette on the Patterns tab is the same color palette from the Color tab of the Options dialog box. As you will note, the indent command buttons lie in the Alignment group under the ribbon menu. Click Home in the top toolbar. You must log in or register to reply here. Home How to Indent in Excel (3 Easy Ways + Keyboard Shortcut). Choose Hanging > By to create a hanging indent. This wikiHow will show you easy ways to indent text in cells in any Excel workbook. Now that we have two separate lines, lets adjust the indentation. However, if you try to do this in Excel, it will simply take you to the next cell on the right. The current indent setting is displayed next to the Horizontal alignment menu. In the Alignment group, click the Decrease Indent button (weve done it three times here as well). Aligns contents at the left edge of the cell. 3. Elapsed time, in seconds. Step One - Select your column. Sometimes, however, you need to indent the second line of the sentence or paragraph while leaving the first line flush with . Add space characters to indent it further. You can also have a line drawn from the upper-left corner of the cell to the lower-right corner, or from the lower-left corner of the cell to the upper-right corner. Applies a border with the currently selected style and color to all vertical sides in the interior of the currently selected group of cells. In the Format Cells dialog box that appears, switch to the Alignment tab. 1. Select the second tab 'Alignment' and set the orientation to 45 degrees. Click OK out of this form and the first one. Type the desired text. Keep clicking Increase Indent until the cell content is at the desired position. The wrap text option is useful if your text entry extends beyond the right edge of the cell. Learn more Do you want to change your indent settings in Microsoft Excel? Therefore, the number that you see in the cell may differ from the number stored by Excel and from the number used in calculations that refer to the cell. Select the Cell, Column, or entire sheet in which you want to add indent. Display whatever text is inside the quotation marks. Choose Cells from the Format menu. Just right-click on the indentation icon and then click on the Add to, How to Indent in Excel (3 Easy Ways + Keyboard Shortcut), FREE EXCEL TIPS EBOOK - Click here to get your copy, Indenting Individual Lines in the Same Cell, How to Remove Cell Formatting in Excel (from All, Blank, Specific Cells), How to Insert a Check Mark (Tick Mark) Symbol in Excel, Remove Spaces in Excel Leading, Trailing, and Double, How to Split a Cell Diagonally in Excel (Insert Diagonal Line), Select the cells where you want to apply the indentation, In the Alignment group, click on the indent icons (based on whether you want to indent left or right), Double-click on the cell (or press F2 to get into the edit mode), Place the cursor where you want to insert in the indentation, Enter the space character to get the desired indentation. Have a look at the Accounting and Custom number formats that involve the use of _ ( and _). If you want to remove a specific border, click the button for that border a second time. Double-click the cell in which you want to insert a line break. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/56\/Indent-in-Excel-Step-3-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/56\/Indent-in-Excel-Step-3-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"