How do you enter a long formula?
I have quite a long formula, I wrote it in Word... When I copy and paste, the cells used in the formula are not highlighted, so I think the program doesn't recognize them. Therefore, I am copying my formula by hand.
However, when I am at about the second or third line and I click on a cell to use it in the formula, the formula entry box keeps disappearing. Cells used in the formula are still highlighted in the sheet, but I cannot do anything anymore but refresh the sheet. Then, my changes to the formula are gone.
One I still saw the formula entry box, but it was half out of the screen and I couldn't see what I was writing...
Does anyone have any tips on how to deal with long formulas?
Help Article Resources
Check out the Formula Handbook template!