![Excel shortcut indent in cell Excel shortcut indent in cell](/uploads/1/2/7/7/127760650/851177984.gif)
Indent In Excel Formula
![How to indent in excel sheet How to indent in excel sheet](/uploads/1/2/7/7/127760650/342683228.jpg)
Excel Shortcut Indent In Cell
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
How To Indent In Excel
Adhere to our easy steps to get your Material Indent Format In Excel well prepared rapidly: Choose the template from the catalogue. Enter all required information in the required fillable areas. Follow these steps to indent data in cells: Select the cells containing text you want to indent. Click the Increase Indent button in the Alignment group on the Home tab. Each time you click the Increase Indent button. Hanging Indent IN Excel is not an option.