Lokacin aiki tare da dogayen tebur waɗanda ba a sanya a kan allon a tsaye kuma suna da babban adadin ginshiƙai ba, buƙatar yin gungura allon don fitar da saman layi tare da shugabannin da zaiyi lokaci-lokaci. Don dacewa a cikin kyakkyawan shirin, yana yiwuwa a gyara makullin tebur a saman allon don kowane lokaci har sai fayil ɗin yana buɗe. Da ke ƙasa akwai zaɓuɓɓuka don cimma wannan.
Wajibi ne a tabbatar da madaidaicin kirtani kawai.
- A cikin saman sabawa shirin, kuna buƙatar zuwa shafin "kallo" shafin ".
- A cikin sashen "taga" (aka jera sunayen ɓangarorin a ƙarshen layin tef) don nemo abu "shigar da alwatika a sashin dama.
- A cikin jerin da ke buɗe, zaɓi "amintar da manyan kirtani" ta latsa maɓallin linzamin kwamfuta na hagu. Sakamakon zai zama kasancewar dindindin a kan teburin kan teburin tebur, ajiye da bayan rufe fayil ɗin.
Gyara iyakoki a cikin layin da yawa
Idan ana buƙatar layuka da yawa, to aiki ya sha bamban:- A cikin matsanancin hanyar hagu na tebur, danna kan tantanin farko na farkon igiyar da ba wani ɓangare na hula ba. A wannan yanayin, wannan sel ne3.
- Je zuwa shafin "Duba", danna yankin "gyara yankin" kuma a cikin jerin abubuwan da aka katse yankin don "ɗaure yankin". A sakamakon haka, duk layin da ke saman wanda ya mallaki tantanin da aka zaɓa an rubuta shi a saman allon.
"Smart Tebur" - wani zaɓi don ɗaure hat
Wanda ya saba da smart tebur Excelcel zai iya amfani da wani ingantacciyar hanyar da amfani. Gaskiya ne, wannan zaɓi ana amfani dashi ne kawai a yanayin hat-line.
- A kan ribbon tab "Home" haskaka duka tebur.
- A cikin sashe na "salon" sashe (a cikin layin ƙasa na tef), danna kan tsarin "azaman tebur". A taga yana buɗewa tare da tsarin tebur. Yana buƙatar danna maɓallin da ya fi dacewa.
- Tebur ɗin "Tsarin tebur", wanda aka gabatar da iyakokin tebur nan gaba, kuma tebur "yana da tebur" tare da kanun labarai ". Ya kamata ka tabbatar cewa karshen shine kaska.
- Rufe taga ta latsa maɓallin "Ok".
Createirƙiri tebur mai hankali a wata hanyar:
- Bayan zaɓar yankin da ake so, je zuwa akwatin rijble tab ka latsa kayan "tebur".
- A cikin jerin pop-up, danna kan "tebur".
- Bayan bayyanar "ƙirƙirar tebur na" taga yana bayyana tare da taga "Tsarin tebur", kuna buƙatar yin ayyukan da aka riga aka ambata a sama. A ƙarshe, "tebur mai wayo" zai bayyana tare da hula gyarawa a saman.
Yadda Ake buga tebur tare da hula a kowane shafi
Lokacin bugawa da tebur wanda ke mamaye shafuka da yawa, yana da amfani a sami taken a kowane shafi. Wannan yana ba ku damar aiki tare da duk wani shafi da aka buga daban. A cikin shirin Excel, wannan fasalin yana samar da aiwatar da shi kamar haka.
- Je zuwa ribbon tef na kan shafin yanar gizon shafin kuma a cikin shafin "Saitunan Page" (a cikin layin Rod) danna kan taga tare da kibiya zuwa dama na rubutu.
- A cikin sigogin shafin "taga wanda ya buɗe, je zuwa shafin" takardar ".
- Danna kan "Fusk Lines" taga (na biyu a sama).
- Koma zuwa tebur da, matsar da siginan kwamfuta wanda ya ɗauki ra'ayin kibiya kibiya zuwa dama, a kan layi tare da lambobin layi, haskaka kirtani ko kirtani wanda aka samo shi.
- A kan wannan duk ayyukan da aka kammala, duk da haka, ba a bayyana sakamakon su akan allon ba.
Anan ta latsa alwatika a cikin ƙasa layin taga ko gungura ƙafafun linzamin kwamfuta, lokacin da siginar kwamfuta da aka sanya akan shafin kwamfuta, zaku iya duba duk shafukan don bincika hats a kan ɗayansu.
ƙarshe
A Excel, akwai hanyoyi guda biyu da za a nuna a koyaushe a kan iyakokin tebur. Ofayansu ya ƙunshi amfani da saurin yankin, na biyu shine ya juya teburin cikin "Smart" amfani da tsarawa a ciki. Dukkanin hanyoyin duka suna ba da izinin gyara layi ɗaya, amma farkon farkon yana ba shi damar yin tare da hula wanda ya ƙunshi ƙarin layuka. Excel yana da ƙarin dacewa - ikon buga takaddar tare da hula a kowane shafi, wanda, ba shakka, yana ƙara haɓaka aiki tare da shi.
Saƙo Yadda za a gyara kan tebur a Excel. Gyara layin babba, hadaddun hat da ya bayyana da farko ga fasaha.