Forum Discussion
formula overflowing cell
Hi chuckj
Is the cell you're typing into fomatted as Right aligned? that tends to force the formula to expand to the left. Try formatting the cell as left aligned or going to format cell - Alignment Horizontal - General.
If you do want the formula to spill down you could format the cell with Wrap text and then turn this off after editing the formula.
Another way to avoid the issue is to edit the formula using the formula bar
Hi chuckj
Is the cell you're typing into fomatted as Right aligned? that tends to force the formula to expand to the left. Try formatting the cell as left aligned or going to format cell - Alignment Horizontal - General.
If you do want the formula to spill down you could format the cell with Wrap text and then turn this off after editing the formula.
Another way to avoid the issue is to edit the formula using the formula bar
Thanks Wyn! You solved it. It wasn't actually set to Right Align. It was actually set to Center. I didn't notice that it was overflowing to the right also because I didn't need to reference anything to the right. I turned off Center from the Home tab and it works fine now.
