SAME HEADER AND FOOTER FOR ALL SHEETS IN EXCEL

3106 views 8 replies

hELLO EVERYONE...

i WANT TO KNOW THAT IS IT POSSIBLE TO HAVE SAME HEADER & FOOTER(I.E FIRMS LETTER HEAD)  IN EXCEL WORK BOOK??

 

Replies (8)

yes! but the fonts may b differ in size, they can easily b preapre at word don't puzzle urself dear. If u do the quality may diifer.

yes it can be done. first  u select the row u want to repeat, than go to page setup than sheet icon there u will find row to repeat at top. select that and that row will be repeated in all the pages.

Select row- page setup- sheet- rows to repeate

nO DEAR... ITS NOT WORKING...

yes it is possible..

But how...

Originally posted by :SONUJRT
" But how... "


 

you need to go for print preview, there you will be able to see it and also alternate of adding header and footer is

Select Row -> Page Setup -> Head and Footer -> Header or Footer

Better one is to select File > Page setup > select rows to repeat

 In Excel 2007 click insert > header and footer> type the relevant in the coloumn. You' ll find the same header or footer in all the active pages.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details
Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
24 June 2026
Chartered Accountant - GST & Direct Tax

APL

Mumbai

CA

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details