When you insert new rows or columns excel does not adjust ce
When you insert new rows or columns excel does not adjust cell references to the new locations? True or False
When you insert new rows or columns excel does not adjust cell references to the new locations? True or False
Solution
Ans: False
When you insert cells on a worksheet, all references that are affected by the insertion adjust accordingly, whether they are relative or absolute cell references. The same behavior applies to deleting cells, except when a deleted cell is directly referenced by a formula. If you want references to adjust automatically, it\'s a good idea to use range references whenever appropriate in your formulas, instead of specifying individual cells.
