The hostility is not aesthetic. A merged cell breaks a set of operations that everything downstream depends on. What it actually breaks Sorting. A range containing merged cells either refuses to sort or scrambles,…
Asked around for the thing people discovered embarrassingly late. Sorted by how much it actually saves, not how clever it is. Select to the end of a block instead of dragging. Ctrl with an arrow jumps to the edge of the…
A file that grows without the data growing is nearly always one of a short list of causes. In rough order of how often it is the answer. The used range is enormous. Something once touched row 900,000 and the file has…
I get a CSV from someone else's system on the first of every month. The date column comes in as something like 03/07/2026. What happens on import is the worst possible outcome: some rows become real dates, some stay as…
Column of dates from an exported report. In the pivot, right click, Group is greyed out for the date field, and the rows show every single day as its own line. If I type a date manually into a blank cell it looks…
Roughly 8,000 rows, 15 columns, mostly SUMIFS with a few INDEX MATCH and some conditional formatting. Every time I type in a cell the whole thing freezes for about 20 seconds. The file is only 4 MB. Is this normal at…
Bank export, about 12,000 rows. Amounts came in as text with thousands separators, and SUM ignores the column entirely. Multiplying by 1 gives VALUE errors on some rows. There is also something odd where negatives…
Inherited a workbook with one sheet per month going back three and a half years, identical layout, about 800 rows each. I need totals by category by month and eventually a chart. Do I keep the structure and write SUMIFS…
Lookup value is an order number like 100234, sitting in column A on both sheets. returns N/A for about a third of the rows and works perfectly for the rest. If I copy the value from one sheet and paste it into the…