On the left of the 'Set' button, you click the left and right arrow buttons to move the cursor through the cell's precedents. If you prefer, there is a drop-down box that you can use to select any of the cell's precedents. There is even a button at the far left which selects all the cell's precendents at once. Further right, you can click the left and right arrow buttons to move the cursor through the cell's dependents. If you prefer, there is a drop-down box that you can use to select any of the cell's precedents.
Confidentiality is assured.
Boss, don't use this for Excel 97 or earlier versions. You need Excel 2000. Also, it only shows precedents and dependents on the current sheet. Actually, I said, I have Excel 2000. Copyright 2000 John F. Raffensperger .