View non-adjacent columns side-by-side in Numbers

In Excel, you can view two columns side by side without seeing the columns in between.


IOW if I want to look at Column A and Column Z side by side, so that I don't see Columns B-Y, I can maneuver an icon that does this. I don't want to add a third column and put formulas into it.


What is the best way to accomplish this in Numbers?


Note: I have only one tab. The web suggests I select that tab and then use the window menu to "Move Tab to new window". This should provide me two windows of the same data that I can then put side by side.


I click on the tab but nothing is selected and the "move tab" option is never highlighted.

MacBook Air, macOS 26.6

Posted on Sep 9, 2026 8:18 AM

Reply
Question marked as Top-ranking reply

Posted on Sep 9, 2026 8:06 PM

Hi John,


Select the columns you want to hide.

Menu > Table > Hide 24 (or whatever) columns.

Having hidden them, Un-hide All Columns becomes active so you can show them once more.



Regards,

Ian.

5 replies

Sep 9, 2026 10:12 AM in response to John Zwiebel

> In Excel, you can view two columns side by side without seeing the columns in between.


I don't use Excel as frequently as Numbers, but I'm not sure how you'd achieve this in Excel... can you describe how you'd do this, so that maybe an equivalent method exists in Numbers?


> IOW if I want to look at Column A and Column Z side by side, so that I don't see Columns B-Y, I can maneuver an icon that does this. I don't want to add a third column and put formulas into it.


If you're referring to those columns specifically, then just mark the table as having one header column - that will, by definition, be column A. Then as you scroll horizontally, rows B and above will slip 'under' column A so that column A is always visible.



You can mark up to 5 header columns to remain visible at all times.


If you're referring to arbitrary columns that do not include the first column(s) then your options are more limited. The easiest way, by far, is a separate table that extracts the specific columns you want, but that seems to go against what you're asking for. Hence my question as to what it is, specifically, you're trying to do.


> Note: I have only one tab. The web suggests I select that tab and then use the window menu to "Move Tab to new window". This should provide me two windows of the same data that I can then put side by side.


In Numbers, tabs relate to separate, distinct documents, not sheets, or tables, or subsets of tables.

You can open numerous spreadsheet documents simultaneously and, by default, these open in separate windows. You can combine the separate documents into a window tabbed window, with one tab per document, and the method you describe explains how to extract a tabbed document into a separate window. It has no bearing on what you're trying to do here.



Sep 10, 2026 7:21 AM in response to Camelot

In excel, there's an icon that allows you to split the sheet into two views. You drag that icon to determine how many columns you want to show on each side of the split sheet. Then you move the slider to determine which column shows up on the left and right side of the split sheet.


All in all though, the YellowBox response is much, much better than the Excel suggestion or the convoluted process of putting a tab in a new window.


Or the even worse suggestion of opening the spreadsheet in iCloud and maneuvering the windows to be on top of one another. This was the one I used yesterday before yellowbox answer.

View non-adjacent columns side-by-side in Numbers

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