Sida loo celiyo xariiqda koowaad ee Excel Waa hawl aad u faa'iido badan oo kuu ogolaan doonta inaad wakhti badbaadiso oo aad shaqadaada u fududayso markaad isticmaalayso qalabkan. Waxaan badiyaa u baahanahay in safka kowaad ee xaashida lagu soo celiyo bog kasta, ama lagu daro cinwaano ama cinwaano muhiim ah. Nasiib wanaag, gaaritaanka tan waa sahlan oo uma baahna aqoon sare oo Excel ah. Maqaalkan, waxaan ku tusi doonaa talaabo talaabo sida loogu celiyo safka ugu horeeya ee Excel, si aad u wanaajiso socodka shaqadaada oo aad u ilaaliso dukumentiyadaada si hufan. Akhri si aad u ogaato sida!
Talaabo talaabo ➡️ Sida loo soo celiyo laynka kowaad ee Excel
Sida loo celiyo safka koowaad ee Excel
- Tallaabada 1aad: Furan Microsoft Excel.
- Tallaabada 2aad: Hel khadka ugu horreeya ee aad rabto inaad ku celiso.
- Tallaabada 3aad: Dooro safka hore oo buuxa. Waad sameyn kartaa tan adiga oo gujinaya lambarka tiirka ee u dhigma kaas.
- Tallaabada 4aad: Midig ku dhufo doorashada oo dooro "Koobi" doorashada.
- Tallaabada 5aad: Hoos ugu dhaadhac safka aad rabto inaad ku celiso safka hore.
- Tallaabada 6aad: Guji unugga tiirka koowaad ee safka la doortay.
- Tallaabada 7aad: Midig ku dhufo unugga oo dooro ikhtiyaarka "Insert".
- Tallaabada 8aad: Liiska hoos-u-dhaca ayaa furmi doona. Dooro ikhtiyaarka " Geli unugyo la koobiyay "
- Tallaabada 9aad: Laynka ugu horreeya waxa lagu soo celin doonaa safka la doortay.
- Tallaabada 10aad: Ku celi tillaabooyinka 5 ilaa 9 haddii aad rabto inaad ku celiso safka hore ee safafka kale.
- Tallaabada 11aad: Ku keydi isbedeladaada dukumeentiga Excel.
S&J
Su'aalaha Inta badan La Isweydiiyo ee ku saabsan Sida loogu celiyo safka koowaad ee Excel
1. Sidee loogu celiyaa xariiqda koowaad ee Excel?
- Dooro tabka »View" ee ku yaal Excelribbon.
- Guji "Panel-ka qaboojiya".
- Dooro "Barafka Sarreeya."
2. Aaway ikhtiyaarka lagu qaboojin karo baalasha Excel?
Tallaabo tallaabo:
- Fur Excel oo ku dhufo tabka "View" ee ku yaal ribbon.
- Hel kooxda "Muuqaalka Buugga" oo dhagsii "Panels-ka qaboojiya".
3. Sidee loo qaboojiyaa safka koowaad ee Excel?
Tallaabo tallaabo:
- Dooro safka koowaad ee xaashidaada Excel.
- Guji "View" ee ribbon.
- Dooro "Panels-ka qaboojiya," ka dib "Freeize safka sare."
4. Waa maxay shaqada safafka qaboojinta ee Excel?
Shaqada qabooji safafka sare waa:
- Joog si muuqata xagga sare shaashadda laga bilaabo inta hoos u rogmanaysa xaashi ku taal xisaabin dheer.
- Samee Safka koowaad Safafka la xushay ayaa had iyo jeer ku sii jiraya xagga sare, xitaa marka aad si toosan ugu rogto xaashida.
5. Ma ku qaboojin karaa in ka badan hal saf gudaha Excel?
Tallaabo tallaabo:
- Dooro safafka aad rabto inaad ku qaboojiso gudaha Excel.
- Guji "View" ee ku yaala ribbon.
- Dooro »Barafka qaboojiya» ka dibna » qabooji safafka la xushay».
6. Sida loo joojiyo shaqada safafka barafka ee Excel?
Tallaabo tallaabo:
- Guji "View" ee ribbon.
- Dooro "Freeze panels".
- Ugu dambeyntii, dooro "Dami dhaqdhaqaaq la'aanta".
7. Sidee loo qaboojiyaa tiirarka Excel?
Tallaabo tallaabo:
- Dooro tiirka aad rabto inaad ku qaboojiso gudaha Excel.
- Guji "View" ee ribbon.
- Dooro "Panels-ka qaboojiya," ka dib dooro "Freeize Column Left" ama "Freeize Columns Selected."
8. Halkeen ka helaa ikhtiyaarka lagu qaboojinayo tiirarka Excel?
Tallaabo tallaabo:
- Fur Excel oo dooro tiirka aad rabto inaad qaboojiso.
- Guji tab "View" ee ku yaal ribbon.
- Soo hel kooxda "Muuqaalka Buugaagta" oo dooro "Freeize Panels".
- Dooro ikhtiyaarka "Barafka bidix qaboojiya" ama " qabooji tiirarka la doortay".
9. Sida loo qaboojiyo safka sare iyo tiirka bidix ee Excel?
Tallaabo tallaabo:
- Dooro unugga ku yaal safka ka hooseeya ee aad rabto inaad qaboojiso iyo dhanka midig ee tiirka aad rabto inaad qaboojiso.
- Guji »View» oo ku yaal ribbon.
- Dooro "Panels-ka qaboojiya," ka dib "Freeize Safka Sare" iyo "Freize Column Left."
10. Waa maxay nooca Excel ee lagama maarmaanka u ah isticmaalka safafka qaboojinta?
Dhammaan noocyada Excel, oo ay ku jiraan Excel 2019, Excel 2016, Excel 2013, Excel 2010 iyo noocyadii hore, waxay leeyihiin shaqada kaxaynta safafka.
Anigu waxaan ahay Sebastián Vidal, injineer kombuyuutar oo xiiseeya farsamada iyo DIY. Intaa waxaa dheer, anigu waxaan ahay abuuraha tecnobits.com, halkaas oo aan ku wadaago casharrada si aan tiknoolajiyada uga dhigo mid la heli karo oo qof walba la fahmi karo.