Lokacin aiki a cikin Excel tare da dogayen bayanai da aka saita tare da lambobi masu yawa, yana da matukar wahala a hau kan magana kowane lokaci don ganin ƙimar abubuwan sigogi a sel. Amma, a cikin Excel, yana yiwuwa a gyara babban layin. A lokaci guda, komai girman abin da kake gungura zuwa kewayon bayanai, layin saman koyaushe zai kasance akan allon. Bari mu ga yadda za a iya jera babban layi a Microsoft Excel.
Pin Top Layin
Kodayake, zamuyi la’akari da yadda zamu iya tsara jerin kewayon bayanai ta amfani da misalin Microsoft Excel 2010, amma algorithm ɗin da aka bayyana mana ya dace da yin wannan matakin a cikin sauran sigogin wannan aikace-aikacen na yau.
Don gyara layin sama, je zuwa shafin "Duba" shafin. A kan kintinkiri a cikin kayan aikin taga, danna maɓallin "Maɓallin kulle". Daga menu wanda ya bayyana, zaɓi matsayin "Kulle saman layi".
Bayan wannan, koda kun yanke shawarar sauka zuwa ƙarshen ƙasan bayanan tare da layuka masu yawa, babban layin da sunan bayanan zai kasance koyaushe a gaban idanunku.
Amma, idan kanshin ya kunshi sama da layi daya, to, a wannan yanayin, hanyar da ta gabata na gyara layin sama ba zai yi aiki ba. Dole ne ku yi aikin ta hanyar maɓallin "yankuna yanki", wanda an riga an tattauna a sama, amma a lokaci guda, zaɓi abu "Yankan wuraren" da abun "Daskare yanki", bayan zaɓar ƙirar hagu a ƙarƙashin yankin daskare.
Tsarin layi
Cire babban layin ma abu ne mai sauki. Har yanzu, danna kan maɓallin "Yankunan makullai", kuma daga jeri wanda ya bayyana, zaɓi matsayin "Yankunan yankuna."
Bayan wannan, za a ware babban layin, kuma bayanan ƙarancin zai ɗauki tsari kamar yadda aka saba.
Docking ko saukar da babban layi a Microsoft Excel abu ne mai sauki. Yana da dan kadan mafi wahala a gyara kanshi wanda ya kunshi layuka da yawa a kewayon bayanan, amma kuma ba wuya.
