If you need to change the indentation quite often, you can also add the indent icons to the Quick Access Toolbar. So, if you have multiple lines in the same cell, all the lines would be indented. Note that the indentation is applied to the entire cell content. In the Alignment group, click on the indent icons (based on whether you want to indent left or right).
If you prefer using the mouse instead, Excel has the options in the ribbon where you can indent with a click on a button.īelow are the steps to indent using the ribbon options: To use this shortcut, select the cells where you want to apply the indent and then press these keys in succession (one after the other). Suppose you have a data set as shown below and you want to intend the numbers a little to the right.īelow is the keyboard shortcut you can do to that: ALT + H + 6 (to indent to the right) ALT + H + 5 (to indent to the left)
