Yadda ake gyara taken tebur a cikin Excel. Gyaran layin saman, hadadden hula

Lokacin aiki tare da dogayen teburi waɗanda basu dace a tsaye akan allon ba kuma suna da adadi mai yawa na ginshiƙai, lokaci-lokaci ana buƙatar gungurawa allon don nuna saman layi tare da kanun labarai akansa. Don saukakawa, shirin Excel yana ba da damar gyara taken tebur a saman allon don duk lokacin buɗe fayil ɗin. Zaɓuɓɓukan cimma wannan an tattauna su a ƙasa.

Jeri na sama ɗaya kawai yana buƙatar liƙa

1. A cikin babban layi na kintinkiri shirin, je zuwa shafin "Duba".
2. A cikin sashin "Window" (ana nuna sunayen sassan a layin ƙasa na ribbon), nemo abu "Daskare wuraren" kuma danna kan triangle a sashin dama.
3. A cikin jerin da ke buɗewa, zaɓi "Kulle layin saman" ta danna maɓallin linzamin kwamfuta na hagu. Sakamakon zai zama zama na dindindin akan allo na jere na tebur, wanda ke ci gaba ko da bayan an rufe fayil ɗin.
   

   

Haɗa kan kai zuwa layuka da yawa

Idan kuna buƙatar gyara layuka da yawa, to yakamata kuyi aiki daban:

1. A cikin ginshiƙi mafi hagu na tebur, danna kan tantanin halitta na layin farko wanda ba ya cikin taken. A wannan yanayin, shi ne cell A3.
   

   

2. Je zuwa shafin "Duba", danna kan "Daskare Wuraren" kuma zaɓi abu "Daskarewa" daga jerin abubuwan da aka saukar. Sakamakon haka, duk layin da ke sama da wanda aka zaɓa tantanin halitta zai kasance a saman allon.
   

   

"Smart tebur" - wani zaɓi don gyara taken

Idan kun saba da maɓalli masu wayo na Excel, akwai wata hanya mai amfani don saka su. Gaskiya ne, wannan zaɓin yana aiki ne kawai a cikin yanayin taken layi ɗaya kawai.

1. A kan Home shafin na kintinkiri, zaɓi dukan tebur.
2. A cikin sashin "Styles" (a kan layin ƙasa na ribbon), danna abu "Format as Table". Taga mai saitin tsarin tebur zai buɗe. A ciki kana buƙatar danna kan zaɓi mafi dacewa.
   

   

3. Tagar “Table Formatting” ta fito, inda aka nuna iyakoki na tebur na gaba, kuma akwai akwatin rajistan “Table with Headers”. Tabbatar an duba na karshen.
4. Rufe taga ta danna maɓallin "Ok".
   

   

Kuna iya ƙirƙirar "tebur mai wayo" ta wata hanya:

1. Bayan zaɓar yankin da ake so, je zuwa shafin "Saka" ribbon shafin kuma danna abu "Tables".
2. A cikin pop-up list, danna kan "Table" abu.
3. Bayan taga “Create Tebur” ya bayyana tare da abun ciki iri ɗaya da taga “Format Table”, kuna buƙatar bin matakan kama da waɗanda aka riga aka zayyana a sama. A sakamakon haka, "tebur mai wayo" zai kuma bayyana tare da kafaffen hula a saman.
   

   

Yadda ake buga tebur tare da taken kan kowane shafi

Lokacin buga tebur wanda ke ɗaukar shafuka da yawa, yana da amfani a sami taken sa akan kowane shafi. Wannan yana ba ku damar yin aiki tare da kowane shafi da aka buga daban. A cikin Excel, ana ba da wannan yuwuwar kuma ana iya aiwatar da shi kamar haka.

1. Je zuwa shafin "Layout Page" kuma a cikin sashin "Saitunan Shafi" (a kan layin ƙasa na ribbon) danna kan akwatin tare da kibiya zuwa dama na rubutun.
   

   

2. A cikin taga Saitin Shafi da ke buɗewa, je zuwa shafin Sheet.
3. Danna akwatin "Ta hanyar layi" (na biyu daga sama).
4. Koma kan tebur kuma, ta hanyar motsa siginan kwamfuta, wanda ya ɗauki nau'in kibiya mai baƙar fata mai nuni zuwa dama, tare da ginshiƙi tare da lambobin layi, zaɓi layi ko layin da ke cikin tebur ɗin.
   

   

5. A kan wannan, an kammala duk ayyukan, amma ba a nuna sakamakon su akan allon ba.
   

   

Muhimmin! Don tabbatar da cewa an cimma burin, kuna buƙatar zuwa shafin "File" ribbon shafin kuma danna abu "Buga". A cikin taga da ya buɗe, za a nuna nau'in takaddar sakamakon buga ta.

Anan, ta danna kan triangles a cikin layin ƙasa na taga ko ta gungurawa dabaran linzamin kwamfuta, tare da siginan kwamfuta akan shafin tebur, zaku iya duba duk shafuka don bincika kasancewar wani kan kowane ɗayansu.

karshe

A cikin Excel, akwai hanyoyi guda biyu don nuna kan tebur na dindindin akan allo. Ɗaya daga cikinsu ya haɗa da yin amfani da gyaran wuri, na biyu - juya tebur zuwa "mai wayo" ta hanyar tsara wurin da aka zaɓa na saka tebur a ciki. Duk hanyoyin biyu suna ba da damar haɗa layi ɗaya, amma na farko kawai yana ba ku damar yin hakan tare da taken da ya ƙunshi ƙarin layuka.. Har ila yau, Excel yana da ƙarin dacewa - ikon buga takarda tare da rubutun kai a kowane shafi, wanda tabbas yana ƙara ingantaccen aiki tare da shi.