Hi Tim,
Try this.
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).
Rows 149 showing, and the Header Rows are still in view.
Regards,
Ian.
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?
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
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
Lock a table in view
