Follow these steps to indent data in cells: Select the cells containing text you want to indent. On the Home tab, in the Alignment group, click the Increase Indent button. Each time you click the Increase Indent button, Excel adds a small amount of space between the cell border and the data itself.
![Excel Excel](/uploads/1/1/8/3/118304597/965122768.jpg)
- Points
- 8
- Trophies
- 1
- Posts
- 2
For those of you that know what an indented BOM is this will make perfect sense.Below is what I have tried and failed at, so it may not be possible to do what I want but I'm sure someone can come up with Plan B.e.g. C2 will have the formula: =IF(A2=2,F2,').....D2 will have the formula: =IF(A2=3,F3,')
etc.
So the issue is that the formulas keep the adjoining cells from displaying all of the F column info and will display only what fits into the cell.1. Is there a way for all of the information to display across cells with formulas...OR
2. Using Example 2, below, is there a way to indent the information in the same column (B) by reading column A?- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
Excel Hanging Indent In Cell
- You will learn to give your data more visual structure by indenting content within a cell. Index to my other excel videos: https://teklern.blogspot.com/p/exc.
- I would like to apply conditional formatting based on the indentation of text in a cell. I have a chart of accounts in excel, with a parent-child hierarchy. I want to format all top-level parents (i.e. No indentation) with bold (or whatever formatting) then all second-level (i.e. One indent) with italics. Is this possible?
- One click of the Indent Button inserts a Left Indent, with an Indent value of one (1), as you can see in the Format Cells dialog box below. This works well in making text more readable when next to a column of numbers.