How to Indent in Excel: A Step by Step Guide

As someone who spends a lot of time working with data in Excel, I can tell you that it can be incredibly frustrating when things aren't formatted just right. Whether it's for a client presentation or just for your own personal organization, making sure your Excel sheet is tidy and easy to read is crucial. One simple formatting technique that can make all the difference is indenting. In this step-by-step guide, I'll teach you exactly how to indent in Excel!

Step 1: Select the Cells You Want to Indent

The first step in indenting in Excel is to select the cells you want to indent. You can do this by clicking and dragging your mouse across the desired cells, or by clicking on the first cell and then holding down the Shift key while clicking on the last cell in your selection.

Step 2: Click on the "Indent" Button

Once you have your cells selected, you'll want to click on the "Indent" button. This can be found on the "Home" tab of your Excel ribbon, under the "Alignment" section. The "Indent" button looks like a series of arrows pointing to the right.

Step 3: Choose Your Indentation Level

Clicking on the "Indent" button will bring up a drop-down menu that allows you to choose your indentation level. You can either choose to indent one level by clicking on the top arrow, or two levels by clicking on the bottom arrow.

Step 4: Enjoy Your Indented Cells!

That's it! Once you've chosen your desired indentation level, you should see your cells automatically move over to the right. It's a small change, but it can make your data infinitely more organized and easier to read.

Other Tips for Using Indenting in Excel

If you're really looking to step up your Excel game, there are a few other tips and tricks for using indentation that can make your life even easier:

Indenting Multiple Rows

Instead of clicking and dragging your mouse to select multiple rows, you can use the "Shift" key to select a range of cells. To do this, click on the cell in the top row that you want to indent, hold down the "Shift" key, and then click on the last cell in the bottom row that you want to indent. From there, you can use the same indentation process as above.

Using Indentation with Bullets and Numbering

If you're creating a bulleted or numbered list in Excel, indentation can help make your list much easier to read. To use indentation with bullets or numbering, first create your list as normal. Then, select the cells you want to indent and click on the "Increase Indent" button in the "Alignment" section of the "Home" tab. This will move your bullet or number over a single indent level.

Using Indentation with Borders

If you're really looking to make your Excel sheet look polished and professional, using indentation in conjunction with borders can be a great strategy. To do this, use the "Format Cells" option (found on the "Home" tab) to add borders to your cells, and then use the "Indent" button to move your content over while keeping the borders in place.


Indenting in Excel is a simple but powerful technique that can make all the difference when it comes to organizing your data. With just a few clicks, you can make your Excel sheet infinitely more readable and easy to navigate. So next time you're working with data in Excel, try out the indentation technique and see how much of a difference it can make!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.