Can I create a table that stays on screen when scrolling?

Hi all. I have a large spreadsheet of a couple hundred lines for a budget, broken into a dozen sections. I'd like to have a table that's constantly on the side that shows the totals for each section, regardless of where I scroll to in the spreadsheet. Is this possible? I've tried creating a new table and freezing things, but it only seems to freeze the headers, not the dozen tabulated sections below the headers.


Thanks so much.


jeff

Mac Pro, macOS 11.6

Posted on May 12, 2022 5:51 PM

Reply
Question marked as Top-ranking reply

Posted on May 12, 2022 6:46 PM

"Is this possible?"


No.


You can freeze up to 5 header rows and 5 header columns. Doing so keeps those headers on the screen as long as one body row and or one body column is still on screen.


Nothing else, to my knowledge, can be kept in the same screen position as the document is scrolled.


With the current version of Numbers and of macOS, you may be able to open 2 copies of the document, place both on the screen at the same time. Scrolling one of the the copies should be independent of the other, but I've not looked into this, so can't be certain that is the case.


If the tales are on separate sheets, you might also be able to show both sheets simultaneously, and may be able to scroll them independently. Again, this is conjecture, as I've not tried it.



You might also use the Provide Numbers Feedback menu item in the Numbers menu to send a Feature request directly to Apple, requesting this feature be added to Numbers.


Apple's product development team members do not read the messages in these user-to-user communities, nor do they post here. Messages sent via the product Feedback route are read by Apple and forwarded on merit to the appropriate product development teams.


Regards,

Barry

Similar questions

1 reply
Question marked as Top-ranking reply

May 12, 2022 6:46 PM in response to jsturick

"Is this possible?"


No.


You can freeze up to 5 header rows and 5 header columns. Doing so keeps those headers on the screen as long as one body row and or one body column is still on screen.


Nothing else, to my knowledge, can be kept in the same screen position as the document is scrolled.


With the current version of Numbers and of macOS, you may be able to open 2 copies of the document, place both on the screen at the same time. Scrolling one of the the copies should be independent of the other, but I've not looked into this, so can't be certain that is the case.


If the tales are on separate sheets, you might also be able to show both sheets simultaneously, and may be able to scroll them independently. Again, this is conjecture, as I've not tried it.



You might also use the Provide Numbers Feedback menu item in the Numbers menu to send a Feature request directly to Apple, requesting this feature be added to Numbers.


Apple's product development team members do not read the messages in these user-to-user communities, nor do they post here. Messages sent via the product Feedback route are read by Apple and forwarded on merit to the appropriate product development teams.


Regards,

Barry

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.

Can I create a table that stays on screen when scrolling?

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