How to Indent in Excel (3 Easy Ways + Keyboard Shortcut)

By default, Excel aligns numbers to the right and text rings to the left in a cell.

Text and Number alignment in Excel

And if you don’t like these numbers/texts are too close to the cell border, you also have an option to indent the content of the cell. You can indent to the left or to the right in a cell.

In this short Excel tutorial, I will show you how to indent In Excel.

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).

So let’s get started!

Indent using a Keyboard Shortcut

Suppose you have a data set as shown below and you want to intend the numbers a little to the right.

Below 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)

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).

Indent using Ribbon Options

If you prefer using the mouse instead, Excel has the options in the ribbon where you can indent with a click on a button.

Below are the steps to indent using the ribbon options:

  1. Select the cells where you want to apply the indentation
  2. Click the Home tab
  3. In the Alignment group, click on the indent icons (based on whether you want to indent left or right)

Indent icons in the Excel ribbon

Note that the indentation is applied to the entire cell content. So, if you have multiple lines in the same cell, all the lines would be indented.

If you need to change the indentation quite often, you can also add the indent icons to the Quick Access Toolbar. Just right-click on the indentation icon and then click on the ‘Add to Quick Access Toolbar’

Fun fact: When you indent using these options, Excel indents equivalent to three space characters.

Indenting Individual Lines in the Same Cell

In case you have multiple lines in the same cell, you may want to indent only some of the cells and not the others.

Unfortunately, you can not do that using the indenting options covered above. As soon as you get into the edit mode in a cell, the indent options are grayed out.

This, however, can be done with a work-around that is not very elegant. You can do this by manually adding the space characters before the lines in which you want to add the indent.

Suppose you have a dataset as shown below and you want to indent all the lines after the first line.

Below are the steps to add an indent to multiple lines in the same cell:

  1. Select the cell
  2. Double-click on the cell (or press F2 to get into the edit mode)
  3. Place the cursor where you want to insert in the indentationPlace the cursor where you want to indent
  4. Enter the space character to get the desired indentationIndent in the lines in the same cell

In case you want to have the indentation in multiple lines, you need to place the cursor at each line and add the space characters.

So these are some of the ways you can use to indent in Excel.

I hope you found this tutorial useful!

Other Excel tutorials you may like:

Excel Ebook Subscribe


Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Leave a Comment