Shintsha Ubukhulu Bamakholomu Nezintaba Zama-Excel nama-Google Spreadsheets

01 ngo-02

Shintsha i-Column Widths ne-Row Heights ne-Mouse

Izindlela Zokukhulisa Amakholomu Nokuguqula Izindonga Zemizila

Kunezindlela eziningi zokukhulisa amakholomu ku-Excel nama-Google Spreadsheets. Ulwazi ngezindlela ezahlukene lungatholakala emakhasini alandelayo:

• Shintsha Amakholomu Omuntu Ngamanye Amakhomitha noma Izintaba Zemizila Ukusebenzisa Umouse - bheka ngezansi
• Shintsha i-Column Widths noma i-Row Heights usebenzisa i-Ribbon Options (Excel kuphela)

Qaphela : Akunakwenzeka ukushintsha ububanzi noma ukuphakama kweseli elilodwa - ububanzi kufanele bushintshwe kuyo yonke ikholomu noma ukuphakama komugqa wonke.

Shintsha Ububanzi Bamakholomu Ngomunye Umouse

Izinyathelo ezingezansi zihlanganisa ukuthi ungashintsha kanjani amakholomu ngamakholomu ngamunye usebenzisa igundane. Ukwandisa ikholomu A njengesibonelo:

1. Beka isikhombisi segundane emgqeni wemingcele phakathi kwamakholomu A no-B kusihlokweni sekholomu
2. I-pointer izoshintshela kumcibisholo omnyama onama-double njengoba kuboniswe esithombeni ngenhla
3. Chofoza bese ubamba inkinobho yegundane lesokunxele bese uhudula umcibisholo ohlosiwe kabili ngakwesokudla ukwandisa ikholomu A noma ngakwesobunxele ukuze wenze ikholomu encane
4. Khipha inkinobho yegundane uma ububanzi obufunayo bufinyelelwa

I-AutoFit Column Widths Ukusebenzisa i-Mouse

Enye indlela yokunciphisa noma yokukhulisa amakholomu negundane ukuvumela i-Excel noma i-Google Spreadsheets ngokuzenzakalela Fit ububanzi bekholomu kwenye into ende kakhulu yedatha equkethwe kukholomu.

Ngedatha ende, ikholomu izokwandisa, kodwa uma ikholomu iqukethe izinto ezincane kuphela zedatha, ikholomu izogxila ukuze ivumelane nalezi zinto.

Isibonelo: Shintsha ububanzi bekholomu B usebenzisa i-AutoFit

1. Beka isikhombisi segundane emgqeni wemingcele phakathi kwamakholomu B no-C kusihlokweni sekholomu. I-pointer izoshintshela kumcibisholo ophethwe kabili.

2. Chofoza kabili inkinobho yegundane lesokunxele. Ikholomu izolungisa ngokuzenzakalelayo ububanzi bayo ukufanisa ukungena okude kunaleyo kukholomu

Shintsha Zonke Ubukhulu Bamakholomu Ekhasini Lokusebenzela usebenzisa i-Mouse

Ukulungisa zonke izinkomba zamakholomu

1. Chofoza inkinobho ethi Khetha Konke ngenhla kwekhanda lomugqa ukuze uqokomise wonke amakholomu kushidi lokusebenza lwamanje.
2. Beka isikhombisi segundane emgqeni wemingcele phakathi kwamakholomu A no-B kusihlokweni sekholomu
3. I-pointer izoshintshela kumcibisholo ophethwe kabili.
4. Chofoza inkinobho yegundane lesokunxele bese uhudula umcibisholo ohlosiwe kabili ngakwesokudla ukuze ukwandise wonke amakholomu kushidi lokusebenzela noma ngakwesobunxele ukwenza wonke amakholomu anciphise.

Shintsha i-Row Heights ne-Mouse

Izinketho kanye nezinyathelo zokushintsha izindawo eziphakeme ze-row e-Excel ne-Google Spreadsheets negundane kufana nokushintsha ububanzi bekholomu, ngaphandle kokuthi ubeka isikhombisi segundane emgqeni womngcele phakathi kwemigqa emibili kusihlokweni selayini esikhundleni sekhanda lekholomu.

02 ka 02

Shintsha Ubukhulu Bamakholomu Ukusebenzisa Izinketho ze-Ribbon ku-Excel

Shintsha Ubukhulu Bamakholomu Ukusebenzisa Izinketho zeRibbon

1. Chofoza kuseli kukholomu ofuna ukushintsha - ukukhulisa amakholomu amaningi agcizelela iseli kukholomu ngayinye
2. Chofoza kuthebhu yaseKhaya ye- ribbon
3. Chofoza kwisithonjana sokufometha ukuze uvule imenyu yehla yezinketho
4. Ukuze wenze ngokuzenzakalelayoFaka ikholomu (ama), khetha leyo nketho kusigaba se-Cell size semenyu
5. Ukufaka usayizi othize ngobubanzi bomlingisi, chofoza ukhetho lokuphakama kwekholomu kwimenyu ukukhuphula ibhokisi lengxoxo yebhola lekholomu
6. Ebhokisini lengxoxo faka ububanzi obufunayo kumlingisi (ububanzi obuzenzakalelayo: izinhlamvu ezingu-8.11)
7. Chofoza OK ukushintsha ububanzi bekholomu bese uvale ibhokisi lengxoxo

Shintsha Zonke Ubukhulu Bamakholomu Ekhasini Lokusebenzela Ukusebenzisa Amamenyu

1. Chofoza inkinobho ethi Khetha Konke phezulu kwe- header yomugqa ukuze uqokomise wonke amakholomu kushidi lokusebenza lwamanje.
2. Phinda izinyathelo ezingu-5 ukuya ku-7 ngenhla ukufaka usayizi othize wazo zonke izinsika

Shintsha i-Row Heights usebenzisa i-Ribbon Options

Izinketho nezinyathelo zokushintsha izindawo eziphakeme ze-row e-Excel ngokusebenzisa izinketho ku-riboni kufana nokushintsha ukuphakama kwamakholomu.