How i can set two different rows as header and footer
You can have half of your wish:
Using File | Page Setup | [Sheet] tab, you can use "Rows to repeat at top"
to repeat row 1 on each page printed from that sheet, but you can't use rows
that are separated. So you could repeat rows 1 through 15, but not just rows
1 and 15.
You can, of course, use the same File | Page Setup | [Header/Footer] tab to
set up text that would be placed in the header/footer for each page printed
from that sheet.
"mahbub" wrote:
Hi
Suppose row 1 i want to use for header for everypage and row 15 which i want
to setup as a footer. is it possible in excel.
BR//
Mahbub
|