Unfortunately, you can not do that using the indenting options covered above. In case you have multiple lines in the same cell, you may want to indent only some of the cells and not the others. Indenting Individual Lines in the Same Cell Just right-click on the indentation icon and then click on the ‘Add to Quick Access Toolbar’‘įun fact: When you indent using these options, Excel indents equivalent to three space characters. 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).Select the cells where you want to apply the indentation.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) Indenting Individual Lines in the Same Cell.
0 kommentar(er)
