Janiye kaise aap English keyboard se Hindi Me kaise Type Kar sakte. Use करके बड़ी आसानी से हिन्दी font में type.

Microsoft Excel puri duniya mein sabse zyada use kiya jane wala spreadsheet program hai. Excel sabse zyada popular hai for it’s ability to use huge amount of data. Isme bahut sare features and functions hai like from making lists to charts to tracking and organizing information. Iss article mein pehle aap MS Excel in Hindi ke basics ke bare mein seekhenge aur uske baad agar aap use aur acche se seekhna chhate hai toh maine Top 5 MS Excel free courses ke links diye hai. Aap unpe jakar detail me MS Excel seekh sakte hai.  Aur agar inke alawa aapke mann mein koi aur sawal ya MS Excel se judi koi jankari chahte hain toh humare group se judein aur apna sawal puchein.

Hum apki poori sahayata karenge. Humse judne ke liye niche click karein –. MS Excel in Hindi ke basics ke bare mein jaane: 1) Sabse pehle aap MS Excel open karien. Jaise hi open hoga apke samne bahut sare templates ka option ayega. Usme se apko Blank Workbook par click karna hai. 2) Blank Workbook par click karte hi ek sheet open hojayegi, jisme bahut sari Rows, Columns and Cells honge.

Rows horizontal ( → ) hoti hai and inko aap row number se identify kar sakte hai. Jaise aap upar picture mein dekh sakte hai ki left side of sheet ke 1,2,3,4 likha hua hai toh unko rows bolte hai.

Columns vertical ( ↑ ) hote hai and inko aap column header se identify kar sakte hai. Ye sheet ke top me left to right i.e. Horizontally run karte hai. Jaise aap upar dekh sakte hai A,B,C,D. Inko columns bolte hai. Upar jo aap highlighted red box dekh rahe hai use Cell bolte hai and D5 is the Cell name.

You get to know the cell name by the row and column number. Free pci sound card driver download. Jaise upar wali picture mein column name is D and similarly row ka number is 5, jisse cell name hua D5. Ab main apko btati hu ki cell me type kasie karte hai, aap kisi bhi cell par jayiae aur apko jo bhi data enter karna hai use type karien. Once you’re done with it next cell par jane ke liye phirse enter press karien.

And right, left ya upar neeche jaane ke liye use arrow keys (↓← ↑ →). 3) Agar apko yaad ho toh starting mein apne Blank Workbook open kiya tha, toh jaise kisi book mein pages hote hai iss workbook me sheets hoti hai. Aap alag alag sheets maintain kar skte hai according to your need. Ab samajhte hai ki sheet kaise add karte hai: • Picture me jha sheet 1 likha hua that is the Sheet name.

Right click on it and a pop-up will appear (refer the picture given below). Jaise hi aap first option Insert par click karenge ek new sheet add ho jayegi. • Pop-up box ke alawa aap seedha add (+) wale symbol par jaise hi click karenge new sheet add hojayegi. (refer the picture given below) Insert ke alawa apko pop-up box mein aur bhi kayi sare options dikh rahe honge. Delete Ise tab use karte hai jab koi sheet delete karni hoti hai. Rename Koi bhi new sheet jab aap add karte ho toh uska default name hota hai Sheet 1, Sheet 2, Sheet 3 and so on depending on the number of sheet.

Jaise neeche wali picture mein naam hai Sheet 1. Toh Rename ke option se aap sheet ka naam kuch bhi apni requirement ke according save kar sakte hai. Move or copy This is simply jab apko koi sheet koi ek jagah se dusri jagah copy ya paste karna hota hai.

Jaise hi aap move or copy par click karte hai a pop-up box appears (given below). Tab color Aap sheet ko rename karne ke saath saath uska color bhi set kar sakte hai just for better classification. Isse aap alag alag sheets ko colors se identify kar sakte hai.