Page Views

Monday, 3 December 2012

Excel merge cells

friends aaj main aap ko ms office ke aik program MS Excel ke merge ke bare mein kuch bataon ga wo bhi keyboard ke sath.

Win+R run mein excel likh ke enter karen ab excel ka program khul gaya hai, ab format ko click karen ya Alt+o keys ko press karen to aap ke samne ye bar khul jayegi see below pic.


ab aap cells ko click karen ya os ka shortcut use karen Ctrl+1 phir aap ke second bar khud jayegi see this below picture

ab aap es bar mein aik option dekh rahe hain Merge Cells os ko tick (select) kar ke ok kar den.
phir aap excel ke window pe koi bhi words likhen jin words ko merge karna hai bas unko aap select kar ke Alt+Enter keys press karen to wo merge ho jayega see below picture.


Thanks for reading my lectures 

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Bluehost Coupons