How to Format Relative References in Excel. Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a ...

How to Format Debits and Credits in Excel. When you use Microsoft Excel to analyze your company's data, you want to spot trends, successes and problems at a glance. Before you dive into an in ...

Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.