CCI Online Learning
What do you want to learn today?

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Inserting heading in every sheet of excel

CA Ramsai N (Fresher)     24 June 2013

CA Ramsai N
 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: 137 times
1 Like

Anandan (HOD accounts)     24 June 2013

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  

Related Threads


Popular Discussion

view more »

Trending Tags
GST Live Class    |    x