Break-down long formulas --- advice needed

[PP3321]

When I have long formulas, I do following 3 steps:

1. Ctr + `
2. Alt + Enter
3. Make Formula Bar bigger

*************************************************

Problem with this solution is that the cell can not show 3 lines of formula.

Is there better way to break down formula?
How about using VBA...

If you have any advice, please let me know...

 

[Luke M]

I'm not quite sure what you're asking. In your image, you can easily see the whole formula in the Formula bar. This is the preferred place to edit, and you can easily scroll up/down as needed, and there's no character display limit (cells can only display so much per XL specifications).

Instead of using the formula view and editing in cell, I would suggest select the cell, and edit the formula in the Formula bar.

 

[NARAYANK991]

Hi ,

Why not go in for a professional tool such as this ?

http://chandoo.org/forum/threads/introducing-formuladesk-new-add-in.21753/

Narayan

 

[PP3321]

Hey Luke,
I hate working with big Formula Bar on top.
I want to be able to edit formula within the Cell.
Can we do Alt + Enter formula within the cell, so that formula breaks down within the cell?

Narayan
Thanks! I will have a look!

 

[Luke M]

I don't think so. Within the cell, XL just displays the formula how it sees things, which is w/o line breaks. The formula bar is meant to display things how humans will see it.

 

[PP3321]

Ok thanks...
I noted your advice.
I will keep researching...
I just cannnot give up this idea that we can achieve it by VBA macro...I do not know...