Sanannen abu ne cewa a cikin littafin ayyuka na Excel guda ɗaya (fayil) akwai zanen gado uku ta tsohuwa, tsakanin wanda zaku iya canzawa. Don haka, ya yuwu a ƙirƙiri wasu takardu masu alaƙa cikin fayil ɗaya. Amma idan adadin da aka riga aka zayyana irin waɗannan ƙarin shafuka bai isa ba? Bari mu ga yadda za a ƙara sabon abu a cikin Excel.
Hanyoyi don ƙarawa
Yadda za a canza tsakanin zanen gado, yawancin masu amfani sun sani. Don yin wannan, danna ɗaya daga sunayensu, waɗanda ke saman sandar matsayi a cikin ɓangaren hagu na allo.
Amma ba kowa ba ne ya san yadda ake ƙara zanen gado. Wasu masu amfani ba su ma san cewa akwai yiwuwar hakan ba. Bari mu tsara yadda ake yin hakan ta hanyoyi daban-daban.
Hanyar 1: yi amfani da maballin
Zaɓin da aka fi amfani da shi shine amfani da maballin Sanya Sheet. Wannan saboda gaskiyar cewa wannan zaɓi shine mafi ƙwarewar dukkanin samarwa. Maɓallin ƙara yana a saman masalin hali zuwa hagu cikin jerin abubuwan abubuwan da aka rigaya a cikin takaddar.
- Don ƙara takardar, kawai danna maballin da ke sama.
- Sunan sabon takardar nan da nan aka nuna shi a allon sama da matsayin matsayin, kuma mai amfani zai tafi dashi.
Hanyar 2: menu na mahallin
Yana yiwuwa a saka sabon abu ta amfani da mahallin mahallin.
- Mun danna-dama akan kowane zanen gado da ke cikin littafin. A cikin menu na mahallin da ya bayyana, zaɓi "Manna ...".
- Wani sabon taga yana buɗewa. A ciki, muna buƙatar zaɓar ainihin abin da muke so mu saka. Zaɓi abu Sheet. Latsa maballin "Ok".
Bayan haka, za a ƙara sabon takarda a cikin jerin abubuwan da suke kasancewa sama da matsayin matsayin.
Hanyar 3: kayan aiki tef
Wata damar ƙirƙirar sabon takarda ta ƙunshi yin amfani da kayan aikin da aka sanya akan tef.
Kasancewa a cikin shafin "Gida" danna kan gunkin a cikin nau'in alwati mai rikitarwa kusa da maɓallin Manna, wanda aka sanya a kan tef a cikin toshe kayan aiki "Kwayoyin". A cikin menu wanda ya bayyana, zaɓi Sanya Sheet.
Bayan waɗannan matakan, za a saka kashi.
Hanyar 4: Jakanni
Hakanan, don yin wannan aikin, zaku iya amfani da abin da ake kira maɓallan wuta. Kawai buga taken gajeriyar hanya Canji + F11. Ba za a ƙara sabon takarda kawai ba, har ma ya zama mai aiki. Wato, nan da nan bayan ƙara mai amfani zai canza ta atomatik.
Darasi: Babban hotkeys
Kamar yadda kake gani, akwai zaɓuɓɓuka huɗu gaba ɗaya daban daban don ƙara sabon takarda a littafin Excel. Kowane mai amfani yana zaɓar hanyar da ta fi dacewa a gare shi, tunda babu bambancin aiki tsakanin zaɓukan. Tabbas, yana da sauri kuma mafi dacewa don amfani da maɓallan zafi don waɗannan dalilai, amma ba kowa bane zai iya kiyaye haɗuwa a cikin kawunansu, sabili da haka yawancin masu amfani suna amfani da ƙarin hanyoyin ƙwarewa don ƙarawa.
