Google Sheets basics: mobile se hisaab-kitaab aur sharing
Google Sheets free hai aur phone par bhi chalta hai. Sheet banana, formule, filter, aur team ya family ke saath share karna: dukaan ke roz ke hisaab ka example.

- Google Sheets free hai; sirf Google (Gmail) account chahiye.
- Sheet share karke kai log ek saath, alag phones se, likh sakte hain.
- Har badlaav apne aap save hota hai, aur purana version wapas laaya ja sakta hai.
Is post mein
Google Sheets, Excel jaisa hi free spreadsheet hai jo browser aur phone app dono par chalta hai. Sabse badi khoobi: ek hi sheet par kai log alag-alag phones se ek saath kaam kar sakte hain, aur sab kuch apne aap save hota hai. Yahan dukaan ki roz ki bikri ka hisaab banana seekhte hain.
1. Nayi sheet banaiye
Computer par sheets.google.com kholiye ya phone par Google Sheets app install kariye, aur "+" (Blank) dabaiye. Upar naam dijiye, jaise "Dukaan bikri 2026".
2. Columns tay kariye
Pehli row mein: Date | Cash | UPI | Udhaar | Total. Pehli row ko mota (bold) kariye, aur View → Freeze → 1 row, taaki neeche jaane par heading dikhti rahe.
3. Total ka formula
Cell E2 mein: =B2+C2+D2 ya =SUM(B2:D2). Phir E2 ke kone ke chhote dot ko neeche kheenchiye; har row mein formula apne aap lag jaata hai. Mahine ka total: =SUM(E2:E31). (Formule ki shuruaat ke liye padhiye: Excel Day 1; Sheets mein yeh sab waise hi chalte hain.)
4. Filter aur sort
Heading row chuniye → Data → Create a filter. Ab kisi bhi column ko chhota-bada kar sakte hain, ya sirf kisi ek din ya hafte ka data dekh sakte hain.
5. Share kariye, sahi permission ke saath
- Upar Share dabaiye aur staff ya family ka Gmail daaliye.
- Editor: likh aur badal sakte hain (jo roz entry karta hai).
- Viewer: sirf dekh sakte hain (jaise partner ya CA).
- "Anyone with the link" tabhi kariye jab data mein kuch bhi nijee na ho.
6. Galti ho gayi? Version history
File → Version history → See version history. Kisi ne galti se data mita diya ho, to purana version wapas laa sakte hain.
Mobile par kaam ki baatein
- Cell par double-tap karke likhiye; neeche "fx" se formula.
- App mein sheet ko "Available offline" kar sakte hain; net aane par sync ho jaati hai.
- Phone par lambi sheet ke liye pehle columns freeze kar lijiye.
Sheet mein grahakon ke phone number jaisa nijee data ho, to share sirf zaroori logon ke saath kariye.



Comments