Excel problem

**shahleopak** · 21st July 2009, 12:43 PM

hello all member of IT DUNYA pls help me
1: mjh ko koi btaye k meri ledger ki sheet excel me bani hoye ha phalay b ek corrupt ho gaye ga me ne us ko 1 month k bad open kia tha. kia koi aisa method ha k me apni excel ki sheet ko protect bnao ta k wo corrupt na ho
2: me ne ye pochna ha k me ne ek ledger bnaya ha me chata hoon k jb Debit ho to wo red color me show ho or pls koi ye btaye k me excel me ledger bntata hon to table k elawa baqi jo space ho wo blank ho jaye me ne cell merge kia ha lekin wesa nhi hota pls koi or methdo btao
or me chata hon k jaha jaha me ne formula use kia ha us cell me pasword lga don formula hide krna to ata ha lekin fromula pr pasword kaisay lgatay hen pls koi btaye

**shahleopak** · 21st July 2009, 01:08 PM

pls koi to meri help kare meri problem solve kro plsss
kelp me

**marwat** · 21st July 2009, 01:12 PM

AAP KE TEEN QUESTION HAIN,

MEY AP KE DOOSREY QUESTION KA JAWAB BATATA HOON.

AGER AAP CHAHTEY HAIN KE TABLE KE ELAWA BAGEE POORY SHEET WHITE NAZER AAYE,USS KE LIYE AAP APNEY TABLE KEE GRID LINES KE SCALE KO ZIYADA KARAIN,AUR USS KE BAAD HIDE GRIDLINES KE OPTION KO SELECT KARAIN.
LO JANAB AAP KA AIK KAAM TOU HO GAYA.

BAQEE DO SAWAL KO ME TRY KARTA HOON.

**shahleopak** · 21st July 2009, 01:23 PM

Marwat bhai me ne table sclect kr k us ki line ko ziada kia ha us k bad hide grid line ka option nhi mil rha ha hide ka mila ha lekin complete table hide ho jati ha gridline hide kaha ha

**marwat** · 21st July 2009, 01:24 PM

OK 2 MINUTES BAAD MEY SCEEN SHOTS SE AAPKO SAMJATA HOON.

WAIT

**shahleopak** · 21st July 2009, 01:25 PM

Thnx brother i m waiting..............

**marwat** · 21st July 2009, 01:43 PM

SCREENSHOTS KO FOLLOW KARAIN,
AGER CLEAR NAHEE HAY TOU BATA DO.

ENJOY

Name: EXCEL1.jpg
Views: 321
Size: 80.6 KB

Name: EXCEL2.jpg
Views: 314
Size: 94.8 KB

Name: EXCEL3.jpg
Views: 263
Size: 64.9 KB

**shahleopak** · 21st July 2009, 02:19 PM

mARWAT Bhai ap ka buhat buhat buhat shukria ab samajh agaye ha pls baqi dono b bta do agr pta ho to
pls ye b btao agr hm ne kisi cell pr ya column ya row pr lock wid pasword lagana ho to wo kaisay lgayen ge pls tell me
again thnx
Shah

**shahleopak** · 21st July 2009, 02:34 PM

pls koi to eri help karay i m in trouble urgently

**shahleopak** · 21st July 2009, 03:12 PM

mera ek masla to hal ho gya ha pls ab ye b btao
1: mjh ko koi btaye k meri ledger ki sheet excel me bani hoye ha phalay b ek corrupt ho gaye ga me ne us ko 1 month k bad open kia tha. kia koi aisa method ha k me apni excel ki sheet ko protect bnao ta k wo corrupt na ho
2: me ne ye pochna ha k me ne ek ledger bnaya ha me chata hoon k jb Debit ho to wo red color me show ho
pls help me koi senior member to btaye.............

**Mubashir Aziz** · 21st July 2009, 04:38 PM

1. Corrupt file ko ms excel main open key windows main neechay walay open kay arrow par click karain aur uss man say open & repair ko select kar lain. jitni file repair hosakti hay ho jai gi ...

2. Jahan par debit hay wahan aap jain phir oper tool bar main say Format>Cell>General> Number main say right windows main say negative portion main say red ko select kar lain aur ok kar dain ...... picture bhi sath day raha houn .......