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.
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:
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:
An alternative option is to indent using the Format Cells dialog box.
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.
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 pressto get into the edit mode (or double click on the cell). Position the cursor where you want to insert a new line and press + .
Once your data is split the way you want it, position the cursor at the beginning of the line and pressuntil you are satisfied with the indentation. Move to the next row if needed and repeat. When you are done, press to finish your changes.
And here is how the indentation process looks step by step.
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.
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:+ +
Keyboard shortcut to Decrease Indent in Excel:+ +
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.
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.
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?
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.