Contents
Excel yana ba ku damar kwafin zanen gado da aka riga aka ƙirƙira, motsa su duka a ciki da wajen littafin aiki na yanzu, da canza launi na shafuka don sauƙaƙe kewayawa tsakanin su. A cikin wannan darasi, za mu bincika duk waɗannan fasalulluka dalla-dalla yadda zai yiwu kuma mu koyi yadda ake kwafi, motsawa da canza launin zanen gado a cikin Excel.
Kwafi zanen gado a cikin Excel
Idan kuna buƙatar kwafin abun ciki daga wannan takarda zuwa wancan, Excel yana ba ku damar ƙirƙirar kwafin zanen gado.
- Danna dama akan shafin takardar da kake son kwafa, kuma daga menu na mahallin zaɓi Matsar ko kwafi.
- Akwatin maganganu zai buɗe Matsar ko kwafi. Anan zaka iya tantance kafin wace takardar da kake son saka takardar da aka kwafi. A cikin yanayinmu, za mu ƙayyade Matsa zuwa ƙaredon sanya takardar zuwa dama na takardar da ke akwai.
- Zaɓi akwati Ƙirƙiri kwafisa'an nan kuma danna OK.
- Za a kwafi takardar. Zai kasance yana da daidai suna ɗaya da ainihin takardar, da lambar sigar. A cikin yanayinmu, mun kwafi takardar da sunan Janairu, don haka za a kira sabon takardar Janairu (2). Duk abinda ke cikin takardar Janairu Hakanan za a kwafi zuwa takardar Janairu (2).
Kuna iya kwafin takarda zuwa kowane littafin aikin Excel, muddin yana buɗewa a halin yanzu. Kuna iya zaɓar littafin da ake buƙata daga jerin abubuwan da aka saukar a cikin akwatin maganganu. Matsar ko kwafi.
Matsar da takarda a cikin Excel
Wani lokaci ya zama dole don matsar da takarda a cikin Excel don canza tsarin littafin aiki.
- Danna kan shafin takardar da kake son motsawa. Siginan kwamfuta zai juya zuwa ƙaramin gunkin takarda.
- Riƙe ƙasa linzamin kwamfuta kuma ja gunkin takardar har sai ƙaramin kibiya baƙar fata ta bayyana a wurin da ake so.
- Saki maɓallin linzamin kwamfuta. Za a motsa takardar.
Canja launi shafi a cikin Excel
Kuna iya canza launi na shafukan aikin don tsara su da sauƙaƙe don kewaya littafin aikin Excel.
- Danna-dama akan shafin aikin da ake so kuma zaɓi abu daga menu na mahallin Launin lakabi. Mai Zabin Launi zai buɗe.
- Zaɓi launi da ake so. Lokacin shawagi akan zaɓuɓɓuka daban-daban, samfoti zai bayyana. A cikin misalinmu, za mu zaɓi ja.
- Launin alamar zai canza.
Lokacin da aka zaɓi takardar, launi na shafin ya kusan ganuwa. Yi ƙoƙarin zaɓar kowane takarda a cikin littafin aikin Excel kuma nan da nan za ku ga yadda launi ke canzawa.