Ƙara sabon shafi a cikin Excel

Duk wanda ya fara aiki a Excel, da farko, yakamata ya koyi yadda ake ƙara ƙarin ginshiƙai zuwa teburin da aka gyara. Idan ba tare da wannan ilimin ba, zai zama da wahala ko ma ba zai yiwu ba a ci gaba da aiki tare da bayanan tambura da ƙara sabbin bayanai a cikin littafin.

Ƙara sabon shafi

Excel yana ba da hanyoyi da yawa don saka ƙarin shafi a cikin filin aiki. Yawancin waɗannan hanyoyin ba za su haifar da matsala ba, amma mafari wanda ya buɗe shirin a karon farko zai ɗauki ɗan lokaci kaɗan don gano komai. Don haka, bari mu kalli jerin ayyuka na kowace hanya.

Hanyar 1. Shigar da shafi ta hanyar haɗin kai

Ana ɗaukar wannan hanya mafi sauƙi don ƙara duka sabon shafi da jere zuwa tebur. Ga abin da kuke buƙatar yi don wannan:

1. A kan sashin daidaitawa a kwance, danna sunan shafi na hagu wanda kuke shirin ƙara sabo. Idan an yi daidai, za a zaɓi dukkan ginshiƙi tare da take.
2. Yanzu danna-dama akan kowane wuri a cikin yankin da aka zaɓa, menu na mahallin zai buɗe, inda muke zaɓar umarnin "Saka".
3. Wannan zai ƙara sabon shafi mara komai a gefen hagu na wanda muka zaɓa a mataki na farko.

Hanyar 2: Ƙara Rukunin Yin Amfani da Menu na Yanayin Halitta

Anan zaka buƙaci amfani da menu na mahallin, amma a wannan yanayin, ba duka ginshiƙan da aka zaɓa ba, amma tantanin halitta ɗaya kawai.

1. Je zuwa tantanin halitta (danna shi ko amfani da kiban da ke kan madannai), zuwa hagu wanda muke shirin saka sabon shafi.
2. Danna-dama akan wannan tantanin halitta, kuma a cikin mahallin mahallin da ke buɗewa, danna kan umarnin “Saka…”.
3. Wani ƙaramin taga mai taimako zai buɗe, inda za ku buƙaci zaɓar ainihin abin da ake buƙatar sakawa a cikin tebur: sel, jere ko shafi. Bisa ga aikinmu, mun sanya alama a gaban abu "Shafi" kuma tabbatar da aikin ta latsa maɓallin OK.
4. Shafi mara komai zai bayyana a gefen hagu na tantanin halitta da aka zaɓa da farko, kuma za mu iya fara cika shi da mahimman bayanai.

Hanyar 3: Manna ta amfani da kayan aikin akan kintinkiri

Akwai maɓalli na musamman akan babban ribbon na Excel wanda ke ba ka damar saka ƙarin shafi a cikin tebur.

1. Kamar yadda yake a hanyar da ta gabata, zaɓi tantanin halitta da ake so. Wani sabon shafi bayan bin matakan da ke ƙasa zai bayyana a hagunsa.
2. Danna gunkin tare da hoton triangle mai jujjuyawa kusa da maballin "Saka", kasancewa a cikin tab "Gida". A cikin jerin zaɓuka, danna kan zaɓi "Saka ginshiƙai akan takarda".
3. Duk a shirye. Ana ƙara sabon shafi zuwa gefen hagu na tantanin halitta da aka zaɓa, kamar yadda ake buƙata.

Hanyar 4. Hotkeys don saka sabon shafi

Wata hanyar da ta shahara sosai, musamman a tsakanin gogaggun masu amfani da ita, ita ce danna maballin zafi. Wannan hanyar tana da aikace-aikace guda biyu:

