Ha u sebetsa le Excel spreadsheets, ka linako tse ling ho hlokahala hore u arohane sele e itseng likarolo tse peli. Empa, ha ho bonolo joalokaha e bonahala ka lekhetlo la pele. A re ke re boneng hore na re ka arola sele joang likarolo tse peli ho Microsoft Excel, le hore na re ka e arola joang.
Ho arohana ha sele
Hang-hang ho lokela ho hlokomeloa hore lisele tsa Microsoft Excel ke lisebelisoa tse ka sehloohong tsa mohaho, 'me li ke ke tsa aroloa likarolo tse nyenyane, haeba li sa kopane pele. Empa, seo re lokelang ho se etsa haeba, ka mohlala, re hloka ho theha hlooho ea litafole e rarahaneng, e 'ngoe ea likarolo tsa eona e arotsoe likarolong tse peli? Tabeng ena, o ka sebelisa maqheka a manyenyane.
Mokhoa oa 1: Kopanya lisele
E le hore lisele tse itseng li hlahe li arohane, ho hlokahala hore ho kopane lisele tse ling tsa tafole.
- Ho bohlokoa ho nahana ka mohaho oohle oa tafole e tlang.
- Ka holimo ho sebaka se shebaneng moo u lokelang ho ba le karolo e arohaneng, khetha lisele tse peli tse haufi. Ho ba tabeng "Lapeng"ho sheba ka setsi sa lithulusi "Ho lumellana" holim'a konopo ea riboni "Kopanya 'me u behe bohareng". Tobetsa ho eona.
- Bakeng sa ho hlaka, ho ntlafatsa seo re nang le sona, re beha meeli. Khetha mofuta o mong le o mong oa lisele tseo re rerang ho li arola tlas'a tafole. Tabeng e tšoanang "Lapeng" karolong ea lithulusi "Letšoao" tobetsa letšoao "Meeli". Lethathamong le hlahang, khetha ntho e reng "Meeli eohle".
Joalokaha u ka bona, ho sa tsotellehe hore ha rea ka ra arola, empa ho e-na le hoo, re na le maikutlo a fosahetseng a sele e arohaneng.
Thuto: Joang ho kopanya lisele ho Excel
Mokhoa oa 2: Arola lisele tse kopantsoeng
Haeba re hloka ho arola sele eseng hlooho, empa bohareng ba tafole, joale tabeng ena, ho bonolo ho kopanya lisele tsohle tsa mela e 'meli e haufi,' me ke feela ho arola sele e batlang.
- Khetha mela e 'meli e haufi. Tobetsa motsu haufi le konopo "Kopanya 'me u behe bohareng". Lethathamong le hlahang, tobetsa ntlha "Kopanya ka mola".
- Tobetsa ho sele e kopantsoeng eo u batlang ho e arola. Hape, tobetsa motsu o haufi le konopo "Kopanya 'me u behe bohareng". Lekhetlong lena, khetha ntho "Hlakola Mokhatlo".
Kahoo re na le sele e arohaneng. Empa, hoa hlokahala hore u nahane hore Excel e lemoha ka tsela ena sele e arohaneng e le ntho e le 'ngoe.
Mokhoa oa 3: arola diagonally ka ho etsa moralo
Empa, ka diagonally, o ka arola sele e tloaelehileng.
- Re tobetsa ka ho nepahetseng seleng e lakatsehang, le ho menu ea moelelo e hlahang, khetha ntho "Fomisa lisele ...". Kapa, re thaepa seqhoqho sa keyboard Ctrl + 1.
- Ka fensetere ea selefouno e bulehileng, e-ea tab "Moeli".
- Haufi le bohareng ba fensetere "Mongolo" Tobetsa ho e 'ngoe ea likonopo tse peli, tse bontšang mola o oblique o thehiloeng ho tloha ho le letona ho ea ka ho le letšehali, kapa ho tloha ho le letšehali ho ea ka ho le letona. Khetha khetho eo ue batlang. Mona o ka khetha mofuta le mebala ea mola. Ha khetho e etsoa, tobetsa konopo ea "OK".
Ka mor'a moo, sele e tla aroloa ke slash diagonally. Empa, hoa hlokahala hore u nahane hore Excel e lemoha ka tsela ena sele e arohaneng e le ntho e le 'ngoe.
Mokhoa oa 4: arola diagonally ka ho kenya sebopeho
Mokhoa o latelang o loketse ho arola sele ka diagonally feela haeba e kholo, kapa e entsoe ka ho kopanya lisele tse 'maloa.
- Ho ba tabeng "Kenya", karolong ea lithulusi "Lipapiso", tobetsa konopo "Litšoantšo".
- Linthong tse butsoang, ka lebokoseng "Mantsoe", tobetsa palo ea pele.
- Thala mola ho tloha k'honeng ho ea ho sekhutlong sa sele ka tsela eo ue hlokang.
Joalokaha u ka bona, ho sa tsotellehe hore ka Microsoft Excel, ha ho na litsela tse tloaelehileng tsa ho arola sele e ka sehloohong likarolo, ho sebelisa mekhoa e 'maloa, u ka finyella sepheo se batlang.
