Lokacin aiki tare da tebur, wani lokacin akwai buƙatar musanya ginshiƙan da ke ciki, a wurare. Bari mu ga yadda ake yin wannan a cikin Microsoft Excel ba tare da asarar bayanai ba, amma a lokaci guda mai sauki da sauri.
Motsa ginshikan
A cikin Excel, ana iya canza ginshiƙan hanyoyi da yawa, duka biyu masu ɗaukar nauyin lokaci da ƙarin ci gaba.
Hanyar 1: Kwafa
Wannan hanyar ita ce ta kowa da kowa, kamar yadda ya dace har ma da tsoffin ofa'idodin Excel.
- Mun danna kowane sel a cikin shafi zuwa hagu wanda muke shirin motsa wani shafi. A cikin jerin mahallin, zaɓi "Manna ...".
- Wani karamin taga ya bayyana. Zabi wata daraja a ciki Harafi. Danna kan kayan "Ok", bayan haka za'a ƙara sabon shafi a cikin tebur.
- Mun danna dama-dama kan kwamiti din hadin gwiwar a wurin da aka nuna sunan shafin da muke son motsawa. A cikin menu na mahallin, dakatar da zaɓi akan abu Kwafa.
- Na hagu-danna kan shafin da aka kirkiresu kafin. A cikin mahallin menu a cikin toshe Saka Zabi zaɓi darajar Manna.
- Bayan an sanya kewayon a cikin madaidaitan wuri, muna buƙatar share ainihin shafi. Danna-dama kan taken sa. A cikin mahallin menu, zaɓi Share.
Wannan yana kammala motsin abubuwa.
Hanyar 2: Saka
Koyaya, akwai zaɓi mafi sauƙi don motsawa cikin Excel.
- Mun danna kan kwamiti na daidaituwa tare da wasika wanda ke nuna adireshin domin zabar duk shafin.
- Mun danna kan yankin da aka zaɓa tare da maɓallin linzamin kwamfuta na dama kuma a cikin menu wanda ya buɗe, dakatar da zaɓi akan abu Yanke. Madadin haka, zaku iya danna kan tambarin tare da ainihin sunan iri ɗaya, wanda yake akan kintinkiri a cikin shafin "Gida" a cikin akwatin kayan aiki Clipboard.
- A daidai wannan hanyar kamar yadda aka nuna a sama, zaɓi shafi zuwa hagu wanda zaku buƙaci matsar da shafi wanda muka yanke a baya. Danna dama. A cikin menu na mahallin, dakatar da zaɓi akan abu Manna Cututtuka.
Bayan wannan matakin, abubuwan zasu motsa kamar yadda kuke so. Idan ya cancanta, a cikin hanyar zaka iya motsa rukuni na ginshiƙai, yana nuna adadin da ya dace don wannan.
Hanyar 3: Motsi na Gaba
Akwai kuma hanya mafi sauƙi kuma mafi haɓaka don motsawa.
- Zaɓi shafi da muke son motsawa.
- Matsar da siginan kwamfuta zuwa iyakar yankin da aka zaɓa. Matsa a lokaci guda Canji a maballin linzamin kwamfuta da maɓallin linzamin kwamfuta na hagu. Matsar da linzamin kwamfuta zuwa wurin da kake son motsa shafi.
- Yayin motsawa, layin halayya tsakanin ɓangarorin yana nuna inda za'a saka abun da aka zaɓa. Bayan layi yana kan daidai, kawai kuna buƙatar sakin maɓallin linzamin kwamfuta.
Bayan haka, ginshiƙan da suka wajaba za a canza.
Hankali! Idan kuna amfani da tsohon juzu'i na Excel (2007 da farkon), to mabuɗin Canji bai kamata a dunkule lokacin motsawa ba.
Kamar yadda kake gani, akwai hanyoyi da yawa don canza ginshiƙai. Akwai duka biyun da ke aiki tuƙuru, amma a lokaci ɗaya zaɓin zaɓin na duniya don ayyuka, kazalika da ƙarin ci gaba, wanda, duk da haka, koyaushe, ba koyaushe aiki akan tsofaffin fasalin na Excel ba.
