Sarudzo 1. Nemaoko
Ngatiti iwe une chati inotevera, yakavakirwa pahunhu hwekutanga koramu yetafura (Moscow):
Basa nderekukurumidza kuwedzera imwe data kwairi pasina kudzoreredza dhayagiramu (Samara).
Zvese zvine hungwaru, semazuva ese, zviri nyore: sarudza koramu ine data nyowani (D1: D7), ikope kune clipboard (CTRL + C), sarudza chati uye unamate iyo data kubva pa clipboard (CTRL + V). MuExcel 2003 nevakuru, kudhonza (!) Rudzi rwakasarudzwa negonzo munzvimbo yechati inoshandawo. Nyore uye yakanaka, handiti?
Kana kuiswa kwacho kusina kuitika sezvawaida kana kuti unoda kuisa kwete mutsara mutsva une data (guta idzva), asi kuenderera mberi kweiyo iripo (somuenzaniso, data yehafu yechipiri yegore yeMoscow imwe chete. ), ipapo panzvimbo peyakajairwa kuisa, unogona kushandisa yakakosha nekudzvanya CTRL+ALT+V kana kushandisa bhatani rekudonha. Insert (Namira) Tab Home (Musha):
Sarudzo 2. Zvakakwana otomatiki
Kana iwe uine Excel 2007 kana gare gare, wobva wawedzera data nyowani kune chati, iwe unofanirwa kuita hushoma hwezviito - zivisa huwandu hwedhata yechati seTafura pamberi. Izvi zvinogona kuitwa pane tab. Home (Musha) kushandisa bhatani Fomati setafura (Format as Table):
Zvino, kana uchiwedzera mitsara mitsva kana makoramu patafura, hukuru hwayo huchagadziridzwa otomatiki uye, semhedzisiro, mitsva mitsara uye mitsara zvinhu zvinowira muchati panhunzi, pasina kumwezve kuedza kwauri. Automation!
- Smart Spreadsheets Excel 2007/2010