SAME HEADER AND FOOTER FOR ALL SHEETS IN EXCEL

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
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details