When you move or copy a cell in Excel, the content of the moved or copied cell overwrites any data in the destination cell. Likewise, any formatting applied to the cell (including
conditional formatting A conditional format changes the appearance of a cell range based on a condition (or criteria), making it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using cell formatting, data bars, color scales, and icon sets.
data validationAn Excel
feature that you can use to define restrictions on what data can or should be entered in a cell, and to create messages that prompt users for correct entries and notify users about incorrect entries.), overwrites any formatting that existed in the destination cell.
If the cell contains a formula, the
cell referencesThe set of coordinates that a cell occupies on a sheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.
are not adjusted. Therefore, the contents of the moved or copied cell and of any cells that point to them might display the #REF! error value. If that happens, you will have to adjust the references manually. For more information, see
Find errors in formulas and cells