Indentation in Excel – 5 Methods

This is an overview.

Overview of indentation in Excel


Download Practice Workbook

Download the workbook and practice.


What is Indentation?

Indentation refers to the horizontal alignment and positioning of text within a cell.


How to Indent in Excel

Method 1 – Indent Using Ribbon Option

  • Select C5:C12.
  • Go to the Home tab and click Alignment.
  • Select Increase Indent.

Right indent by ribbon option

This is the output.

Increase Indentation

  • To indent cells leftward, go to Home >> Alignment.
  • Select Decrease Indent.

Left indent by ribbon option

This is the output.

Indended left


Method 2 – Indent Using a Keyboard Shortcut

For rightward indentation,

  • Select C5:C15.
  • Press ALT + H + 6.

Right indent by keyboard shortcut

  • For leftward indentation, select the cells.
  • Press ALT + H + 5.

Left indent by ribbon option


Method 3 – Using the Space Bar to Indent Manually

  • Click the cell and press the space button.

 Indent manually


Method 4 – Using the Format Cells Dialog Box

  • Select C5:C12 and right-click.
  • Select Format Cells.

Select format cells option

  • Go to Alignment and change the Indent. Here, to 4.
  • Click OK.

Set the indentation value

This is the output.

 Outcome of changing indentation


Method 5 -Using the Wrap Text Feature

  • Select C12 and go to the Home tab.
  • Select Alignment group and choose Wrap Text.
  • Increase the row height manually.

Warp selected cell

  • Click the line to add indent and press ALT + ENTER.

Apply shortcut to add line break

This is the output.

  • Enter space at the start of 2nd line.

Add space to indent the line

This is the output.


How to Find the Indentation Level?

To find the indentation level, insert a column (Indentation Level).

Indented dataset

  • Select a cell and press CTRL + F to open up the Find and Replace window.
  • Choose Format.

Open Find and Replace feature

  • Change the Indent. Here, to 1.
  • Click OK.

Insert indentation number

  • Click Find All in the Find and Replace window.

Find the result

  • You will find information on data containing Indent 1.
  • To mark it with different colors, select the cells in the Find and Replace window.
  • Select a Fill Color in Font.

Highlight with color

  • Repeat the process to mark all indentations in the column.

Color all the cells based indentation

  • Filter the column by choosing Filter by Color.
  • Enter a number based on the filled color in the Indentation Level column manually.

Filter cells by color

  • Enter the indentation level and drag down the Fill Handle to see the result in the rest of the cells.

Insert level of indentation by color based on set up color

  • Repeat the process for the other colors.
  • Remove the filter.

This is the output.

Final outcome of indentation level


Frequently Asked Questions

1. Can I apply different levels of indentation to different parts of a cell’s text?

No, in Excel, the indentation settings apply to the entire content of a cell.

2. Is it possible to indent numbers or formulas in Excel?

No, indentation in Excel is primarily used to adjust the alignment of text within a cell.

3. Does indentation in Excel affect the cell width or height?

No, indentation does not directly affect the width or height of a cell. It only changes the horizontal alignment of the text within the cell.

4. Can I remove the indentation from a cell’s text in Excel?

Yes, following these steps:

  • Select the cell(s).
  • Right-click the selected cell(s) and choose Format Cells.
  • In the Format Cells dialog box, choose Alignment.
  • In Indent, set the indentation value to 0.
  • Click OK.

Indent zero in Excel

 


Indentation in Excel: Knowledge Hub


<< Go Back to Excel Cell FormatLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Annyca Tabassum
Annyca Tabassum

Annyca Tabassum holds a BSc degree in Geography and Environment from Shahjalal University of Science and Technology, Bangladesh. She has a deep passion for Excel. As an Excel & VBA Content Developer for ExcelDemy, she not only provides solutions to complex issues but also demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, she is interested in Data Analysis with MS Excel, SPSS, Python Web... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo