Ukuhlunga ku-Excel

Ku-Excel, ungakwazi ukuhlela idatha ngekholomu eyodwa noma ngaphezulu. Ukuhlunga kungenziwa ngendlela ekhuphukayo noma eyehlayo.

Ikholamu eyodwa

Ukuze uhlunge idatha ngekholomu eyodwa, yenza okulandelayo:

  1. Khetha noma iyiphi iseli kukholamu ofuna ukuhlunga ngayo.
  2. Ukuze uhlunge ngohlelo olukhuphukayo, vula ithebhu Idatha (Idatha) bese uchofoza izithonjana NAMI (THE).Ukuhlunga ku-ExcelUmphumela wokugcina:Ukuhlunga ku-Excel

Qaphela: Ukuze uhlunge ngohlelo olwehlayo, chofoza isithonjana ЯА (KWENZA).

Amakholomu amaningi

Ukuze uhlunge idatha ngamakholomu amaningi, landela lezi zinyathelo:

  1. Kuthebhu ethuthukisiwe Idatha (Idatha) chofoza Ukuhlunga (Hlunga).Ukuhlunga ku-ExcelIbhokisi lengxoxo lizovuleka Ukuhlunga (Hlunga).
  2. Ohlwini olwehliswayo Hlunga nge (Hlunga ngokuthi) khetha ikholomu ozoyihlela ngayo (esibonelweni sethu iyi Isibongo).Ukuhlunga ku-Excel
  3. Chofoza inkinobho Engeza ileveli (Engeza Izinga).
  4. Ohlwini olwehliswayo Bese kuthi by (Bese ngo) khetha ikholomu elandelayo ukuze uyihlele (siyakhetha Sales).Ukuhlunga ku-Excel
  5. Cindezela OK.Umphumela: Amarekhodi ahlelwa ngekholomu kuqala Isibongo, bese kuba ngekholomu Sales.Ukuhlunga ku-Excel

shiya impendulo