Can't select a cell while creating a cross sheet formula
When trying to create a cross sheet formula, I start typing the formula in a cell (say its C5) and when I navigate to another sheet to select that same cell reference of C5 in the other sheet, the cell I am trying to reference is covered by the formula string being typed and cannot be selected. It is "under" the formula string from the first sheet being shown on the screen. This is super frustrating. Typing the formula directly in the formula bar doesn't help. The cell I need to reference on the other sheet is covered by the formula string no matter what I do.
Am I missing something? How do I get the formula string to stop showing up in the cell I am trying select?
Rebecca
-
Hi Rebecca!
I want to make sure I follow. I think I have seen the same, but to confirm, what you are seeing is when you begin typing the formula and the formula wizard appears and then covers up the area of the toolbar you need to select the cell reference you need for the formula, is that right?
Let me know if I've missed the mark at all, or if you have questions on that. In the meantime, I'll bring this up to our Spreadsheets team to let them know. Thanks as always and chat soon.
0
Comments
2 comments