1. Danna sunan ginshiƙi akan kwamitin daidaitawa. Kamar koyaushe, tuna cewa za a saka sabon shafi zuwa hagu na zaɓin da aka zaɓa. Na gaba, danna gajeriyar hanyar madannai Ctrl + "+". Bayan haka, ana ƙara sabon shafi nan da nan zuwa teburin.
2. Muna danna kowane tantanin halitta, ba tare da manta da gaskiyar cewa sabon shafi zai bayyana a gefen hagunsa ba. Sannan danna gajeriyar hanyar keyboard Ctrl + "+".Wani sanannen taga zai bayyana inda kake buƙatar zaɓar nau'in sakawa (sel, jere ko shafi). Kamar yadda a cikin hanya ta biyu, kuna buƙatar zaɓar abu "shafi" sannan tabbatar da aikin ta danna maballin OK.

Saka ginshiƙai biyu ko fiye

Ayyukan saka ƙarin ginshiƙai da yawa a cikin tebur ya cancanci kulawa ta musamman. Godiya ga aikin Excel, babu buƙatar ƙara ginshiƙai ɗaya bayan ɗaya, saboda a cikin wannan yanayin akwai ƙarin zaɓi mai amfani:

1. Da farko, muna zaɓar yawancin sel a kwance (ba kome ba, a cikin tebur kanta ko a kan kwamiti mai daidaitawa), kamar yadda ake shirin saka sabbin ginshiƙai da yawa.
2. Dangane da yadda muka yi zaɓin, muna yin sauran matakai don ƙara ginshiƙai, jagorancin hanyoyin 1-4 da aka bayyana a sama. Misali, a cikin yanayinmu, mun yi zaɓi a kan kwamitin daidaitawa, kuma yanzu mun ƙara sabbin ginshiƙai ta cikin menu na mahallin ta zaɓar abin da ya dace a ciki.
3. Godiya ga ayyukanmu, mun sami nasarar shigar da sabbin ginshiƙai da yawa a cikin tebur zuwa hagu na ainihin kewayon da muka zaɓa.

Saka ginshiƙi a ƙarshen tebur

Duk abin da aka bayyana a sama ya dace don ƙara sabon shafi ko ginshiƙai da yawa a farkon ko a tsakiyar babban tebur. Tabbas, idan kuna son ƙara ginshiƙi daga ƙarshen, zaku iya amfani da hanyoyin iri ɗaya idan kuna so. Amma sai ku ciyar da karin lokaci don tsara abubuwan da aka ƙara.

Don saka sabon ginshiƙi kuma kauce wa ƙarin tsarawa, yana da muhimmanci a yi tebur "mai wayo" daga tebur na yau da kullum. Ga abin da muke yi don wannan:

1. Zaɓi duk sel na tebur. Yadda za a yi wannan - karanta labarinmu "".
2. Canja zuwa shafin "Gida" kuma danna maɓallin "Format a matsayin tebur", wanda ke cikin sashin "Styles".
3. A cikin jerin da ya bayyana, zaɓi salon ƙirar da ya dace don "tebur mai wayo" na gaba kuma danna kan shi.
4. Wani ƙaramin taga zai bayyana wanda a ciki kuna buƙatar tace iyakokin yankin da aka zaɓa. Idan muka zaɓi tebur daidai a matakin farko, babu abin da yake buƙatar taɓawa anan (idan ya cancanta, zamu iya gyara bayanan). Tabbatar cewa akwai alamar bincike kusa da abun "Table tare da kai" danna maɓallin OK.
5. A sakamakon haka, an canza teburin mu na asali zuwa "mai wayo".
6. Yanzu, don ƙara sabon shafi a ƙarshen tebur, kawai cika kowane tantanin halitta zuwa dama na yankin tebur tare da mahimman bayanai. Rukunin da aka cika za ta zama ta atomatik ta zama wani ɓangare na "smart table" tare da kiyaye tsari.

Kammalawa

Microsoft Excel yana ba da hanyoyi da yawa waɗanda zaku iya ƙara sabon shafi a ko'ina cikin tebur (farko, tsakiya, ko ƙarshe). Daga cikin su, wani wuri na musamman yana shagaltar da ƙirƙirar "tebur mai wayo", wanda ke ba ka damar saka sabbin ginshiƙai a cikin tebur ba tare da buƙatar ƙarin tsari ba don kawo su zuwa nau'i na yau da kullun, wanda zai adana lokaci akan sauran. ayyuka masu mahimmanci.