I have a form whose row 1 to row 5 and row 18 to row 20 do not change. What is changed is the data in row 6 to row 17.
If I have data in, say, 30 rows, how do I print out the data on three pages (12 rows - row 6 to row 17- of data per page) and have the same row 1 to 5 and 18 to 20 on each page?
For row 1 to row 5, I can use the "page layout/print titles" function and set "rows to repeat at top" to "$1:$5". What about the bottom part?
Thanks in advance for any help.
If I have data in, say, 30 rows, how do I print out the data on three pages (12 rows - row 6 to row 17- of data per page) and have the same row 1 to 5 and 18 to 20 on each page?
For row 1 to row 5, I can use the "page layout/print titles" function and set "rows to repeat at top" to "$1:$5". What about the bottom part?
Thanks in advance for any help.