Inserting heading in every sheet of excel

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: 263 times
Replies (1)

Thanks for teaching a new trick. 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

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
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details