Delete Hidden Rows?

As far as I know, feature unavailable.

I wished to write a script to fit the gap but the status visible/hidden is not reachable thru AppleScript so, I can't do that 😟

Yvan KOENIG (from FRANCE mardi 7 juillet 2009 12:33:45)

While I don't have a way to delete them all in one fell swoop, you can make it easier to identify them by adding a new column and making the cells in that column checkboxes prior to unhiding the rows. The hidden rows won't get checkboxes so they'll stand out when you unhide them, making the deletion process easier and less error prone.

If this is a big job with a lot of non-contiguous rows to delete, you could go a step further by using the reorganize panel to show only rows that have a blank in that column then select those rows and sort on the column (selected rows only, not entire table) to group them all together. Un-filter the table and you can then delete the "hidden" rows in one deletion.

Message was edited by: Badunit

Badunit's suggestion can be enhanced by the fact that drag-fill skips hidden rows if done in the same table.

Hide the rows (if the top row is hidden, then add an empty non-header row above it).
In the same table, add an empty column, say column C.
In column C, in the top non-header cell, enter text such as "not hidden".
Select the cell and on the bottom-right corner of the selection box is a circle, drag it down.

This copies the text to all the visible rows in the table. Now unhide the all rows, sort by column C, and delete the block of rows that have blank cells in column C.

Hmm. I just realized something that probably makes this easy: Mark for Move, only moves the visible data.

Insert a blank table.
Select all the cells in the table with the hidden rows.
Press Command-Shift-x to mark the data for move.
Select a cell in blank table.
Press Command-Shift-v to finish the move.

Now the new table only contains the rows that were visible. If you unhide the rows in the old table, you can see the rows are still there.

My preferred workaround is to use an extraneous column containing checkboxes.

I would no longer hide rows but check the boxes in rows to delete.
calling a dedicated script would delete rows according to the status of the checkBox.

Yvan KOENIG (from FRANCE mercredi 8 juillet 2009 10:08:27)

Very cool. And it appears to translate cell references correctly, something a simple copy/paste from table to table does incorrectly when there are hidden rows.