Indent Levels in Excel list of cells (with no VBA)

Indent Levels in Excel list of cells (with no VBA)

HomeOther ContentIndent Levels in Excel list of cells (with no VBA)
ChannelPublish DateThumbnail & View CountActions
Channel Avatar AuditExcel Advanced Excel and Financial Model Training and Consulting2022-07-19 12:59:48 Thumbnail
8,155 Views
An alternate to an Excel indent level formula which will enable to match all the cells with the same level and list the levels next to the cells. Useful when using software that exports data to Excel and using indents to show the level and grouping of accounts.

——————————————————————————————————————————————————

– Free check of your Excel Skill Level- https://excel-skills-assessment.com/skills-assessment/
– Test employee Excel skill levels- https://excel-skills-assessment.com/excel-skills-test-for-employment/
– Improve you Excel Skill Levels- https://online-excel-training.auditexcel.co.za/course-category/skill-based-beg-int-adv/
– Our main website- https://www.auditexcel.co.za/blogs/

——————————————————————————————————————————————————
Time Stamps
00:00 Extract the indent level in Excel cells
00:17 Are indents spaces or actual indents?
00:44 Get the indent level on a single cell
01:28 Indent level on all cells without using VBA
01:55 Using FIND to identify cells with the same indentation level
02:08 FIND the format within a cell with indentation of 2 levels
02:41 List all the cells with level 2 indentation
02:49 Color all the cells with the same indentation level the same color
03:12 Do another find on ALL cells for next indent level
03:45 Color all level 6 indents with a different color
04:15 WARNING- Correct the FIND tool before you proceed
05:20 Put the indent level number in a cell based on matching colors
06:17 VBA can be used

Please take the opportunity to connect and share this video with your friends and family if you find it useful.