The Merge Cells option combines two or more selected cells into a single cell. Step One - Select the cells. You can see a preview of your settings by reviewing the Preview section of the dialog box. As expected, indenting changes the appearance to the following (Fig. Double-click the cell in which you want to insert a line break. Click "Wrap Text" on the home tab of your Excel sheet to create several lines of text that fit within the column's dimensions. 3. 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. Indenting cell data. When you press Enter to start the next paragraph, its first line will be indented. Percentage. Aligns contents at the right edge of the cell. Choose from dotted, dashed, solid and double border lines. This quick-and-dirty method will come in handy for those who prefer using the keyboard. And thats how you change your cell contents appearance in Excel. However, if you try to do this in Excel, it will simply take you to the next cell on the right. To use one of these formats, click any one of the categories below General and then select the option that you want for that format. Go to the Alignment tab and add the Indent value as desired. With a little effort, even this clumsy method can bear fruit. 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. Click the "Wrap Text" icon. In the Format Cells dialog, select the Alignment In the Indent bar . From there, indents must be added using space characters. To create a custom number format, click Custom in the Category list on the Number tab in the Format Cells dialog box. To create Fig. Then, type your custom number format in the Type box. Click the Dialog Box Launcher arrow at the bottom right corner of the Alignment. In the Indentation area of the form, pull down the Special control and choose Hanging. Pressing the [Tab] key in Excel does not indent text in a cell; it simply moves the cell pointer to the next cell. 2. To add an indent to a line, put your cursor to the front of that line and then press Spacebar. But what would you do if you wanted to decrease or remove the indentation applied to some or all of your worksheet cells? 5. Then, take the cursor to the leftmost side of the cell. 5. Unfortunately, you can not do that using the indenting options covered above. Otherwise, the hour is based on the 24-hour clock. Type . 2). Adjusts the amount of space after a paragraph. {"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":"