Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.

Excel cannot automatically calculate a formula that refers to the cell—either directly or indirectly—that contains the formula. This is called a circular reference.

Press F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the …

Change a cell reference from relative (default) to absolute to maintain the original cell reference when you copy it. Maintain cell reference by putting a dollar sign ($) before the cell and column …

Copy all the cells in this table and paste it into cell A1 on a blank worksheet in Excel. Tip: Before you paste the data into Excel, set the column widths for columns A through D to 250 pixels, …

Sometimes, you might see a green triangle in the upper-left corner of a cell that contains a formula. Find out what this means and how to prevent this in Excel 2016 for Windows.

When your formulas have errors that you anticipate and don't need to correct, but you want to improve the display of your results. There are several ways to hide error values and error …

Instead of entering values, you can refer to data in worksheet cells by including cell references in formulas.

A circular reference occurs when a formula refers to the cell that it's located in. The fix is to either move the formula to another cell, or change the formula syntax to one that avoids circular …

To use the arrow keys to move between cells, you must turn SCROLL LOCK off. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard. If your keyboard doesn't include this …