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 16 September 2026
CA Article Trainee

SR BAGAI & Co.

New Delhi

CA Inter

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
Featured 11 September 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
26 September 2026
Chartered Accountant

pushpganga ventures

Pune

CA

View Details
Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details