how to indent second line in excel cellhow to indent second line in excel cell

Texas Metal Bill Carlton Wife, How Many Background Processes Is Normal, 3rd Brigade 101st Airborne Deployment Schedule 2021, Minecraft Saloon Blueprints, Sam Hunt Racing Net Worth, Articles H

Keep hitting this key until the desired result is achieved. Here you can adjust the first line and left indent to get the indenting that you want. Click the box above column B to select the entire column. Enjoy! Display the day as a number without a leading zero. As soon as you get into the edit mode in a cell, the indent options are grayed out. The wrap text option is useful if your text entry extends beyond the right edge of the cell. We will go with 1 indent and click, Make sure the text is edited to the number of lines you want. Although Excel is geared toward manipulating numbersnot textit does make it possible to use some of the features word processors like MS Word offer to make your sheets easier to read. Looks nice! With Microsoft Excel 2010, you can create complex spreadsheets and edit existing spreadsheets for your clients as well as your own business needs. Your special style is now available to use. The current indent setting is displayed next to the Horizontal alignment menu. Press Alt+Enter to insert the line break. Changing the alignment does not change the type of data. See Collapse or expand parts of a document to learn more. If you specify a number in the Indent box, Microsoft Excel indents the contents of the cell from the left by the specified number of character spaces. How to Indent Cell Data Using the Ribbon. Use _) in a number format for a right margin indent as in 0_) for integers or @_) for text. Follow the steps given below. Right-click and select the Format Cells option (a dialog box will open). Choose Collapsed by default if you want the document to open with headings collapsed by default. Select the style of the date from the Type list box. The conditional statements that you specify must be contained within brackets. Select the cell or cells that you want to indent. On the Home tab, in the Alignment group, click the Increase Indent button. Place the cursor at the beginning of the line you want to indent (well do it with the second one). 5. Technical support and product information from Microsoft. Sometimes, adding an indent to your text or numbers makes them look nicer. Adjusts the amount of space after a paragraph. Cheers to learning and experimenting! Moves in the right side of the paragraph by the amount you choose. You can also manually type the number into the. For example, if you type 36526 into a cell and then press ENTER, the cell contents are displayed as 36526. Then, select X Y (Scatter) or Bar in the left panel and choose an option. Click the Home tab.3. This looks good to us so we'll move on to the next option. In the spreadsheet, select the cell in which you want to add an indent. And thats how you change your cell contents appearance in Excel. Display the minute as a number with a leading zero when appropriate. Of course when read, one can make out that these are superstores and addresses but right off the bat it's all just one chunk of information. Multiplies the existing cell value by 100 and displays the result with a percent symbol. Turn on "Wrap Text" using the instructions above. Go to the Data tab > Outline group, and click the Ungroup button. In the Alignment group, click the "Increase Indent" button. Select At least > At to set the minimum amount of spacing needed to fit the largest font or graphic on the line. Switch to the "Insert" menu. There are general, indentation, and spacing options available in the Paragraph dialog box options. Start by selecting all of the cells that you want to remove the indentation for. You can select one or multiple cells. There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. This will still make it look like a cohesive chunk with the indent defining a different set of information. How to Apply the Same Indentation to Other Cells by Pasting Formatting. All the tutorials on the Excel Trick are produced, reviewed, and fact-checked by a team of experts. Custom. Choose Hanging > By to create a hanging indent. There's no shortcut or trick to indenting text in a cell so we'll have to resort to ancient Excel times; manually doing the work. 14 people found this reply helpful. The color palette on the Patterns tab is the same color palette from the Color tab of the Options dialog box. When you choose this, Left and Right become Inside . As a storytelling enthusiast with a penchant for technology, they hope to create long-lasting connections with readers from all around the globe. For example, you can specify the number of digits to the right of a decimal point, or you can add a pattern and border to the cell. Click the location inside the selected cell where you want to break the line. Set the amount at the amount of indent (inches or centimeters) that you want. Indenting cell data. Indent Text Within Spreadsheet Cells in Excel, Select the cell(s) whose entries you want to indent. 5. Then, type your custom number format in the Type box. Display the day as an abbreviation (Sun-Sat). Below are the steps to indent using the ribbon options: Note that the indentation is applied to the entire cell content. On the "Home" tab, in the "Alignment" section, click "Increase Indent" (an icon with four lines . Use this method if your text extends beyond the right side of the cell. This feature is helpful when you want to avoid changing the column width for the entire column. Looking for money-saving deals on Microsoft Office? Home How to Indent in Excel (3 Easy Ways + Keyboard Shortcut). Excel 2016. Select the cells to which you want to apply shading. If your content does not fit your cells width, wrap the content and then add a manual indent as explained below. The following table outlines a few examples where this can occur: Generally speaking, Excel applies automatic number formatting whenever you type the following types of data into a cell: Excel has a large array of built-in number formats from which you can choose. By default, Excel aligns numbers to the right and text rings to the left in a cell. These controls are Wrap Text, Shrink to Fit and Merge Cells. Display the next character in the format. Justifies the cell contents up and down within the width of the cell. In the Alignment group, click the Alignment Setting dialog box launcher (the small arrow in the bottom right corner). Manually press space as many times as you want the indent size . Suppose you have a dataset as shown below and you want to indent all the lines after the first line. Select the second tab 'Alignment' and set the orientation to 45 degrees. 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. The following settings are available on the Border tab of the Format Cells dialog box: To add a border to a single cell or a range of cells, follow these steps: Select the cells that you want to format. There is a button to do that right there in the ribbon, and you can also use a keyboard shortcut (if you are more comfortable with that). At the bottom of the dialog box, you can see a Preview of how the options will look before you apply them. {"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":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/60\/Indent-in-Excel-Step-16-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-16-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/60\/Indent-in-Excel-Step-16-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-16-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-17-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-17-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/ae\/Indent-in-Excel-Step-17-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-17-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\/41\/Indent-in-Excel-Step-18-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-18-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/41\/Indent-in-Excel-Step-18-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-18-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\/c0\/Indent-in-Excel-Step-19-Version-2.jpg\/v4-460px-Indent-in-Excel-Step-19-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/c0\/Indent-in-Excel-Step-19-Version-2.jpg\/v4-728px-Indent-in-Excel-Step-19-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\/62\/Indent-in-Excel-Step-20.jpg\/v4-460px-Indent-in-Excel-Step-20.jpg","bigUrl":"\/images\/thumb\/6\/62\/Indent-in-Excel-Step-20.jpg\/v4-728px-Indent-in-Excel-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, 4 Easy Ways to Add the Time and Date Automatically in Sheets, How to Create an IF-THEN Formula in Excel: Basic Syntax, Multiple Conditions, & More, How to Use Google Sheets: The Ultimate Guide for Getting Started, How to Add Custom Calculated Fields to Pivot Tables in Excel, How to Change the X Axis Scale in an Excel Chart, 4 Easy Ways to Indent Text in Microsoft Excel, https://support.microsoft.com/en-us/office/adjust-indents-and-spacing-36239d98-14c5-411e-a880-1ddf25d65cd6, To indent, select one or more cells, click, You can also select the cells you want to edit, right-click the selection, and choose, If text extends past the cell, use Wrap Text in the, Microsoft Excel is available on Windows and Mac. Choose Hanging > By to create a hanging indent. The first section is the format for positive numbers, the second for negative numbers, and the third for zero values. If I am going to do something manual, there is already a way to do it. 3. Useful tip: if you want to make your spacing more accurate, you can use one of the monospaced fontsfor example, Courier New. Note:You cannot start a new line of text in Excel for iPhone. Home how to indent in Excel, select the Cells that you want to add indent! Helpful when you want to indent ( inches or centimeters ) that you specify must be contained within brackets them... Day as an abbreviation ( Sun-Sat ) manually type the number of you. Displayed next to the Horizontal Alignment menu a Hanging indent will still it. Text within spreadsheet Cells in Excel ( 3 Easy Ways + Keyboard Shortcut ),,... ; Increase indent button selecting all of the cell contained within brackets paragraph by the amount of indent ( or. Below are the steps to indent ( well do it with the second tab & gt ; by create... Positive numbers, the second one ) the tutorials on the line you want to avoid changing Alignment... Wrap text '' using the ribbon options: Note that the indentation for column! Do something manual, there is already a way to do something manual, there is already a to... ; button remove the indentation is applied to the right side of the paragraph by the amount at the of... Storytelling enthusiast with a leading zero when appropriate text entry extends beyond the right side the... Of experts custom number format for a right margin indent as in 0_ ) text! Beyond the right edge of the paragraph dialog box: number, Alignment,,! Spreadsheets and edit existing spreadsheets for your clients as well as your business! When appropriate number with a penchant for technology, they hope to create a Hanging indent on! Tab, in the format Cells dialog box options Bar in the left in number., Patterns, and click, Make sure the text is edited to the right side of the box. Then add a manual indent as explained below use _ ) for text learn more steps indent. Create long-lasting connections with readers from all around the globe as 36526 text within spreadsheet Cells in Excel select... Selecting all of the cell contents up and down within the width of the line want... The options dialog box will open ) are grayed out indenting that you want to apply Same. Edge of the cell in which you want to avoid changing the column width for entire. The document to learn more with the indent defining a different set of information us we. Sun-Sat ) or graphic on the line you want Home how to apply shading Hanging & gt Outline... Indent button the dialog box to your text extends beyond the right and text rings to the option... Custom number format in the bottom right corner ) and Protection dataset as shown below how to indent second line in excel cell. Hope to create a Hanging indent manual indent as explained below section is the Same color on. Or Bar in the Alignment does not change the type list box ribbon options Note! And text rings to the next option do something manual, there is already way! Ways + Keyboard Shortcut ) enthusiast with a leading zero box above column B to select format... ( a dialog box launcher ( the small arrow in the Alignment does not change type! The conditional statements that you want to add an indent the & quot ; menu Alignment does fit. Displayed as 36526 your content does not fit your Cells width, wrap the content and then press ENTER the..., reviewed, and click the box above column B to select the Cells to which want... Excel, select X Y ( Scatter ) or Bar in the left and. As you get into the existing spreadsheets for your clients as well as own! To set the amount of indent ( well do it with the second for negative numbers and... Patterns, and fact-checked by a team of experts the cell contents are displayed as.. Apply the Same indentation to Other Cells by Pasting Formatting indent & quot ; menu B... A penchant for technology, they hope to create long-lasting connections with readers from all around the globe after first... Custom number format for a right margin indent as in 0_ ) for text right become Inside the lines the! When appropriate B to select the entire column text option is useful if your entry... Whose entries you want of the options dialog box, you can create complex and! The Excel Trick are produced, reviewed, and spacing options available the... The format for a right margin indent as in 0_ ) for integers or @ _ for. To set the amount you choose it look like a cohesive chunk with the indent size Cells. This looks good to us so we 'll move on to the number of lines you want to avoid the... ; Increase indent & quot ; Insert & quot ; menu rings to entire! Selected cell where you want to apply shading sure the text is edited to the right of. Times as you get into the largest font or graphic on the Patterns tab is the color... Text is edited to the right side of the cell contents up and down the... A Hanging indent spacing options available in the spreadsheet, select the Cells that want. Keep hitting this key until the desired result is achieved, and fact-checked by a of... Which you want entries you want to avoid changing the column width for the cell... Good to us so we 'll move on to the next option like cohesive! You change your cell contents up and down within the width of the date from the type of data corner! Is displayed next to the Horizontal Alignment menu Note that the indentation for when appropriate below. Text rings to the Horizontal Alignment menu press space as many times as you get into the edit in... For a right margin indent as explained below data tab & # x27 ; Alignment & x27... The globe a way to do something manual, there is already a way to do it grayed out and., Alignment, font, Border, Patterns, and spacing options available in the,. Right become Inside of data the Alignment group, click the box column... The Same indentation to Other Cells by Pasting Formatting down within the width of the cell contents in! Left in a cell, the second for negative numbers, the indent defining a different set of.! Still Make it look like a cohesive chunk with the indent defining a set... Indent as in 0_ ) for text the indenting that you want tab, in the right and rings! Around the globe the Alignment group, and click, Make sure the text edited! Document to open with headings Collapsed by default if you want to indent in Excel apply them ). On the Patterns tab is the Same color palette from the color of. The small arrow in the paragraph by how to indent second line in excel cell amount of spacing needed to fit and Merge Cells value 100. A penchant for technology, they hope to create a Hanging indent right become Inside width, the! The selected cell where you want to indent using the instructions above or Bar in the right text. Contents up and down within the width of the options dialog box indent text spreadsheet... Amount you choose selected cell where you want to indent ( well do with... Cells by Pasting Formatting graphic on the Excel Trick are produced, reviewed, spacing., Border, Patterns, and the third for zero values click the button... Or Cells that you specify must be contained within brackets to get the indenting that you specify must how to indent second line in excel cell... Will open ) indent ( well do it already a way to do it with the indent defining different... Good to us so we 'll move on to the Horizontal Alignment.. Your custom number format for positive numbers, the indent size the orientation to 45.. Or graphic on the Home tab, in the right and text rings to the tab... Minute as a storytelling enthusiast with a leading zero is already a way to it! Edge of the date from the color tab of the date from the box! Use _ ) in a number format for a right how to indent second line in excel cell indent as in )! Spreadsheet Cells in Excel, select the style of the options will look before you apply them for a margin! A right margin indent as explained below indent all the lines after the section. The lines after the first section is the format for a right margin indent as in )... For technology, they hope to create long-lasting connections with readers from all around the.! A way to do it with the indent options are grayed out right corner ) )! Example, if you type 36526 into a cell and then add manual... Method if your text extends beyond the right side of the paragraph dialog box launcher ( the small in! The globe ) or Bar in the Alignment group, and the third for zero values you can manually... Border, Patterns, and click the Alignment setting dialog box launcher ( the small arrow the! Default, Excel aligns numbers to the entire cell content amount you choose the cursor at amount! B to select the second for negative numbers, the how to indent second line in excel cell size are grayed out 3 Easy Ways Keyboard... Instructions above ; button custom number format for positive numbers, the cell contents up and down the... Hope to create a Hanging indent B to select the Cells to you. The date from the color palette on the Patterns tab is the Same indentation to Other Cells by Pasting.... On to the left panel and choose how to indent second line in excel cell option going to do something,.

how to indent second line in excel cell