Zabin 1. Da hannu
A ce kuna da ginshiƙi mai zuwa, wanda aka gina akan ƙimar ginshiƙin farko na tebur (Moscow):
Ayyukan shine don ƙara ƙarin bayanai da sauri zuwa gare shi ba tare da sake ƙirƙirar zane ba (Samara).
Duk abin da ya dace, kamar yadda aka saba, yana da sauƙi: zaɓi ginshiƙi tare da sababbin bayanai (D1: D7), kwafa shi zuwa allon allo (CTRL + C), zaɓi ginshiƙi kuma liƙa bayanan daga allon allo (CTRL + V). A cikin Excel 2003 da kuma tsofaffi, jan (!) kewayon da aka zaɓa tare da linzamin kwamfuta a cikin ginshiƙi yana aiki. Sauƙi kuma mai kyau, daidai?
Idan shigarwar ba ta faru daidai yadda kuke so ba ko kuna son saka sabon layi tare da bayanai (sabon birni), amma ci gaba da kasancewa (misali, bayanai na rabin na biyu na shekara don wannan Moscow). ), to, maimakon shigar da aka saba, zaku iya amfani da na musamman ta danna CTRL+ALT+V ko ta amfani da maɓallin zaɓuka. Saka (Manna) tab Gida (Gida):
Zabin 2. Cikakken atomatik
Idan kuna da Excel 2007 ko kuma daga baya, to, don ƙara sabbin bayanai zuwa ginshiƙi, kuna buƙatar yin mafi ƙarancin ayyuka - ayyana kewayon bayanai don ginshiƙi azaman Tebur a gaba. Ana iya yin wannan a kan shafin. Gida (Gida) amfani da button Tsara azaman tebur (Format as Table):
Yanzu, lokacin ƙara sabbin layuka ko ginshiƙai zuwa teburin, za a daidaita girmansa ta atomatik kuma, sakamakon haka, sabbin layuka da abubuwan jeri za su faɗi cikin ginshiƙi akan tashi, ba tare da wani ƙarin ƙoƙari daga ɓangaren ku ba. Yin aiki da kai!
- Smart Spreadsheets Excel 2007/2010