Yawancin lokaci, kwayoyin da ke dauke da takaddun a cikin Excel da Google Sheets suna nuna amsoshin tambayoyin da ayyukan da ke cikin takardun aiki .
A cikin manyan takardun aiki, danna kusa da maɓallin linzamin kwamfuta don gano sel da ke dauke da waɗannan ƙwayoyin ko ayyuka na iya zama wani abu mai ban mamaki ko rashin aiki.
Nuna samfurori a cikin Excel da Google Sheets Yin amfani da Hanyoyin Hanya
Cire zane lokacin da aka samo takaddamomi ta amfani da haɗin hanyar gajeren hanya don nuna duk samfurori a cikin Excel da Google Sheets:
Ctrl + `(maɓallin ƙararraƙi)
A kan mafi yawan ma'aunin maɓallin keɓaɓɓun kalmomi, maɓallin ƙararrakin kabari yana kusa da maɓallin lamba 1 a saman hagu na kusurwar keyboard. Yana kama da mai ridda baya.
Wannan haɗin maɓallin yana aiki kamar maɓallin kewayawa, wanda ke nufin ka danna maɓallin haɗin maɗallin don ɓoye dabarar lokacin da ka gama kallon su.
Matakai na Nuna Duk Formulas
- Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
- Latsa kuma saki maɓallin ƙararrawar kabari a kan keyboard ba tare da bari Ctrl ba.
- Saki da maɓallin Ctrl .
Ayyukan aiki ya kamata nuna duk samfurori a cikin fayilolin Ayyukan aiki maimakon ma'anar dabarun.
Sake Ajiye Formulas
Don nuna sakamakon sake a maimakon ma'anar, danna maɓallin Ctrl + keys gaba ɗaya.
About Show Formulas
- Nuna samfurori bazai canja abun ciki na aikin aiki ba, sai dai yadda aka nuna su.
- Nuna samfurori yana sa sauƙin samun sassan dake dauke da siffofi.
- Yana ba ka damar karantawa ta sauri ta hanyar dukkan hanyoyin da za a bincika kurakurai.
- Za'a iya kunna yanayin ta hanyar zaɓar:
- Formulas > Nuna samfurin a kan rubutun a cikin Excel
- Duba > Duk wani zaɓi na Formulas a cikin menus a cikin Google Sheets
- Rubutun aikin bugawa tare da Nuna Formulas ya juya zai iya sauƙaƙe don bincika wuya a sami kurakurai.
Nuna samfurin takardun aiki guda ɗaya
Maimakon kallon dukkanin samfurori, yana yiwuwa a duba ma'anar daya a lokaci kawai ta hanyar:
- Danna sau biyu akan tantanin halitta dauke da tsari da linzamin kwamfuta.
- Danna sau ɗaya akan tantanin halitta dauke da tsari tare da linzamin kwamfuta sa'annan danna maballin F2 akan keyboard.
Duk waɗannan ayyukan sun sa shirin-ko dai Excel ko Google Sheets-a cikin yanayin daidaitawa, wanda ke nuna nau'i a cikin tantanin halitta da kuma ƙayyadaddun launi da aka yi amfani da su a cikin tsarin. Wannan ya sa ya fi sauƙi don gano tushen asusun da aka yi amfani dashi a cikin wani tsari.
Ɓoye Formulas a Amfani da Amfani da Bayanin Tsare
Wani zaɓi don ɓoye siffofi a cikin Excel shine don amfani da kullun aiki , wanda ya haɗa da wani zaɓi don hana ƙwayoyin a cikin ɗakunan kulle daga nunawa a waɗannan wurare:
- A cikin tantanin halitta inda suke
- A cikin wannan tsari lokacin da aka kunna tantanin halitta dake dauke da wata mahimmanci
- Lokacin da nuna Ayyukan Kayan aiki ana amfani da ita ta hanyar amfani da gajeren hanya na keyboard ko ta hanyar rubutun.
Yin amfani da siffofi, kamar kulle kwayoyin halitta, wani mataki ne na biyu wanda ya shafi gano mahaɗin sel da kake son ɓoye sannan kuma amfani da kariya daga aiki.
Zaɓi Siffar Range don Boye
- Zaži kewayon Kwayoyin da ke kunshe da siffofin da za a boye.
- A kan shafin shafin rubutun, danna kan Maɓallin Tsarin don buɗe menu da aka sauke.
- A cikin menu, danna kan Siffofin Siffofin don buɗe akwatin maganganun Siffofin Siffar.
- A cikin akwatin maganganu, danna kan Kariya shafin.
- A kan wannan shafin, zaɓi akwatin akwatin boye .
- Danna Ya yi don amfani da canji kuma rufe akwatin maganganu.
Aiwatar da Kayan aiki na Kayan aiki
- A kan shafin shafin rubutun, danna kan Zaɓin Zabin don buɗe menu da aka sauke.
- Danna Maɓallin Shafin Shafin a kasa na jerin don buɗe akwatin maganganun Tsare-tsare.
- Bincika ko cire abubuwan da ake so.
- Danna Ya yi don amfani da canje-canje kuma rufe akwatin maganganu.
A wannan lokaci, za a ɓoye siffofin da aka zaɓa daga ra'ayi a cikin tsari. Har sai an aiwatar da mataki na biyu, za a iya ganin waɗannan samfurori a cikin siginar aiki da kuma a cikin tsari.