Forum Discussion
gerasimos1023
Apr 01, 2022Copper Contributor
How to force text to print at the bottom of the last page of an excel
Hello all, I have a worksheet that works with tables and I filling it with data from other sheets. How can I force text to be printed at the bottom of the last page of the sheet that is going to...
mtarler
Apr 01, 2022Silver Contributor
gerasimos1023 So someone else here may have a better solution but I did something like this for one of my projects. Basically I did all the references to other sheets and fixed values. Then I had a table of values and needed to add a disclaimer after that table. So I created this:
=LET(l_1,ROWS(F9#),
spaces,2,
l_2,ROWS(H9:H15),
seq,SEQUENCE(l_1+spaces+l_2),
IFS(seq<=l_1,INDEX(F9#,seq),
seq<=l_1+spaces," ",
seq,INDEX(H9:H15,seq-l_1-spaces)
))
So basically my dynamic table was 'built' at F9 (so F9# refers to a dynamic length of rows)
I added 2 'spaces' lines
Then i add the disclaimer in cells H9:H15.
I hope this helps give you an idea how it might work for you.