Inserting heading in every sheet of excel

Excel 826 views 1 replies

Do you want to insert the company name (or Same Heading) in all the sheets of Work book??????

Here is the solution...

Step:: Go to View menu >> Marcos >> Record Macros

Step 2:: Give name and Short cut and click on OK

Step 3:: Create the heading (with desired font , color , backgroud etc)

Step 4 ::: Go to View menu >> Macros >> Stop recording

Step 5 ::: Select all(left click on sheet name)/ desired sheets, in which u want to insert the name

Step 6::: Use short cut (if u given before) or View>> Macros >> Run that marco....

Task Completed BOSS

 


Attached File : 666306 1191521 inserting title using macros.xlsx downloaded: 208 times
Replies (1)

Thanks for teaching a new trick. 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details