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.

 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 no

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site