01 ka 02
Shintsha iWolumn Widths kunye neeNqweliso zeeRow kunye neMouse
Iindlela zokuKwandisa iikholam kunye noTshintsho lweeRow
Kukho iindlela ezininzi zokwandisa iikholomu kwi-Excel kunye ne-Google Spreadsheets. Ulwazi malunga neendlela ezahlukeneyo lunokufumaneka kumaphepha alandelayo:
- Sitshintshela iikholeji yobubanzi beekholeji okanye iiRow Heights usebenzisa iMouse - jonga ngezantsi
- Tshintsha iWolumn Widths okanye iIt Heights Usetyenziso lweRibbon (Excel kuphela)
Qaphela : Akunakwenzeka ukutshintsha ububanzi okanye ukuphakama kweselula esisodwa - ububanzi kufuneka butshintshelwe kuyo yonke ikholomu okanye ukuphakama komgca wonke.
Sitshintshela i-Column Individual Widths ne-mouse
Amanyathelo angezantsi agqithise indlela yokutshintsha iikholam nganye ngokweenkcukacha usebenzisa mouse. Ukwandisa ikholomu A umzekelo:
- Beka umgca we mouse kwimida yomda phakathi kweikholomu A neB kwibhloko yekholomu
- I-pointer izakuguqula kwisicatshulwa esimnyama esiphambili esicatshulwa kabini njengoko kuboniswe kumfanekiso ongentla
- Cofa uze ubambe iqhosha lasekhohlo le mouse kwaye udibanise i-arrow ehambileyo kabini ukuya ngasekunene ukwandisa ikholomu A okanye ngakwesobunxele ukwenzela ukuba ikholam encinane
- Ukukhupha iqhosha le mouse xa ububanzi obufunayo bufikile
I-AutoFit Column Widths usebenzisa iMouse
Enye indlela yokunciphisa okanye ukukhulisa iikholomu kunye ne mouse kukuvumela i-Excel okanye i-Google Spreadsheets Auto Fit ububanzi bekholomu kwizinto ezide kakhulu zedatha equlethwe kukho.
Ukufumana idatha ende, ikholomu iya kwanda, kodwa ukuba ikholomu iqulethe izinto ezimfutshane zedata, ikholomu iya kufutshane ukuze ivumelane nale nto.
Umzekelo: Shintsha ububanzi bekholam B usebenzisa i-AutoFit
Beka umgca we mouse kwimida yomda phakathi kweikholomu B no-C kwintloko yentloko. I-pointer izakuguqula kwisicatshulwa esiphambili.
- Nqakraza kabini ngeqhosha le mouse. Ikholam iya kutshintsha ngokuzenzekelayo ububanzi bayo ukufanisa ukungena okude kunaloo kholomu
Shintsha yonke i-Column Widths kwi-Worksheet usebenzisa iMouse
Ukulungelelanisa bonke ububanzi bekholomu
- Cofa kwi Khetha Yonke inkinobho ngasentla ngentloko yomqolo ukugqamisa zonke iikholomu kwiphepha lokusebenzela langoku.
- Beka umgca we mouse kwimida yomda phakathi kweikholomu A neB kwibhloko yekholomu
- I-pointer izakuguqula kwisicatshulwa esiphambili.
- Nqakraza iqhosha le mouse elikhohlo uze udibanise i-arrow-headed ekhohlo ukuya kwesokunene ukwandisa zonke iikholamu kwiphepha lokusebenzela okanye ngakwesobunxele ukwenzela ukuba zonke iikholam zincinci.
Tshintsha iinqonga zeeRow kunye neMouse
Izinketho kunye namanyathelo okutshintsha iindawo eziphakamileyo zamanzi kwi-Excel kunye ne-Google Spreadsheets kunye nemouse zifana nokutshintsha ububanzi bekholomu, ngaphandle kokuba ubeka isikhombisi semouse kumgca womda phakathi kwemigca emibini kumgca woluhlu endaweni yesicatshulwa sekholomu.
02 we 02
Tshintsha iikholeji eziphezulu Ukusebenzisa i-Ribbon Options kwi-Excel
Shintsha iikholeji zokubala usebenzisa i-Ribbon Options
- Cofa kwiseli kwikholam ofuna ukuyitshintsha - ukukhulisa iikholamu ezininzi ziphakamisa iseli kwikholamu nganye
- Cofa kwiThebhu yasekhaya yerbhoni
- Cofa kwi icon yoFomathi ukuvula imenyu yehla yokukhetha
- Ukuzenzekela ngokuzenzekelayo iikholam (s), khetha ukhetho kwinqanaba leSeli Size kwimenyu
- Ukufaka ubungakanani obukhulu kumgama wobanzi, nqakraza kwikhetho lokuPhula kwekholomu kwimenyu ukukhupha ibhokisi yencoko yababini yekholomu
- Kwibhokisi yencoko faka ububanzi obufunayo kumlingisi (ububanzi obungagqibekanga: iibali eziyi-8.11)
- Cofa Kulungile ukutshintsha ububanzi bekholuni uze uvale ibhokisi yencoko
Shintsha yonke i-Column Widths kwiWindows Worksheet usebenzisa iMenu
- Cofa kwi Khetha Yonke inkinobho phezulu kwintloko yentloko ukugqamisa zonke iikholomu kwiphepha lokusebenzela langoku.
- Phinda amanyathelo 5 ukuya ku-7 ngentla ukufaka ubungakanani obuthile kuzo zonke iikholomu
Tshintsha iinqanaba zeRow usebenzisa i-Ribbon Options
Izinketho kunye namanyathelo okutshintsha iindawo eziphakamileyo zamanzi kwi-Excel usebenzisa iindlela kwi-Ribbon zifana nokuguqula ububanzi bekholomu.