Excel Q (Indent Related)

Say you’re formatting in excel and have multiple idented cell, for example, a heading with an indent of 1 and line items with an indent of 2. Is there a quick, one step, way to change the indents to 2 and 3, respectively, or do you need to do each of them individually?

How many cells? Are you good at VBA? cell.IndentLevel = 2 cell.IndentLevel = 3 Is what you want to use.

If they are in one column mark them all and press the Indent button once. If they are spread all over the sheet then VBA is probably the only way.

Treynor, thanks. I could see how you’d use VBA but I think it would be too hard to write a macro that would cover every situation. ctrl-alt-tab is what I was looking for…