Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Lock a table in view

I am relatively new to numbers and working on some spreadsheets. I have a little table that I would like to lock so it is always viewable. Is this possible? I know you can freeze headers and footers, but I want to freeze the entire table.

Posted on

Reply

Dec 17, 2017 6:15 PM in response to Tim101691 In response to Tim101691

Not really possible. the easiest way may be to place that table on a sheet by itself so there is no reason to scroll around. That doesn't really meet your request that is always be visible.


Can you share any additional details about what you are trying to do?

Dec 17, 2017 6:15 PM

Reply Helpful

Dec 17, 2017 6:31 PM in response to Wayne Contello In response to Wayne Contello

Yes I have two large tables with a much smaller table in the center of them. Much like frozen headers do, I’d like that small chart to scroll with me as I look down the larger chart. If I could make a table that is JUST headers it would accomplish what I needed

Dec 17, 2017 6:31 PM

Reply Helpful

Dec 17, 2017 7:01 PM in response to Tim101691 In response to Tim101691

Hi Tim,


An 'all headers' table came to mind while I was reading that, too. But it wouldn't work. Frozen headers stay at the top of the window only until no other part of the table is visible.


What might work is a skinny table with the maximum (five) header rows and enough (empty) body rows to reach past the bottom of the two larger tables. The headers would remain visible at the top of the window as you scrolled down the sheet.


No time to try it at the moment.


Regards,

Barry

Dec 17, 2017 7:01 PM

Reply Helpful

Dec 18, 2017 3:08 AM in response to Tim101691 In response to Tim101691

Hi Tim,

Try this.

User uploaded file

Table 1 has the maximum allowed 5 Header Rows. Use them to include the information that you want to stay in view.

On Table 1 and Table 2, Freeze Header Rows.

Scroll down ( or drag up either table).

User uploaded file

Rows 149 showing, and the Header Rows are still in view.


Regards,

Ian.

Dec 18, 2017 3:08 AM

Reply Helpful
User profile for user: Tim101691

Question: Lock a table in view