Breaking

Thursday, January 25, 2018

Excel Sheet Main Value ko Enter krna

Excel main Value Enter krna Bachoo ka Khail hai. Is Post main me aapko btau ga ke Excel main value enter kesy krtay hain.
For Example:  Aap ne Excel ko Open kiya hai or Aik New Sheet Aapkay samnay khul jati he. New Sheet mai jo Safaid Blank area he jo box se nazar aa rahay hain isko Sheet Area ya Work Area kehtay hain


Is main value enter krni hai to simply aapko wo area /cell select krna he jismay aap value Enter krna chahtay hain. Aapka Select kya hwa cell Highlight ho jaye iskay bahir ke border Bold ho jaynge. Jesy ke mai ne uper wali picture mai aik Cell ko select kiya hwa he jis main mai data enter krna chahta hoon...
Ab Aapko Jo Bhi Enter krna he Aap Is Area me Enter kr sktay hain. Enter krna Matlb Aap Select kiye hwy cell mai value likh sktay hain. jesy ke mai Cell mai "Hello...!! Friends" Likhna Chahta hoon to mai ne is trha Enter kiya he jesy k Nichay ki Picture Mai aap dekh sktay hain.



Is mai 3 ahem points hain jo aapko typing krtay wkt help krtay hain
1. Ager aap Tab key press kren ge to aap Next column mai chalay jaynge. matlb jis cell mai aap mojood hain is se aglay waly cell mai chlay jaynge.
2. Ager to aap Enter key press krtay hain to aap mojooda cell se nichay waly cell mai chalay jaynge. ye setting by default hoti hai Aap isko Change bhi kr sktay hain.
3. Ager Aap Usi Cell mai 2sri line Add krna chahtay hain to Aap Keyboard pr (Alt + Enter) Alt or Enter key ko Aik Sath press kren ge to Mojodaa Cell mai hi new line aa jaye gi


No comments:

Post a Comment