How Do You Increase Indent In Excel
- 1) A) Excel does not have indentation feature, 2) B) You can specify indentation only if you turn the rulers on, 3) C) Indentation can be set from Format Cells dialog box, 4) D) The indentation can be specified only when printing, 5) NULL.
- To get multiple lines within a cell use Alt + Enter to start a new line within the cell. To indent any line simply use spacebar a few times.
Hi all
I have some structured data which uses indentations to display a hierarchy (in the 'Format Cells' dialog under 'Alignment' there is a box 'Indent' which shows the indent/hierarchy level). I'm trying to pull out this indent level without success and hope someone may have some ideas.
I looked at using Get.Cell (http://www.mrexcel.com/forum/showthread.php?t=20611) but indent level doesn't seem to be an option. I tried using 53 to get contents as displayed including formatting but it doesn't include any leading spaces/tabs.
Can anyone help?
Thanks
Andrew
I have some structured data which uses indentations to display a hierarchy (in the 'Format Cells' dialog under 'Alignment' there is a box 'Indent' which shows the indent/hierarchy level). I'm trying to pull out this indent level without success and hope someone may have some ideas.
I looked at using Get.Cell (http://www.mrexcel.com/forum/showthread.php?t=20611) but indent level doesn't seem to be an option. I tried using 53 to get contents as displayed including formatting but it doesn't include any leading spaces/tabs.
Can anyone help?
Thanks
Andrew
Hanging Indents In Excel
Using the Increase Indent Button Enter your text into the document. Select the cell (s) whose entries you want to indent. (Make sure the cursor is not blinking within the selection.) Under the 'Home' tab, in the 'Alignment' group, click the 'Increase Indent' icon (right-facing arrow pointing. Excel:set indent level based on value of a cell. Excel:set indent level based on value of a cell. Stick1 (Mechanical) (OP) 5 Sep 08 13:23. I am able to extract an indented BOM from our PLM software for placement into Excel 2003. The tab-delimited BOM file has the indents shown via a column of values. I would like to indent certain columns in Excel based on the value in the indent level column that has been imported.