Formatting of cells to allow spill over to next cell containing a formula

[Helix242]

Hi all,

I hope someone can help or point me in the wright direction. I have a book which I'm building and one of the sheets contains the out comes of the user input, so the formulas on this page are =IF(AND(....=IF(OR... etc and there are a lot of them!

So I thought I could place quite a few in column B then make the cell narrower. When the formula is triggered, the correct response fills over the cell and in to the others (which is what I want).

I then put my next arguments in to column C, but now when text is triggered from the arguments in column B, this stops within the cell and will not spill over - due to the formula in column C.

1 I hope this makes sense! And 3 I hope someone can help. I have fairly okay knowledge with Excel, but not great.

Thank you in advance!

 

[Helix242]

Hi all,

I hope someone can help or point me in the wright direction. I have a book which I'm building and one of the sheets contains the out comes of the user input, so the formulas on this page are =IF(AND(....=IF(OR... etc and there are a lot of them!

So I thought I could place quite a few in column B then make the cell narrower. When the formula is triggered, the correct response fills over the cell and in to the others (which is what I want).

I then put my next arguments in to column C, but now when text is triggered from the arguments in column B, this stops within the cell and will not spill over - due to the formula in column C.

1 I hope this makes sense! And 3 I hope someone can help. I have fairly okay knowledge with Excel, but not great.

Thank you in advance!

I have just realised that I can write multiple IF(AND and arguments in the same line, and since none of these will ever used to produce the same text at the same time this looks like a way forward.

 

[Alice Morland]

Hi Helix,
Have you tried formatting the cells in column B as 'wrap text'? It worked for me.
Alice.

 

[Helix242]

Hi Helix,
Have you tried formatting the cells in column B as 'wrap text'? It worked for me.
Alice.

Thanks for the advice Alice, I have stuck with placing multiple IF(AND arguments in the one cell as none of them cross over. Thanks

 

[Alice Morland]

That's the beauty of Excel - the ability to do the same thing in several ways. Happy to hear your solution works