If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Zeros when copying formular | Keith Camacho | New Users | 1 | April 9th, 2005 03:02 AM |
formula in cell not showing result | Leolin | Worksheet Functions | 8 | March 18th, 2005 05:36 PM |
starting word with last document showing | Terry Liittschwager | New Users | 5 | February 1st, 2005 03:56 AM |
Final Showing Markup / Revisions Issue...Word 2003 | Scott McDonald | General Discussion | 2 | August 3rd, 2004 03:43 PM |
Need Formular for Multiple Critera condition | Don Guillett | Worksheet Functions | 3 | November 25th, 2003 08:40 PM |