How to unhide selected columns in numbers..not all the columns just the one or two next to the shown columns. I dont want to open them all.

How to unhide selected columns in numbers..not all the columns just the one or two next to the shown columns. I dont want to open them all.

Posted on Nov 10, 2022 03:15 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 11, 2022 07:07 AM

The crux of the problem is there is no way to "select" the columns to unhide so it is not possible to unhide the "selected" columns.


Yellowbox's suggestion is to transpose the table so the columns become rows. You can use filters (and maybe a formula if necessary) to selectively hide/unhide rows. One way to hide/unhide selected rows would be to insert a new column that contains the row numbers then you can use a quick filter to turn on/off rows. There are other ways as well, all relying on filters.


3 replies
Question marked as Top-ranking reply

Nov 11, 2022 07:07 AM in response to bostonhome1

The crux of the problem is there is no way to "select" the columns to unhide so it is not possible to unhide the "selected" columns.


Yellowbox's suggestion is to transpose the table so the columns become rows. You can use filters (and maybe a formula if necessary) to selectively hide/unhide rows. One way to hide/unhide selected rows would be to insert a new column that contains the row numbers then you can use a quick filter to turn on/off rows. There are other ways as well, all relying on filters.


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to unhide selected columns in numbers..not all the columns just the one or two next to the shown columns. I dont want to open them all.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.