4 ms·
But that's a problem in itself that's always bothered me: dragging works slightly different than copy/paste works different than cut/paste. And the different us
by beerandt 5y ago
But that's a problem in itself that's always bothered me: dragging works slightly different than copy/paste works different than cut/paste. And the different uses are useful on their own, but the inconsistency makes understanding how to manipulate formulas in simple ways overly confusing, especially when first learning the behavior.
The ability copy-and-paste-absolute and to cut-and-paste-relative should be right there next to cut copy and paste when you right click, and should have been there decades ago.
- Tarsul 5y agoit'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.