We work with very large tables, requiring lots of scrolling horizontally and vertically. But when we scroll past the original page size, we can no longer see the column and row headings. We'd love to lock / freeze the headings so that we can view them even when we scroll across or down. Without this feature, entering data into very large tables is very error-prone and labor-intensive.
Thanks!
Hello Barbara,
You can do this with the help of Table Filter macro: set Freeze first N rows / columns option and get it working.
Thanks, Andrey! To access the Freeze first N rows / column feature, do we need to buy the Filter Table and Charts app?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, this is a paid add-on and you need to buy it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Finally someone has provided the answer. What a painnnnnnnnnnn!!! I would assume this would be standard.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.