it's insane how fast one can destroy the data in an excel file simply by misunderstanding copy/paste or drag/drop functions, e.g. while you (probably, at least

it's insane how fast one can destroy the data in an excel file simply by misunderstanding copy/paste or drag/drop functions, e.g. while you (probably, at least how my excel is configured) can filter your table and then drag the value of one cell down to other cells and the ones that are filtered out are not affected. However, when you think that doing the same for changing the format of the cells (e.g. the background color), you've thought wrong - even the cells that are filtered out are affected.