How to indent in Excel [multiple solutions + keyboard shortcut]

April 14, 2022

Excel is great at manipulating and sharing data, but it sure doesn't shine when it comes to text formatting. However, simple changes like indenting text can significantly improve readability. In this short Excel tutorial, I will show you how to indent In Excel.

Indent using Ribbon Options

By default, Excel aligns text strings to the left of the cell and numbers to the right. If you don't like the look of your data, you can increase or decrease the indentation. This is how to increase indent in Excel cells:

  1. Select the cell that contains the text you want to indent.
  2. Click the Home tab.
  3. In the Alignment group, click on the Increase Indent icon.
The Indent buttons from the Alignment tab.

You can use the same process to indent multiple cells at once.

Removing cell indentation is just as easy. Follow steps 1 to 3 described above, but use the Decrease Indent icon instead.

Keep in mind that text alignment determines how Excel indents:

  • If the data is aligned to the left, Excel will indent from the left.
  • If the data is aligned to the right, Excel will indent from the right.
  • If your content is centered, the first time you press the Increase Indent icon, Excel will align your data to the left and indent once from the left.

Indent using Format Cells dialog box

An alternative option is to indent using the Format Cells dialog box.

The Alignment tab of the Format Cells dialog box.
  1. Select the cell or cells that you want to indent.
  2. Right-click and select Format Cells.
  3. Click on the Alignment tab.
  4. Insert the indent size in the Indent field or use the up and down arrows to adjust the indentation.
  5. Press OK.

Each indent moves the contents of the cell to the right by about three characters.

If you want to remove the indent, follow the steps described above and insert 0 (zero) in the Indent field.

Indent individual lines in the same cell

As you might have seen, the indentation is applied to the entire cell. This means that if you have text that spans across multiple lines, you won't be able to indent only one line using this method.

The good news is that there is a workaround to indent individual lines within the same cell. It's not pretty, and the method can't be applied to multiple cells at once, but it gets the job done.

For this to work properly, you need to have your text stored on multiple lines.

To achieve this, select the cell that you want to edit and press F2 to get into the edit mode (or double click on the cell). Position the cursor where you want to insert a new line and press ALT + ENTER.

Text stored in the same cell, but on multiple lines.

Once your data is split the way you want it, position the cursor at the beginning of the line and press Spacebar until you are satisfied with the indentation. Move to the next row if needed and repeat. When you are done, press ENTER to finish your changes.

Indented individual lines in the same cell

And here is how the indentation process looks step by step.

Indenting different lines within the same cell.

If you need additional spacing, all you need to do is enter the cell edit mode again and increase indent by adding more spaces at the beginning of the lines.

How to indent in Excel using a Keyboard Shortcut

If you prefer using your keyboard, you'll be happy to learn that two Excel indent shortcuts allow you to increase indent and decrease indent quickly.

Keyboard shortcut to Increase Indent in Excel: ALT + H + 6

Keyboard shortcut to Decrease Indent in Excel: ALT + H + 5

To use these shortcuts, select the cells where you want to apply the indentation and press the keys in the order shown above. You need to press the keys in succession (i.e., one after the other), not simultaneously.

What to do next?

If you have additional questions about how to indent in Excel, please leave a comment below. I reply to every message, and I really want to help you become better.

The easiest way to learn Excel is by solving problems. This is why I have created a dedicated section with useful Excel formulas.

About me
Radu from ExcelExplained

My name is Radu Meghes, and I'm the owner of excelexplained.com. Over the past 15+ years, I have been using Microsoft Excel in my day-to-day job. I’ve worked as an investment and business analyst, and Excel has always been my most powerful weapon. Its flexibility and complexity make it a highly demanded skill for finance employees. I launched excelexplained.com back in 2017, and it has become a trusted source for Excel tutorials for hundreds of thousands of people each year.

If you'd like to get in touch, you can contact me on LinkedIn.

Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

Essential Functions

Popular Articles

Excel courses

I have compiled a list of the best Excel online courses. It covers basic and advanced topics, VBA, and Power BI.
View courses
Excel is a very complex application, and understanding it on your own may prove difficult and time-consuming. I have created ExcelExplained.com to help you better understand each function and provide useful examples for different tasks. If you can’t find the answer to your question in one of the published articles, please leave a comment or send me an email, and I will do my best to help you out.

Affiliate Disclosure: When you purchase a product through a link on our website, I may earn an affiliate commission. There are no additional costs to you.
Copyright © 2017-2022 ExcelExplained.com
>