How can this be done? Thanks.
2006-06-21 06:01:09 · 4 answers · asked by timcfa 2 in Computers & Internet ➔ Software
That should work by default; the only exception I've ever had is when there are more than 32 references within an individual formula. And even then, color-coded cell references will work for the other formulas in the sheet.
I've never seen the limit written anywhere, just found it by trial and error.
2006-06-21 06:20:02 · answer #1 · answered by O Caçador 6 · 0⤊ 1⤋
Just highlight the cell that contains the formula, and put your cursor in the formala bar at the end of the formula. This will outline the cells in color that are referenced in the formula
2006-06-21 06:16:07 · answer #2 · answered by sonik_starz 4 · 0⤊ 0⤋
Select the cell with formula and press F2
XLMan
2006-06-23 23:39:22 · answer #3 · answered by Anonymous · 0⤊ 0⤋
The formulation in one cellular is a static formulation (which ability it would not replace) So, permit's say that formulation is in A1. on your different cells, you could reference that cellular for the result. So: A1: =5+5 (or notwithstanding your formulation is) in the different cellular, make it reference A1, so in case you have values in B1, C1 and D1, say in A2 you could enter =sum(B1:D1)*A1. Which first provides the values in B1, C1 and D1, then multiplies that sum by the fee in A1 (in this occasion, 10). There are, of course, many techniques of doing the cellular references, and it is an exceedingly trouble-free occasion. desire this permits, yet permit me comprehend in case you have a particular difficulty you go with for to maintain on with this to.
2016-12-08 11:10:53 · answer #4 · answered by dematos 3 · 0⤊ 0⤋