Sinthani Zowonjezera Zowonjezera ndi Mapiri a Row ku Excel ndi Google Spreadsheets

01 a 02

Sinthani Kukula Kwambiri Pamtunda ndi Mipiri ya Row ndi Mouse

Sinthani Zowonjezera Zamtundu Pogwiritsa Ntchito Mouse. © Ted French

Njira Zowonjezera Mizati ndi Kusintha Mapiri a Mipando

Pali njira zambiri zowonjezera ma Excel ndi Google Spreadsheets. Zomwe mwa njira zosiyanasiyana zingapezeke pamasamba otsatirawa:

Zindikirani : Sizingatheke kusintha kusinthana kapena kutalika kwa selo limodzi - m'lifupilo liyenera kusinthidwa pa khola lonse kapena kutalika kwa mzera wonse.

Sinthani Maulendo Aakulu Amodzi ndi Mouse

Masitepe omwe ali m'munsiwa akuthandizira momwe mungasinthire maulendo apadera pafupipafupi pogwiritsa ntchito mbewa. Kukulitsa ndime A mwachitsanzo:

  1. Ikani pointer ya mbewa pamzere wa malire pakati pa ndime A ndi B mu mutu wa mutuwo
  2. Chojambulacho chidzasintha kuvivi lakuda wakuda monga momwe taonera pa chithunzi pamwambapa
  3. Dinani ndikugwiritsira ntchito batani lamanzere ndi kukokera chingwe chokhala ndi mutu wachiwiri kumanja kuti mukulitse chigawo A kapena kumanzere kuti chigawocho chikhale chochepa
  4. Tulutsani botani la mouse pamene kufupika kwake kukufikira

Gwiritsani Ntchito Zomwe Mukugwiritsa Ntchito Mouse

Njira yina yochepetsera kapena kukulitsa ndondomeko ndi mbewa ndikutulutsa Excel kapena Google Spreadsheets Auto Fit m'lifupi la mndandanda ku chinthu chotalika kwambiri cha deta yomwe ili m'ndandanda.

Kwa deta yaitali, chigawocho chidzafutukuka, koma ngati chigawocho chiri ndi zinthu zochepa chabe za deta, chigawocho chidzapapatiza kuti chikwaniritse zinthu izi.

Chitsanzo: Sinthani kukula kwa chigawo B pogwiritsa ntchito AutoFit

  1. Ikani pointer ya mouse pamzere wa malire pakati pa ndime B ndi C mu mutu wa mutu. Chojambulacho chidzasinthira kuvivi la mutu wawiri.

  2. Dinani kawiri ndi batani lamanzere. Chigawocho chidzasintha m'lifupi mwake kuti chifanane ndizitali kwambiri muzomwelo

Sinthani Zonse Zowonjezera Mzere mu Worksheet Pogwiritsa Ntchito Mouse

Kusintha mbali zonse za m'mbali

  1. Dinani pa Bungwe Lonse Lonse pamwamba pa mutu wa mzere kuti muwonetse zipilala zonse mu tsamba lomwe liripo.
  2. Ikani pointer ya mbewa pamzere wa malire pakati pa ndime A ndi B mu mutu wa mutuwo
  3. Chojambulacho chidzasinthira kuvivi la mutu wawiri.
  4. Dinani batani lamanzere lamanzere ndikukoka chingwe chokhala ndi mutuwu kumanja kuti mukulitse zigawo zonse muzenera kapena kumanzere kuti mapulaneti onse apitirize.

Sinthani Mapiri a Row ndi Mouse

Zosankha ndi masitepe a kusintha masitepe a Excel ndi Google Spreadsheets ndi mouse zimakhala zofanana ndi kusintha masentimita ambiri, pokhapokha mutayika ndondomeko ya mbewa pamzere wa malire pakati pa mizere iwiri pamutu wa mzere m'malo mwa mutu wa mutuwo.

02 a 02

Sinthani Zolemba Zowonjezera Pogwiritsa Ntchito Zokha za Ribbon mu Excel

Kusintha kwa Mphindi Kukula Pogwiritsira Ntchito Zopupuluma. © Ted French

Sintha Zolemba Zowonjezera Pogwiritsira Ntchito Zopangira Mphutsi

  1. Dinani pa selo m'ndandanda yomwe mukufuna kusintha - kukulitsa zikhomo zambiri zimapanga selo m'mbali iliyonse
  2. Dinani pa tabu la Home la riboni
  3. Dinani pa Chithunzi chojambula kuti mutsegule menyu otsika pansi
  4. Kuti mudziwe Zomwe mwasankhazo, sankhani njirayi mu gawo la Cell Size la menyu
  5. Kuti mulowe kukula kwakukulu mu chigawo chamkati, dinani pa Chotsani Chophatikizitsa mu menyu kuti mubweretse bokosi lakulumikiza lazamu
  6. Mu bokosi la bokosilo lowetsani chiwerengero chofunikirako mu chikhalidwe (zosakwanira pazitali: 8.11 zilembo)
  7. Dinani OK kuti musinthe mbali zazikulu zam'mbali ndi kutseka bokosi la dialog

Sinthani Zonse Zamtundu Wambiri M'thumba Labwino Pogwiritsa Ntchito Menus

  1. Dinani pa Bungwe Lonse Lonse pamwamba pa mutu wa mzere kuti muikepozitsa mazenera onse mu tsamba lomwe liri pano.
  2. Bweretsani masitepe 5 mpaka 7 pamwamba kuti muike kukula kwake kwazitsulo zonse

Sinthani Mapiri a Row pogwiritsa ntchito Chingwe cha Ribbon

Zosankha ndi masitepe kuti musinthe mizere yapamwamba mu Excel pogwiritsa ntchito zosankha mu riboni zili zofanana ndi kusintha maulendo ozungulira.