Using this shortcut, you can only add one indent at a time. In the following example, I have pressed the 6 key one time to add one indent in cell A1.
Press the 6 key on your keyboard once to add one indent. The Excel Ribbon will then appear as follows with numbers 5 and 6 under the Decrease Indent and Increase Indent buttons respectively. Select the range to which you want to add or increase indents. To add or increase indents do the following: In the following example, I have removed all the six indents I had put earlier by clicking on the Decrease Indent button six times.Īnother way you can add, increase, or remove indents is by using the keyboard shortcuts Alt + H, 5 and Alt + H, 6. Go to the Home Tab and click on the Decrease Indent button once or several times to completely remove the indents, depending on how many indents your dataset has. 
Select the range where you want to remove the indents. In the following example, I have increased the indent in cell A1 five times by clicking the Increase Indent button 5 times. In the following example, I have added one indent in cell A1 by clicking the Increase Indent button once. Click once or more times depending on how many indents you want to add to your dataset. Click Home > Alignment > Increase Indent. Select the range where you want to add and increase indents. To Add and increase Indents, carry out the following steps: The Decrease Indent and Increase Indent buttons are in Home > Alignment on the Excel ribbon. Use the Increase Indent and Decrease Indent Buttons Change the Horizontal Text Alignment in the Format Cells dialog box. Use the Keyboard shortcuts Alt + H, 5 and Alt + H, 6. Use the Increase Indent and Decrease Indent buttons. You can apply some or all of them depending on your situation. In this tutorial, I will show you the following five ways you can use to add, increase, or remove indents in Excel. Example of a dataset without indents Example of a dataset with indents Way of Adding, Increasing, or Removing Indents 
When you look at the following examples, you can see that the dataset without indents is difficult to read and follow but the one with indents is much easier. Indents make your dataset easier to read and follow To add or increase indents, do the following:.To add or increase indents do the following:.To Add and increase Indents, carry out the following steps:.Use the Increase Indent and Decrease Indent Buttons.Way of Adding, Increasing, or Removing Indents.Indents make your dataset easier to read and follow.
0 kommentar(er)
