CA Ramsai N (Fresher) 24 June 2013
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
CAclubindia Online Learning offers a wide variety of online classes and video lectures for various professional courses such as CA, CS, CMA, CISA as well as various certification courses on GST, Transfer Pricing, International Taxation, Excel, Tally, FM, Ind AS and more. know more