Unhide rows in Numbers

Question

Unhide rows in Numbers

I have tried all the suggestions to unhide rows.

I had copied a different table to another sheet and paste/specialed that table. When I returned back to the sheet I had copied the table from (the different table that the rows are now hidden), the rows in that other table (that the other table was linked to) we hidden.

-I show row 1 and row 110. There is a thicker 'line' between each row, indicating there are hidden rows (rows 2-109).

OS MONTEREY 12.1

NUMBERS version 11.2 (7032.0.145)

Any ideas?

Thanks

MacBook Pro 13″, macOS 10.15

Posted on Feb 1, 2022 7:25 PM

Reply

Answer 1

Best reply

Badunit

Level 7

26,788 points

Feb 1, 2022 8:05 PM in response to TominCarlsbad

If you are unable to unhide rows, it is likely the table has a filter on it and the filter is the thing hiding the rows. Select the table, click on the "organize" icon in the toolbar to bring up the Organize/Filter sidebar. Go to the Filter tab. Turn off or delete the filter.

Reply

Answer 2

Feb 2, 2022 4:03 AM in response to Badunit

Thanks bad unit… I saw a thread that talked about transposing and then untranposing the table and that seemed to work, but now my formulas in the aligned table do not pick up all of the cells… so I’ll have to figure that out

thsnks for your input!

Reply

Unhide rows in Numbers

Similar questions