how to indent second line in excel cell

Moves in the right side of the paragraph by the amount you choose. At the bottom of the dialog box, you can see a Preview of how the options will look before you apply them. Indentation has all to do with the alignment of text. Display the month as an abbreviation (Jan-Dec). Trick I find: You can also adjust the spacing if you find the rows of text too tight together. To indent text in a cell, follow the steps below. Tap the keyboard toggle button to open the numeric keyboard. When you select Automatically adjust right indent when document grid is defined, the right indent is automatically adjusted for the paragraph when a document grid is defined. As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. Keep in mind that each point is 1/72 of an inch. 4. Pressing the [Tab] key in Excel does not indent text in a cell; it simply moves the cell pointer to the next cell. To remove grouping for certain rows without deleting the whole outline, do the following: Select the rows you want to ungroup. Even for text aligned to the right, you have to increase the indent to make the text-indent towards the left. To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. This is because the cell remains in the General number format. The first section is the format for positive numbers, the second for negative numbers, and the third for zero values. Choose Left to align text to the left with a ragged right edge (or use the keyboard shortcut, Ctrl+L). Display the month as a number without a leading zero. For a better experience, please enable JavaScript in your browser before proceeding. You can select this option multiple times, indenting to what looks right and can also decrease the indent to remove any indents and to go back to the previous alignment of the text. Click the Color drop-down arrow and select any one of the colors. To do this, select the characters in the formula bar and click Cells on the Format menu. In the Format Cells dialog, select the Alignment In the Indent bar . Choose from these options in the Paragraph dialog box. Press one after the other: The Alt key displays the shortcut keys for the tabs. Yes, you can just press the Spacebar twice, but doing that when you operate with a large number of cells is way too time-consuming. To increase the indent, highlight the cells you want to format (B4:B13). Adjusts the amount of space after a paragraph. Note, the number of "x" characters displayed in the cell vary based on the width of the column. It enables you to get into edit mode. Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result. In the Format Cells dialog box that appears, switch to the Alignment tab. This comprehensive guide will show four simple ways to indent text in Excel and help you take another step toward becoming a formatting guru. Looking for money-saving deals on Microsoft Office? All Rights Reserved. 5. Hes written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips. Select the values (from sheet) for the X Axis Values. Sep 1, 2008. The list of choices in the Font Style list varies depending on the font that is selected in the Font list. For example, you can insert bullets in your cells and then indent the text and the bullets. Vendors | Privacy Policy | Excel Consulting. Excel displays a number to the right of the "E" symbol that corresponds to the number of places the decimal point was moved. Choose First line > By to indent the first line of a paragraph. 2. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows. When text is left-aligned, the indent is from the left edge of the cell. 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). Double-click the cell in which you want to insert a line break. Click the arrow next to the Pattern box, and then click the pattern style and color that you want. Unfortunately, you can not do that using the indenting options covered above. You must have more than one line of wrapped text to see the justification. Display whatever text is inside the quotation marks. To protect the document or the file from a user who has malicious intent, use Information Rights Management (IRM) to set permissions that will protect the document or the file. To include a background color with the pattern, click a color in the. Type the space character that enables you to get the desired Indentation. {"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":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Indent-in-Excel-Step-4-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/ae\/Indent-in-Excel-Step-4-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5e\/Indent-in-Excel-Step-5-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/5e\/Indent-in-Excel-Step-5-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c6\/Indent-in-Excel-Step-6-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-6-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/c6\/Indent-in-Excel-Step-6-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Indent-in-Excel-Step-7-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-7-Version-2.jpg","bigUrl":"\/images\/thumb\/1\/1e\/Indent-in-Excel-Step-7-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7e\/Indent-in-Excel-Step-8-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-8-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/7e\/Indent-in-Excel-Step-8-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0e\/Indent-in-Excel-Step-9-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/0\/0e\/Indent-in-Excel-Step-9-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Indent-in-Excel-Step-10-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/d3\/Indent-in-Excel-Step-10-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6f\/Indent-in-Excel-Step-11-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/6f\/Indent-in-Excel-Step-11-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9a\/Indent-in-Excel-Step-12-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-12-Version-2.jpg","bigUrl":"\/images\/thumb\/9\/9a\/Indent-in-Excel-Step-12-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Indent-in-Excel-Step-13-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-13-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Indent-in-Excel-Step-13-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, Indenting Individual Text Lines in a Cell, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Indent-in-Excel-Step-14-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-14-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/3c\/Indent-in-Excel-Step-14-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Indent-in-Excel-Step-15-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-15-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/4d\/Indent-in-Excel-Step-15-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"