Clear Filter

Empty cells in place. Nothing below shifts up, so formulas pointing at those rows still point at them

Copy cells somewhere else, with or without their formatting. Works even when the destination overlaps the source

Hide the rows that do not match, and collect the ones that do

Replace text across a range. Formula cells are left alone, so a replacement cannot quietly break a calculation

Delete repeated rows, keeping the first or the last of each. A number typed as text matches the same number

Sort rows by one column, then optionally a second. Whole rows move and carry their formatting, and blanks sink