Home |
Search |
Today's Posts |
#1
|
|||
|
|||
No showing of cellnumbers used in formular with colour
Hi experts!
I have a problem with creating a formular in one worksheet and letting numbers from cells in another worksheet be used in the formular. Normally I just point at the cells I want to use and afterwards I can check by doubleclicking on the cell with the formular and then se with colour markings which cells I used. This does somehow only work within one worksheet and not between different worksheets. What is wrong? /Maria |
#2
|
|||
|
|||
Nothing is wrong, how would you expect it would look if it worked? What you
can do is to use toolsformula auditing and select for instance trace precedents, then you would see an icon for another sheet and if you double click the arow from that icon a goto box would open with the cell address(s) Regards, Peo Sjoblom "/Maria" wrote: Hi experts! I have a problem with creating a formular in one worksheet and letting numbers from cells in another worksheet be used in the formular. Normally I just point at the cells I want to use and afterwards I can check by doubleclicking on the cell with the formular and then se with colour markings which cells I used. This does somehow only work within one worksheet and not between different worksheets. What is wrong? /Maria |
#3
|
|||
|
|||
Hallo Peo
Thank you for answering I know the function that you are mentioning but it is not enough answer for me. It is the more simple function that has gone. Normally yoc double click the cell with a formular e.g. =A1+A2 When you do this the to cells (A1 and A2) will be marked with a coloured frame around the cell so that is is easiy to see which cells are used in the equation. This does normally work within worksheets but it does not work now in my new files. /Maria "Peo Sjoblom" skrev: Nothing is wrong, how would you expect it would look if it worked? What you can do is to use toolsformula auditing and select for instance trace precedents, then you would see an icon for another sheet and if you double click the arow from that icon a goto box would open with the cell address(s) Regards, Peo Sjoblom "/Maria" wrote: Hi experts! I have a problem with creating a formular in one worksheet and letting numbers from cells in another worksheet be used in the formular. Normally I just point at the cells I want to use and afterwards I can check by doubleclicking on the cell with the formular and then se with colour markings which cells I used. This does somehow only work within one worksheet and not between different worksheets. What is wrong? /Maria |
#4
|
|||
|
|||
I apologize, I misunderstood. So you are saying that even if the cell
references are on the same sheet nothing happens? What happens if you press F2 when selecting the cell with the formula? Go to toolsoptionsedit and make sure edit directly in cell is checked Regards, Peo Sjoblom "Maria" wrote: Hallo Peo Thank you for answering I know the function that you are mentioning but it is not enough answer for me. It is the more simple function that has gone. Normally yoc double click the cell with a formular e.g. =A1+A2 When you do this the to cells (A1 and A2) will be marked with a coloured frame around the cell so that is is easiy to see which cells are used in the equation. This does normally work within worksheets but it does not work now in my new files. /Maria "Peo Sjoblom" skrev: Nothing is wrong, how would you expect it would look if it worked? What you can do is to use toolsformula auditing and select for instance trace precedents, then you would see an icon for another sheet and if you double click the arow from that icon a goto box would open with the cell address(s) Regards, Peo Sjoblom "/Maria" wrote: Hi experts! I have a problem with creating a formular in one worksheet and letting numbers from cells in another worksheet be used in the formular. Normally I just point at the cells I want to use and afterwards I can check by doubleclicking on the cell with the formular and then se with colour markings which cells I used. This does somehow only work within one worksheet and not between different worksheets. What is wrong? /Maria |
#5
|
|||
|
|||
Hello Peo
I gues I was working yoo late at night. All my cell references were on another sheet and thats why the colours did not work. I figured out how to use the same set up in different files so that my data handling can be done with just copying into a standard file. Thanks again /Maria "Peo Sjoblom" skrev: I apologize, I misunderstood. So you are saying that even if the cell references are on the same sheet nothing happens? What happens if you press F2 when selecting the cell with the formula? Go to toolsoptionsedit and make sure edit directly in cell is checked Regards, Peo Sjoblom "Maria" wrote: Hallo Peo Thank you for answering I know the function that you are mentioning but it is not enough answer for me. It is the more simple function that has gone. Normally yoc double click the cell with a formular e.g. =A1+A2 When you do this the to cells (A1 and A2) will be marked with a coloured frame around the cell so that is is easiy to see which cells are used in the equation. This does normally work within worksheets but it does not work now in my new files. /Maria "Peo Sjoblom" skrev: Nothing is wrong, how would you expect it would look if it worked? What you can do is to use toolsformula auditing and select for instance trace precedents, then you would see an icon for another sheet and if you double click the arow from that icon a goto box would open with the cell address(s) Regards, Peo Sjoblom "/Maria" wrote: Hi experts! I have a problem with creating a formular in one worksheet and letting numbers from cells in another worksheet be used in the formular. Normally I just point at the cells I want to use and afterwards I can check by doubleclicking on the cell with the formular and then se with colour markings which cells I used. This does somehow only work within one worksheet and not between different worksheets. What is wrong? /Maria |
#6
|
|||
|
|||
The dangers of working in Excel late of night, not advised But we allll do it. -- Hopest ------------------------------------------------------------------------ Hopest's Profile: http://www.excelforum.com/member.php...o&userid=23765 View this thread: http://www.excelforum.com/showthread...hreadid=375841 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array formular | Excel Worksheet Functions | |||
Showing Duplicate Rows | Excel Discussion (Misc queries) | |||
formula in cell not showing result | Excel Worksheet Functions | |||
How to protect the formular | Excel Discussion (Misc queries) | |||
Bar showing value for missing data | Charts and Charting in Excel |