SAME HEADER AND FOOTER FOR ALL SHEETS IN EXCEL

3117 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
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
06 July 2026
Senior Accountant

Arvindkumar Maniar & Co.

Rajkot

CA

View Details
Company
05 July 2026
Financial Controller

NovumLake Partners

Mumbai

CA

View Details
Company
06 July 2026
Accountant

Agarwal Anoop and Associates

Noida

CA Final

View Details
Company
ARTICLESHIP 16 July 2026
CA Article

Pipara & Co. LLP.

Mumbai

CA Inter

View Details
Company
21 July 2026
Chartered Accountant

Keshri & Associates

Thiruvananthapuram

CA

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details
Company
16 July 2026
Manager - Finance & Accounts

Aliens Group

Hyderabad

CA Final

View Details