Excel mein kaam karte waqt, aapko aksar naye worksheets banane padte hain. Yeh kaafi asaan process hai, aur yeh assignment aapko step-by-step guide karega ke kaise aap ek new worksheet create kar sakte hain aur usse save kar sakte hain.
1. New Worksheet Create Karna
Nayi worksheet create karne ke liye aapko kuch simple steps follow karne honge:
a. Excel Application Open Karna:
Sabse pehle, aapko apne computer mein Excel application open karna hoga. Aap ya toh Excel icon par double-click karke ya phir Start Menu se Excel ko search karke open kar sakte hain.
b. New Workbook Create Karna:
-
File Menu Se: Jab Excel open ho jaye, File tab par click karein. Yahan se aapko "New" ka option milega. New par click karne ke baad, aapko "Blank Workbook" ka option dikhega. Is par click karke ek nayi workbook (worksheet) create ho jayegi.
-
Keyboard Shortcut Se: Aap Ctrl + N ka shortcut use kar ke bhi ek nayi worksheet open kar sakte hain.
c. New Worksheet Add Karna:
- Excel mein ek workbook mein multiple worksheets ho sakti hain. Naye worksheet ko add karne ke liye, aapko neeche left side mein worksheet tabs ke pass "+" button dikhayi dega (jisme likha hota hai "Insert Worksheet"). Is button par click karne se ek nayi worksheet create ho jayegi.
- Aap apne worksheet ka naam bhi customize kar sakte hain. Iske liye, aap worksheet tab par right-click karein aur "Rename" ka option select karke apna desired naam likhein.
2. Worksheet Ko Save Karna
Worksheet ko save karna bohot zaroori step hai, taake aapka data kho na jaye. Excel mein worksheet ko save karne ke liye ye steps follow karein:
a. Save As
Agar aap pehli baar worksheet save kar rahe hain, toh aapko "Save As" option ka istemal karna hoga:
- File Menu Se: Excel mein File tab par click karein, phir Save As ka option select karein. Aapko apne computer mein kisi folder ka selection karna hoga jahan aap apni file ko save karna chahte hain.
- Save As Dialog Box: Jab aap "Save As" par click karenge, ek dialog box open hoga jahan aapko file ka naam dena hoga. Yahan se aap apni file ka format bhi select kar sakte hain (e.g., .xlsx, .xls, .xlsm).
b. File Ka Naam Denna
Save karne ke waqt, aapko apne worksheet ka ek unique naam dena hoga. Naam short, simple, aur relevant hona chahiye, taake aap future mein asaani se file ko identify kar sakein.
c. Save Location Choose Karna
Dialog box mein aapko ek folder select karna hoga, jahan par aap apni file ko save karna chahte hain. Aap apne computer ke kisi bhi location ya external storage device (e.g., USB drive) ko choose kar sakte hain.
d. Save Karna
File ka naam aur location select karne ke baad, Save button par click karein. Aapki worksheet ab save ho gayi hai.
e. Shortcut Se Save Karna
Agar aap worksheet ko jaldi save karna chahte hain, toh Ctrl + S ka shortcut use kar sakte hain. Agar pehli baar save kar rahe hain, toh Save As dialog box khul jayega.
3. Worksheet Ko AutoSave Karna
Agar aap Excel 365 ya 2019 version use kar rahe hain, toh Excel mein AutoSave ka feature bhi hota hai. Yeh feature automatically aapki worksheet ko save karta rehta hai, jab tak aap apne file ko close na karen.
Aapko sirf AutoSave option ko turn on karna hota hai, jo Excel ke upar-left corner mein dikhta hai (agar aapka file OneDrive ya SharePoint par saved hai).
4. File Ko Save Karne Ke Baad Close Karna
Jab aap apne worksheet ko save kar lein, uske baad agar aapko Excel ko close karna ho, toh:
- File Menu Se: File tab par click karen aur phir Close ka option select karen.
- Keyboard Shortcut Se: Aap Ctrl + W ka shortcut use kar ke bhi file ko close kar sakte hain.
Conclusion
Excel mein new worksheet create karna aur save karna bohot asaan hai. Aapko bas thoda practice ki zaroorat hai taake aap efficiently apne data ko organize kar sakein. New worksheet create karna aur regularly save karna best practices hain jo aapko apne kaam mein efficient banata hai.