CCI Online Learning
What do you want to learn today?
     
CIBIL

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
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: 137 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  


Related Threads


Loading

Popular Discussion


view more »



Trending Tags
GST Live Class    |    x