View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default 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