ICICI

Inserting heading in every sheet of excel


CA Ramsai N (Fresher)     24 June 2013

CA Ramsai N
Fresher 
 61 likes  594 points

| My Other Post

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: 134 times
1 Like
avater

Anandan (HOD accounts)     24 June 2013

Anandan
HOD accounts 
 75 likes  502 points

View Profile | My Other Post

Thanks for teaching a new trick. 

1 Like

Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  



Popular Discussion


view more »