Inketho 1. Ngokuzenzela
Ake sithi uneshadi elilandelayo, elakhelwe phezu kwamanani ekholomu yokuqala yetafula (eMoscow):
Umsebenzi uwukwengeza ngokushesha idatha eyengeziwe kuwo ngaphandle kokwenza kabusha umdwebo (Samara).
Yonke into ehlakaniphile, njengenjwayelo, ilula: khetha ikholomu enedatha entsha (D1:D7), ikopishele ebhodini lokunamathisela (CTRL + C), khetha ishadi bese unamathisela idatha ebhodini lokunamathisela (CTRL + V). Ku-Excel 2003 nangaphezulu, ukudonsa (!) ububanzi obukhethiwe ngegundane endaweni yeshadi nakho kuyasebenza. Kulula futhi kumnandi, akunjalo?
Uma ukufakwa kungazange kwenzeke ngendlela obufuna ngayo noma ufuna ukufaka hhayi umugqa omusha ngedatha (idolobha elisha), kodwa ukuqhubeka kwalona osuvele ukhona (isibonelo, idatha yengxenye yesibili yonyaka yeMoscow efanayo. ), bese esikhundleni sokufaka okuvamile, ungasebenzisa okukhethekile ngokuchofoza u-CTRL+ALT+V noma usebenzisa inkinobho yokudonsela phansi. Faka (Namathisela) ithebhu Ikhaya (Ikhaya):
Inketho 2. Ngokuzenzakalelayo
Uma une-Excel 2007 noma kamuva, bese ungeza idatha entsha eshadini, udinga ukwenza ubuncane bezenzo - memezela ububanzi bedatha yeshadi njengeThebula kusengaphambili. Lokhu kungenziwa kuthebhu. Ikhaya (Ikhaya) usebenzisa inkinobho Fometha njengetafula (Fometha Njengethebula):
Manje, lapho wengeza imigqa emisha noma amakholomu etafuleni, ubukhulu bayo buzolungiswa ngokuzenzakalelayo futhi, ngenxa yalokho, imigqa emisha nezakhi zomugqa zizowela eshadini ngokundiza, ngaphandle komzamo owengeziwe ohlangothini lwakho. Okuzenzakalelayo!
- AmaSpredishithi Ahlakaniphile Excel 2007/2010