Kodi batani la Merge and Center mu Excel ndi chiyani?
Kodi batani la Merge and Center mu Excel ndi chiyani?
Anonim

Ngakhale palibe chida chothandizira, mutha kudziwanso Phatikizani ndi Center batani mu MicrosoftExcel 2007/2010/2013/2016/2019 Riboni: Dinani Kunyumba tabu;Pitani ku gulu la Kuyanjanitsa; Kenako mudzawona fayilo Phatikizani ndi Center batani Apo.

Chifukwa chake, ndimathandizira bwanji kuphatikiza ndi pakati mu Excel?

Dinani kumanja ndiyeno kusankha "Format Maselo" pa mphukira menyu. Pamene zenera la Format Cells likuwonekera, sankhani tabu ya Kuyanjanitsa. Onani "Gwirizanitsani cell"checkbox.

Pambuyo pake, funso ndilakuti, mumaphatikiza bwanji ma cell mu Excel ndikusunga zolemba zonse? Phatikizani zambiri ndi chizindikiro cha Ampersand (&)

  1. Sankhani selo komwe mukufuna kuyika deta yophatikizidwa.
  2. Lembani = ndikusankha selo loyamba lomwe mukufuna kuphatikiza.
  3. Lembani & ndikugwiritsa ntchito zizindikiro zongobwereza zomwe zili ndi malo otsekedwa.
  4. Sankhani selo lotsatira lomwe mukufuna kuphatikiza ndikudina Enter. Chitsanzochi chikhoza kukhala =A2&" "&B2.

Anthu amafunsanso, mumaphatikizana bwanji pa Microsoft Excel?

Kuphatikiza maselo amaphatikiza maselo awiri kapena angapo kukhala selo limodzi. Kuti muchite izi, sankhani ma cell omwe mukufuna kuphatikiza.Kenako, pa "Home", dinani "Gwirizanitsanindi batani la Center". Monga dzina likunenera, izi zidzaterokuphatikiza maselo osankhidwa.

Kodi mumatsegula bwanji kuphatikiza ma cell mu Excel?

Tsegulani zonse maselo pa pepala. Dinani Ctrl + 1 kuti mutsegule Format Maselo dialog (kapena dinani kumanja zilizonse zomwe zasankhidwa maselo ndi kusankha FormatMaselo kuchokera ku menyu yankhani). Mu Format Maselodialog, sinthani ku tabu ya Chitetezo, osayang'ana Njira Yotsekedwa, ndikudina OK.

Yotchuka ndi mutu