How to delete hidden rows?

Fotomill,

I believe WWJD is correct, you will need a second table with a sublist of the first. The ttecnigue for creating a sublist has been posted several times and can be seen in the thread:

http://discussions.apple.com/thread.jspa?messageID=7179459&#7179459

In your case the formula in the added (and ever popular) hidden column would be based on the criteria that you used to filter your rows. But now that I think about it, your case is easier. Instead of a formula in your hidden column, enter the sequence of integers 1 ... n down the column AFTER you've done your filter. Then complete the formulas for the second table.

And of course, write back if you run into problems -- this is not an easy task if you're just learning Numbers. Welcome and good luck.

pw

I am not at my mac so I cannot try this...

In another spreadsheet program it depends on HOW you select the data. If you select the cells by dragging inside the table (i.e. from a1 to d75), it selects all the data including the hidden rows... But if you select by dragging down the row headers ( the little buttons on the left hand edge) then it copies only the visible rows. (because you cannot 'select' the hidden rows unless you unhid them I suupose).

Try it both ways and let me know if it worked or not. I don't know if i can wait to get home to find out. (that won't be for another 5 1/2 hours)

Jason

I believe this is not possible without special programming in another table. You might try searching for "Hidden Rows", etc., and see responses from others.

Regards,

Hello Jason

Bad news.

With Numbers both ways select all the rows.

Yvan KOENIG (from FRANCE mercredi 14 mai 2008 19:19:28)

JaxJason,

Sorry, this approach does not seem to work with numbers. As often as this problem comes up, it would be surprising that such a simple solution were not known by now.

pw

I think you'd be very surprised how many "simple things" are over looked just because they truly are that simple. It's always worth a try though.

Jason

Jason,

True enough! Never overlook the obvious.

pw