Move the contents of the hidden cells into the first cell: The actual contents of the hidden cells are concatenated to the first cell, and hidden cells are emptied; the results of formulas referring to the hidden cells or the first cell will be updated.
Keep the contents of the hidden cells: The contents of the hidden cells are kept; the results of formulas referring to the hidden cells will not change.
Empty the contents of the hidden cells: The contents of the hidden cells are removed; the results of formulas referring to the hidden cells will be updated.
Merging cells can lead to calculation errors in formulas in the table.