Hi,
I use the Win Alt-Ent to move text to a new line within one cell. I recently learned you can do that with formulas too, to make them easier to read and it won't break the formula. I've done that, but I'm wondering if, within the cell, there is a way to Tab a certain number of spaces, or manually enter spaces?
In other words, in VBA, you can write a nested code breaking out a formula into individual line and you can tab or space each line. The end result might look like a book outline, for lack of a better way to explain it.
I'm not sure of the proper way to show formulas like this, so I'd welcome any advice. I haven't found the correct search terms yet, I guess.
When I edit a cell, I'd like to see a formula this way:
=if(2+2=4,
1,
0)
Keeping in mind, this might not be exactly the "proper" way to break out a formula.
I use the Win Alt-Ent to move text to a new line within one cell. I recently learned you can do that with formulas too, to make them easier to read and it won't break the formula. I've done that, but I'm wondering if, within the cell, there is a way to Tab a certain number of spaces, or manually enter spaces?
In other words, in VBA, you can write a nested code breaking out a formula into individual line and you can tab or space each line. The end result might look like a book outline, for lack of a better way to explain it.
I'm not sure of the proper way to show formulas like this, so I'd welcome any advice. I haven't found the correct search terms yet, I guess.
When I edit a cell, I'd like to see a formula this way:
=if(2+2=4,
1,
0)
Keeping in mind, this might not be exactly the "proper" way to break out a formula.
I wish I would've known this many years ago versus copying long formulas, and manually entering them as text in separate cells to try to understand what they were doing. . . besides other ways like helper columns, table formats, pivots, etc.
