Ta hanyar layuka a cikin Excel. Yadda ake yin da kuma duba ta cikin layi a cikin Excel

Lokacin da tebur a cikin Excel ya yi tsawo kuma akwai bayanai da yawa a ciki, za ku iya amfani da aikin da aka gina a cikin shirin wanda ke nuna rubutun tebur akan kowane shafukan. Wannan gaskiya ne musamman lokacin buga bayanai masu yawa. Ana kiran irin wannan aikin ta hanyar layi.

Menene hanyar layi?

Idan kuna buƙatar buga babban adadin zanen gado, to sau da yawa akwai buƙatar taken ko taken guda ɗaya akan kowane shafi. Gyara wannan bayanan a cikin maƙunsar bayanai na Excel shine ta hanyar layi. Wannan fasalin ba wai kawai yana rage yawan aikin ba, amma kuma yana taimakawa wajen sa ƙirar shafin ya fi kyau.. Bayan haka, godiya ga ta hanyar layi yana yiwuwa a yi alama zanen gado cikin sauƙi.

Yadda za a yi ta hanyar layi?

Don kada a yi irin wannan aikin mai ɗorewa da hannu kamar shigar da bayanai iri ɗaya a sassa daban-daban na takaddar, an ƙirƙiri aiki mai dacewa - ta hanyar layi. Yanzu, tare da dannawa ɗaya kawai, zaku iya ƙirƙirar taken guda ɗaya da taken, sa hannu ko alamar shafi akan kowace takarda, da sauransu.

Kula! Akwai bambance-bambancen ta hanyar layi, wanda aka gyara akan allo, amma a cikin bugawa ana sake bugawa sau ɗaya kawai a kowane shafi. A wannan yanayin, ana iya gungurawa daftarin aiki a cikin shirin. Kuma akwai aikin ta hanyar layi, wanda za'a iya nunawa akan kowane shafi a cikin nau'i na kan kai adadin lokuta da aka zaɓa. Wannan labarin zai yi la'akari da zaɓi na ƙarshe.

Abubuwan amfani ta hanyar layi suna bayyane, saboda tare da taimakon su za ku iya rage yawan lokutan aiki a kwamfutar, yayin da kuke samun sakamakon da ake so. Don yin layi daga ƙarshe zuwa ƙarshe, yana da mahimmanci a bi wasu jerin ayyuka, wato:

  1. Je zuwa taken Excel a cikin sashin "Layout Shafi", zaɓi "Buga masu kai" da "Saitunan Shafi".
Ta hanyar layuka a cikin Excel. Yadda ake yin da kuma duba ta cikin layi a cikin Excel
Sashen Tsarin Shafi

Yana da muhimmanci a sani! Idan babu na'ura mai bugawa da kuma kan aiwatar da gyaran sel, wannan saitin ba zai kasance ba.

  1. Bayan abin "Page Setup" ya bayyana a cikin aikin, kuna buƙatar zuwa gare ta kuma danna shafin "Sheet" tare da linzamin kwamfuta, kamar yadda aka nuna a cikin hoton. A cikin wannan taga, aikin "Ta hanyar layi" ya riga ya gani. Danna filin shigarwa.
Ta hanyar layuka a cikin Excel. Yadda ake yin da kuma duba ta cikin layi a cikin Excel
Sashe "Sheet" da "Ta Lines"
  1. Sa'an nan kuma ya kamata ka zaɓi waɗannan layin a cikin farantin da ake buƙatar gyarawa. Kuna buƙatar zaɓar hanyar layi a kwance. Hakanan zaka iya shigar da lambar layi da hannu.
  2. A ƙarshen zaɓin, danna maɓallin "Ok".

Yadda za a duba ta layuka?

Duba wannan fasalin a cikin tebur kuma yana da mahimmanci. Domin kada a lalata manyan kundin takardu, za mu gudanar da bincike na ƙarshe. Don yin wannan, bi wannan jerin ayyuka:

  1. Da farko, je zuwa sashin "Fayil", wanda ke cikin taken tebur a kusurwar hagu. Sa'an nan kuma danna maɓallin "Print", wanda za'a iya gani a hoto na 2.
  2. Za a buɗe samfotin daftarin aiki a gefen dama, inda zaku iya duba yarda da ƙayyadaddun sigogi. Gungura cikin duk shafuka kuma tabbatar da layin da aka kirkira a baya daidai ne.
Ta hanyar layuka a cikin Excel. Yadda ake yin da kuma duba ta cikin layi a cikin Excel
Don tabbatar da cewa ayyukan da aka yi daidai ne, zaku iya samfoti da takaddun ƙarshe
  1. Don zuwa takarda na gaba, kawai danna kan gungurawa a gefen dama. Hakanan zaka iya yin wannan tare da dabaran linzamin kwamfuta.

Kamar ta cikin layuka, zaku iya daskare takamaiman ginshiƙai a cikin takaddar. An saita wannan siga a daidai matakin da layin layi, maki ɗaya kawai ƙasa, kamar yadda aka nuna a hoto 2.

Kammalawa

A cikin na'ura mai kwakwalwa na Excel, hadaddun ya zama mai sauƙi, kuma irin wannan dogon aiki kamar kwafin take ko taken shafi da canja wurin shi ga wasu yana da sauƙin sarrafa kansa. Yin ta hanyar layi yana da sauri da sauƙi, kawai bi umarnin da ke sama.

Leave a Reply