Canza Widget Shafuka da Gudun Dama a Excel da Shafukan Lissafin Google

01 na 02

Canza Ƙunan Shafin Kwashe-kwane da Gidan Yanki tare da Mouse

Hanyar da za a shimfiɗa ginshiƙai da kuma canza yankunan tsaunuka

Akwai hanyoyi masu yawa na fadada ginshiƙai a cikin Excel da Google Lissafi. Ana iya samun bayanai game da hanyoyi daban-daban a shafuka masu zuwa:

• Canza Gidaran Kayan Gilashi Kowane Ɗauki ko Gidan Tsaro Ta amfani da Mouse - duba ƙasa
• Canja Ƙunan Shafin Tallafi ko Gudun Dutsen Amfani da Ribbon Zabuka (Excel kawai)

Lura : Ba zai yiwu a canja nisa ko tsawo na tantanin halitta ɗaya ba - dole ne a canza nisa don kowane shafi ko tsawo don jimlar jimla.

Canza Gilashin Ɗaukaka Kayan Mutum tare da Mouse

Matakan da ke ƙasa suna rufe yadda za a canza ginshiƙan ginshiƙai guda ɗaya ta amfani da linzamin kwamfuta. Don haɗa shafi A misali:

1. Sanya maɓallin linzamin kwamfuta a kan iyaka tsakanin ginshiƙai A da B a cikin maɓallin shafi
2. Maɓin zai canza zuwa arrow ta gefe guda biyu kamar yadda aka nuna a hoton da ke sama
3. Latsa ka riƙe ƙasa maballin hagu na hagu kuma ja gefen hagu sau biyu zuwa hannun dama don buɗe shafin A ko zuwa hagu don yin raguwa ta gefe
4. Saki maɓallin linzamin linzamin kwamfuta lokacin da aka isa iyakar da ake so

Maɓallin Kayan Gida na AutoFit Ta Amfani da Mouse

Wata hanya ta kunkuntar ko shimfida ginshiƙai tare da linzamin kwamfuta shine a bar Excel ko Shafukan Rubutun Google Auto Fit da nisa daga cikin shafi zuwa mafi tsawo abin da ke cikin shafi.

Don dogon lokaci, shafi zai yalwata, amma idan shafi ɗin ya ƙunshi abubuwa ne kawai na taƙaice, ɗayan zai kunsa don dacewa da waɗannan abubuwa.

Misali: Canza nisa na shafi na B ta amfani da AutoFit

1. Sanya linzamin linzamin kwamfuta a kan iyakar iyaka tsakanin ginshiƙan B da C a rubutun shafi. Maɓin zai canza zuwa arrow mai kai biyu.

2. Danna sau biyu tare da maɓallin linzamin hagu. Gurbin zai gyara kusassinta ta atomatik don daidaitawa mafi tsawo shigarwa a wannan shafi

Canja Dukkanin Maɓallin Kwashe-kwane a cikin Ɗab'in Shafin Yin amfani da Mouse

Don daidaita duk ɗakunan shafi

1. Danna kan Zaɓi All button a sama da jigo na jere don haskaka duk ginshiƙai a cikin aikin aiki na yanzu.
2. Sanya maɓallin linzamin kwamfuta a kan iyaka tsakanin ginshiƙai A da B a cikin maɓallin shafi
3. Maɓin zai canza zuwa arrow mai kai biyu.
4. Latsa maballin hagu na hagu kuma ja gefen hagu biyu zuwa hannun dama don fadada dukkan ginshiƙai a cikin takarda ko hagu don yin dukkanin ginshiƙai.

Canja Hudun Yanki tare da Mouse

Zaɓuɓɓuka da matakai don canza canje-canje a cikin Excel da Google Rubutun-gizon tare da linzamin kwamfuta daidai yake da canza canje-canjen sashen, sai dai idan ka sanya maɓin linzamin kwamfuta akan layin iyaka tsakanin layuka biyu a cikin jigo a jere maimakon maimakon rubutun shafi.

02 na 02

Canja Width Shafuka Ta amfani da Zabin Rubutun a Excel

Canza Width Shafuka Ta amfani da Zaɓuɓɓukan Ribbon

1. Danna kan tantanin halitta a cikin shafi da kake so ka canza - don fadada ginshiƙai ginshiƙai ya haskaka tantanin halitta a kowanne shafi
2. Danna kan shafin shafin shafin rubutun
3. Danna maɓallin Tsarin don buɗe jerin menu na saukewa
4. To AutoFit cikin shafi (s), zaɓar wannan zaɓi a cikin Sashen Cell Size na menu
5. Don shigar da takamaiman girman girman haruffa, danna kan Zaɓin Width Widget a cikin menu don kawo akwatin kwance na Shafin Farko.
6. A cikin akwatin maganganu shigar da nisa da ake so a cikin hali (nisa tsoho: harufa 8.11)
7. Danna Ya yi don canja ginshiƙan shafi kuma rufe akwatin maganganu

Canja Duk Ƙunan Shafi a cikin Ɗab'in Shafi Ta amfani da Menus

1. Danna kan Zaɓi All button a saman jigo na jere don haskaka duk ginshiƙai a cikin aikin aiki na yanzu.
2. Yi maimaita matakai 5 zuwa 7 a sama don shigar da takamaiman girman ga dukkan ginshiƙai

Yi amfani da masu amfani da kundin Ribbon

Zaɓuɓɓukan da matakan da za a canza canje-canje a cikin Excel ta amfani da zabin a cikin rubutun suna daidai da canza canjen shafi.