Is there a way to lock/freeze a table column and row heading from scrolling?

Barbara Langworthy

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!

Andrey Khaneev _StiltSoft_

Hello Barbara,

You can do this with the help of Table Filter macro: set Freeze first N rows / columns option and get it working.