Hi all
I have one question.
As you can see in the picture I have this formula. When I press inside the "E13" cell the formula shows up in the formula window.
When I click inside the formula window all the cells that uses the formula gets this colour around it to show me that the cell is beeing used in the formula.
BUT, I have a few sheets as you can see. 1,6 1,7 1,8 and so on.. The Formula is also using some of theese sheets and I want to press the "1,6" after I`ve cklicked inside the formula window and then the cells in sheet 1,6 should light up as they do in the kVA sheet but it does not. I`m just switching over to the 1,6 sheet when I press it....
So is it a key I could press when entering the 1,6 sheet so it knows that I would like to see the cells I`m using in the formula on the 1,6 sheet or something?
Thanks
Bookmarks