• Indent Content Excel
• Indent Contents In Excel

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

For extra space between cell text and the left or right cell border, click “Left (Indent)” or “Right (Indent).” Click “Distributed (Indent)” to have equal spacing between both the text and the cell borders on both sides. In the “Indent” box, select the size of your additional spacing.

1. Print How to Modify Cell Alignment & Indentation in Excel Worksheet 1. Under what ribbon menu and grouping of commands will you find the short-cut icons for aligning content in a spreadsheet?
2. Range.InsertIndent method (Excel); 2 minutes to read; In this article. Adds an indent to the specified range. Expression.InsertIndent (InsertAmount). Expression A variable that represents a Range object.
3. There are two types of Indent one is “Increase Indent” and second is “Decrease Indent”. “Decrease Indent is used to move the content closer to the cell border” “Increase Indent is used to move the content further away from the cell border”.

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:

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)

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.

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:

Indent Content Excel

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 indentation
4. Enter the space character to get the desired indentation

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:

Indent Contents In Excel

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