Excel Tips
Color all Precedents or Dependents »
June 8, 2022
The auditing arrows are confusing. Can I simply color the precedent or dependent cells?
Which Cells Flow into This Cell? »
June 7, 2022
I have a large formula, and I would like to visually see how the cell is calculated.
Calculate a Formula in Slow Motion »
June 6, 2022
I am trying to trace how a formula is calculating. What should I do?
Before Deleting a Cell, Find out if Other Cells Rely on It »
June 3, 2022
I am about to delete a section of a worksheet that I believe is no longer being used. However, I know that if I delete the cell, and some other far-off range relies on the cell, the far-off range will change to the dreaded #REF! error. How can I determine if any other range refers to this cell?
Charts , VLOOKUP & Pivots Expand With The Table »
June 2, 2022
I always have to add new data to the bottom of my data. Then, I have to redefine the charts, pivot tables, and lookup tables that are based on this data.
June 1, 2022
Is a formula such as =SUM(Table1[Revenue]) supposed to be meaningful?
May 31, 2022
Once I define something as a table, the formulas are strange.
Tables Are Like a Database in Excel »
May 30, 2022
Excel isn’t like Access. I am an Access person and Excel annoys me.
Whatever Happened to the @@ Function? »
May 27, 2022
Back in Lotus 1-2-3, there was an @@ function. If you used @@(A3), Lotus would go to A3. A3 was supposed to contain a valid cell reference. Say that A3 contained the text C5. The @@ function would then return the value from cell C5.