I can't be the only person that is VERY bothered by having the formula editing bar in the SAME row as the row you're applying it to? It drives me nuts when I try to type in a formula and the editing window COMPLETELY COVERS the entire row, so I cannot see the columns/cells that the formula is referencing, nor can I click on the cells I want to reference.
I have 4 Solutions. All 4 would solve a lot of frustration :)
1. OFFSET the editing bar up slightly. Move the formula editing bar up just slightly. Make it only cover 80% of the current row and 20% of the row above it, instead of completely covering the current row. This would let us see if the cells behind it are highlighted and to click on the cells if we wish to add them to the formula. The percentages might need to be adjusted but the idea is the same (eg. 75/25%). Since MOST of the data would still remain on the same row, we would not be confused with which row we are editing.
2. Wrap the text in the formula editing window if it takes up at least 25% of the current window. This seems like it would be the simplest to implement.
3. If no text is typed for a few seconds, make the current formula window slightly transparent so that you can see if the cells behind it have colors. This option is not as good because you can't click on the cells behind the formula bar this way, but at least you can see them.
4. Allow us to press ALT+ENTER to move the text behind the cursor to the next row, without breaking the formula. This is currently possible if you a) Delete the = sign in the formula, b) navigate to the place you want a line break c) ALT+Enter d) Add = to the beginning of the formula.
Thank you!
