Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to indent cell content in Excel

How to indent cell content in Excel

Transcript 

Excel provides a simple way to horizontally indent cell content. Indents work in steps, allowing you to use more than one level of indentation.

Let's take a look.

Here we have a simple budget worksheet. Let's apply some indentation to make the categories a little more readable.

The easiest way to indent is to use the Indent buttons in the Alignment group on the home tab of the ribbon. One button increases the indent by one step, and the other button decreases the indent by one step.

Once you reach zero, clicking decrease indent has no further effect.

Because indents can be set in steps, Excel allows you to have multiple levels of indentation. For example, we can indent all expenses under the Expense category. And then further indent sub categories under Housing and Transportation.

When text is left-aligned, the indent is from the left edge of the cell. However, when text is right-aligned, the indent is from the right edge of the cell.

You can also see and set the indent level using the Format Cells dialog box. The current indent setting is displayed next to the Horizontal alignment menu.

As you can see in the menu, only certain alignment options support indents. If you switch to an alignment that doesn't support indents, the indents will be removed.

On the other hand, if you add an indent to an alignment that doesn't support indents, Excel will automatically switch alignment to left-aligned text.

We can see this same behavior using the buttons on the ribbon. If we apply an indent to center-aligned text, which doesn't support indents, it is immediately left-aligned.

When cells with multiple levels of indents are selected, you can't use the decrease indent button to step back to zero. However, in the Format Cells dialog box, you can set the Indent to zero to clear all indentation in multiple cells.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Thank you, this is an excellent site to get an understanding of all the Excel formulas. Especially for brushing up or just rechecking the formulas.
Priti
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page