Mpaka mutayamba kuyesa kusintha mawonekedwe a spreadsheet yosindikizidwa mu Excel, mwina simungadziwe momwe zimakhalira zovuta kukonza zovuta ndi malo opuma masamba. Kusindikiza mu Excel kumatha kukhala kokhumudwitsa, ndipo anthu ambiri amayesa kuwonjezera masamba angapo pamapepala awo poyesa kukonza zolekanitsa za data zomwe zimayambitsidwa ndi kusweka kwamasamba ku Excel.
Koma mukamagwiritsa ntchito chida cha Insert Page Break poyesa kukonza zovuta ndi masamba osweka, mutha kuyambitsa zovuta zina. Kuthetsa nkhanizi kungakhale kokhumudwitsa chifukwa masamba omwe aikidwa pamanja si osavuta kuwona ndipo kungakhale kovuta powonjezera kapena kuchotsa deta pa spreadsheet.
Maspredishiti opangidwa mu Microsoft Excel 2013 sasindikizanso momwe mukufunira mwachisawawa. Izi zipangitsa zosintha kuzinthu zambiri zamasamba zomwe zimakhudza kusindikiza, komanso zitha kuphatikizanso kuyika zopumira pamanja zamasamba.
Koma ngati mutayamba kusintha mizere, mizati, kapena maselo aliwonse a pepala lanu, mukhoza kupeza kuti kuthyoka kwa masamba kumabweretsa khalidwe lachilendo losindikiza. Kubwerera mmbuyo ndikusintha zosweka zamasamba zitha kukhala zokhumudwitsa, chifukwa chake mutha kusankha kungochotsa masamba onse ndikuyambanso. Maphunziro athu m'nkhaniyi akuwonetsani zomwe mungachite kuti mukonzenso zosweka zamasamba patsamba lanu.
Momwe mungachotsere zosweka zamasamba patsamba la Excel
- Tsegulani pepalalo.
- Sankhani tabu Kapangidwe katsamba .
- Dinani batani zopuma .
- Pezani Bwezeretsani zosweka zamasamba .
Wotsogolera wathu pansipa akupitiliza ndi zina zowonjezera pakuchotsa masamba onse pamasamba anu a Excel, kuphatikiza zithunzi zamasitepewa.
Momwe Mungakhazikitsirenso Kusweka Kwa Masamba mu Excel (Malangizo ndi Zithunzi)
Kalozera pansipa akuganiza kuti muli ndi tsamba la Microsoft Excel 2013 lomwe lili ndi masamba oduka pamanja, komanso kuti mukufuna kuchotsa zosweka zamasamba ndikuzikonzanso kumasamba omwe amapezeka mwachisawawa. Ngati mutsatira njira zomwe zili m'munsizi ndipo osawona njira ya Bwezeretsani Masamba Onse, palibe zosweka pamanja patsamba lanu. Ngati pepalalo lisindikiza modabwitsa popanda kusweka, pangakhale malo osindikizira enaake.
Khwerero 1: Tsegulani fayilo yanu mu Excel 2013.
Gawo 2: Dinani pa tabu Kapangidwe katsamba Pamwamba pa zenera.
Gawo 3: Dinani batani kusweka" Mu gawo " Kukhazikitsa tsamba" mu navigation bar, ndiye dinani "Njira" Bwezeretsani zosweka zamasamba zonse” .
Kudumpha kwamasamba kumachotsedwa mu Excel pamlingo wamasamba. Ngati mukufuna kuchotsa zotsalira zamasamba pamapepala angapo ogwirira ntchito, muyenera kuchita izi patsamba lililonse padera.
Kodi ndichifukwa chiyani ndikufunika kuwonjezera kapena kuchotsa tsamba lopuma mu Excel?
Microsoft Excel ikhoza kukhala ntchito yovuta kwambiri kuti mugwire nayo ntchito mukafuna kusindikiza china chake. Simamvetsetsa zomwe mwalemba m'maselo anu, ndipo siyesa kusunga mizere kapena mizere pamodzi patsamba limodzi ngati izi zingapangitse kuti deta ikhale yosavuta kuwerenga.
Njira imodzi yomwe mungayesere kuthana ndi vuto losindikizali ndikugwiritsa ntchito masamba oduka pamanja. Mukawonjezera kuphuka kwatsamba pamanja, mumauza Excel kuti iyambe tsamba latsopano pamalopo. Izi zimakupatsani mwayi wowongolera zomwe zasindikizidwa patsamba liti, kupangitsa kuti omvera anu azitha kumvetsetsa deta yanu mosavuta.
Koma ndizotheka kuti wina akhale ndi malingaliro osiyanasiyana pa spreadsheet, zomwe zimapangitsa kuti achotsedwe kapena kuonjezedwa zambiri. Kusweka kwamasamba pamanja sikungasinthidwe kuti kuwonetse izi, ndipo mutha kukhala ndi ntchito zachilendo zosindikiza monga zotsatira zake. Zikatere, muyenera kuchotsa zopumira pamanja zamasamba kuti mutha kusindikiza zonse molondola.
Dziwani zambiri zamomwe mungachotsere zosweka zamasamba mu Excel 2013
Monga tanena kale, kuchotsa zotsalira zamasamba mu Microsoft Excel ndi chimodzi mwazinthu zomwe simungathe kuchita posankha mapepala angapo. Ngati mukufuna kukonzanso zosweka zamasamba patsamba limodzi lantchito mu Excel workbook, muyenera kuwonanso bukhu lonselo ndikusankha pepala lililonse lomwe mukufuna kusinthiranso masambawo.
Ngati mukufuna kuchotsa tsamba limodzi lokha mu Microsoft Excel, mutha kudina cell mumzere womwe uli pansi pa tsamba losweka, kenako dinani batani la Breaks mu gulu la Kukhazikitsa Tsamba ndikusankha Chotsani Tsamba Kuswa. Ngati mukufuna kuchotsa chopumira chatsamba choyimirira, mutha kudina selo kumanja kwa tsamba losweka m'malo mwake.
Ngakhale mutha kuwona kusweka kwamasamba mowoneka bwino mu Excel poyang'ana ma gridi akuda pang'ono, zitha kukhala zovuta kuziwona. Mungafune kuganizira zosamukirako Fayilo> Sindikizani ndipo yang'anani chithunzithunzi chosindikizira kuti muwone momwe tsamba lanu losindikizidwa lidzawoneka, kapena pitani ku View tabu ndikudina chiwonetsero chanthawi tsambalo أو Kapangidwe katsamba Kuti muwone momwe zinthu zidzawonekere patsamba losindikizidwa. Anthu ena amadinanso Kuwona kwa Tsamba la Tsamba ndikusiya Excel momwemo chifukwa amapeza kuti ndi njira yosavuta yogwirira ntchito.
Ngati mukuvutika kuyesa kusweka kwamasamba mu Excel 2013 mukadina ma cell amodzi, yesani kusankha mzere kapena mzere wonse m'malo mwake. Mukadina nambala ya mzere kuti musankhe mzere wonse, Excel imawonjezera tsamba lopingasa pamwamba pa mzerewo mukadina. Ikani tsamba lopuma . Mosiyana ndi izi, ngati mudina chizindikiro kuti musankhe gawo lonse, Excel imawonjezera tsamba lopumira kumanzere kwa mzere mukawonjeza tsamba lopuma.
Pali makonda angapo mu Microsoft Excel 2013 omwe angakhudze momwe spreadsheet imasindikizidwira. Choyika chimodzi chomwe chimakhazikitsidwa nthawi zambiri ndi mizere ya gridi kapena malire omwe amalekanitsa ma cell anu.
