How To Indent Within An Excel Cell
With MS Excel, cell alignment is how your text or numbers are positioned in the cell. You can align vertically, meaning towards the top, the middle or the bottom. You can align vertically, meaning. 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. Type the text that you want to indent and press 'Esc' to finish editing the cell. Step 5 Click the 'Increase Indent' button in the Alignment group on the home page to indent the text; the bullet is.
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
Excel Indent Function
How To Indent Within An Excel Cell Excel
February 17th 06, 06:03 PMposted to microsoft.public.excel.misc |
Insert a column to the right of the cells displaying indents, in the first cell of the newly inserted column enter the formula =Trim(CellAddress), where cell address is the cell directly to the left of the current cell. Copy the formula down the column as far as necessary. Copy the formula in the inserted column, move to the top of the column to its left and do a Paste/Special and select Values. When finished delete the column with the trim formula in it. -- Kevin Backmann 'DB--less than excel expert' wrote: How can I remove an indent within a cell? For example, I have a column of data that has several different indents some with no indent. How do I remove all of the indents? When I look at the formula for cells with indents, I see =' XYZ5 My data appears in the column as follows XYZ5 XYZ4 XYZ3 XYZ2 I would like all of the data to be left justified w/o having to manually go in and delete the ' from the cells. Many thanks, DB |