How to force text to print at the bottom of the last page of an excel

Copper Contributor

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 be printed. I dont want it to be placed in footer but at the same page (last page, the print area will be 1 or 2 or 3 or even more). 

Furthermore, Can I grab data from another sheet and place them at the bottom? Not a single text , but maybe 4-5 lines.

 

Thank you !

1 Reply

@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.