last 5 rows to be repeat in every page

[cletusrodrigues]

Dear Concerned,

when i remove print last 5 rows of the excel data should be repeated in every page at the bottom of each page. how to do this is excel 2007.

 

[Sektor]

Can you place some punctuations signs in your question?

 

[Trevor G]

Welcome to the forum,

Select the Page Setup Tab and on the left you have Page Setup, click the little arrow at the bottom right that will show you the normal Dialog box and select Sheet from there.

 

[cletusrodrigues]

Dear Concerned,

when i remove print last 5 rows of the excel data should be repeated in every page at the bottom of each page. how to do this is excel 2007.

like rows to repeat on top same wise i want rows to repeat at bottom. in every page

 

[Sektor]

You mean "Header and Footer" or "Rows to repeat at top"?

 

[cletusrodrigues]

You mean "Header and Footer" or "Rows to repeat at top"?

i have a excel sheet. i have some material details in first 5 rows. i have total of 100 rows. and at the end i have the 5 signature column. so when i give print first 5 rows & last 5 rows should be available on every sheet which i print in A4 size paper

 

[cletusrodrigues]

like rows to repeat on top same wise i want rows to repeat at bottom. in every page

i have a excel sheet. i have some material details in first 5 rows. i have total of 100 rows. and at the end i have the 5 signature column. so when i give print first 5 rows & last 5 rows should be available on every sheet which i print in A4 size paper

 

[Sektor]

For top part of sheet use "Rows to repeat at top": Page Layout tab -> Print Titles -> Rows to repeat at top. Point to range you want to be at rop.
For bottom part use footer: Page Layout tab -> Dialog Launcher (in bottom right corner) -> Header/Footer tab -> Custom Footer.