Understanding Excel References When you are using Microsoft Excel, it's common to have a formula in one cell reference another cell in order to use that cell's data in a computation.

If you want to create a new line in an Excel cell, you can do that with a specialized formula, or by using other methods from this guide.

If your Excel formula omits adjacent cells, the error may be because you've set your sheet to absolute reference and need to switch it up.