Until now, all visible rows are deleted from the filtered list. Now all visible rows are selected, right click the selection, and then click Delete Rows. Excel converts the SUBTOTAL functions to values.Īdditional Details: Instead of selecting Go To Special, Visible Cells Only, you can press Alt+ (that is, hold down the Alt key and type a semicolon). How do I delete visible filtered cells In the Go To Special dialog box, check the Visible cells only option, and then click the OK button. Excel Formula: UNIQUE(FILTER(Table5Data,Building,Table5Helper1,'')) Think that is right, but without setting up a table to test the syntax, there could be any. Excel Formula: SUBTOTAL(2,Data) Then change the unique formula to. You might think that you would have to select Paste, Values instead of just doing a paste. I would say use a helper column with a subtotal formula for the row, for example.
![excel 2016 select visible cells only excel 2016 select visible cells only](https://cdn.ablebits.com/_img-blog/subtotal/go-to-special.png)
![excel 2016 select visible cells only excel 2016 select visible cells only](https://basicexceltutorial.com/wp-content/uploads/2020/09/092320_1749_Howtofreeze3.png)
When I copy and paste, I get all of the detail rows as well. My manager wants me to send him just the total rows in a file. Problem: I've added subtotals and collapsed to the #2 view.