Lokacin aiki tare da tebur, wani lokaci akwai buƙatar canza ginshiƙan da ke ciki a wurare. Bari mu ga yadda za a yi wannan a cikin Microsoft Excel ba tare da rasa bayanai ba, amma a lokaci guda, kamar yadda sauƙi da sauri kamar yadda zai yiwu.
Ginshiƙai masu juyawa
A cikin Excel, ana iya canza ginshiƙai a hanyoyi da yawa, dukansu suna da wahala kuma suna cigaba.
Hanyar 1: Kwafi
Wannan hanya ita ce ta duniya, kamar yadda ya dace da tsofaffin tsoho na Excel.
- Mun danna kan kowane tantanin sakon da ke gefen hagu wanda muke shirya don matsawa wani shafi. A cikin mahallin mahallin, zaɓi abu "Manna ...".
- Ƙananan taga yana bayyana. Zaɓi ƙimar a ciki "Shafi". Danna kan abu "Ok"bayan haka za'a kara sabon shafi a cikin tebur.
- Mu danna-dama a kan kwamitin kulawa a wurin da sunan mahaɗin da muke son motsawa ya nuna. A cikin mahallin menu, dakatar da zaɓi a kan abu "Kwafi".
- Yi amfani da maballin hagu na hagu don zaɓar shafi da ka ƙirƙiri kafin. A cikin mahallin menu a cikin toshe "Zaɓuɓɓukan Zaɓuka" zabi darajar Manna.
- Bayan an shigar da kewayawa a wuri mai kyau, muna buƙatar share shafin asali. Danna-dama a kan take. A cikin mahallin menu, zaɓi abu "Share".
A wannan motsa za a kammala abubuwa.
Hanyar 2: sakawa
Duk da haka, akwai hanya mafi sauki don matsawa cikin Excel.
- Danna kan rukunin kula da kwance tare da wasika da ke nuna adireshin don zaɓar dukan shafi.
- Mun danna kan yanki da aka zaɓa tare da maɓallin linzamin linzamin dama kuma a cikin jerin budewa mun dakatar da zaɓi akan abu "Yanke". Maimakon haka, za ka iya danna kan gunkin tare da ainihin sunan da ke kan rubutun a cikin shafin "Gida" a cikin asalin kayan aiki "Rubutun allo".
- Kamar yadda aka ambata a sama, zaɓi shafi zuwa hagu wadda za ku buƙaci don motsa shafin da muka yanke a baya. Danna maballin linzamin dama. A cikin mahallin menu, dakatar da zaɓi a kan abu "Saka Yanke Yanke".
Bayan wannan aikin, abubuwa zasu motsa kamar yadda kake so. Idan ya cancanta, a daidai wannan hanya za ka iya motsa ƙungiyoyin rukuni, nuna alama ga wannan jeri na dace.
Hanyar 3: Zaɓin ci gaba mai mahimmanci
Akwai hanya mai sauƙi kuma mafi mahimmanci don motsawa.
- Zaɓi shafi da muke so mu matsa.
- Matsar da siginan kwamfuta zuwa iyakar yankin da aka zaɓa. A lokaci guda mun matsa Canji a kan maɓallin linzamin kwamfuta da hagu. Matsar da linzamin kwamfuta a gefen wurin da kake son motsa shafin.
- A lokacin tafiye-tafiye, halayyar halayyar tsakanin ginshiƙan suna nuna inda za a saka abin da aka zaɓa. Bayan layin yana cikin wuri mai kyau, kawai saki maɓallin linzamin kwamfuta.
Bayan haka, za'a cire sassan da ake bukata.
Hankali! Idan kana amfani da tsohon version of Excel (2007 da baya), to, Canji Babu buƙatar matsawa yayin motsi.
Kamar yadda kake gani, akwai hanyoyi da dama don sakin ginshiƙai. Akwai duka masu aiki, amma a lokaci guda zaɓuɓɓuka na duniya don aiki, da kuma waɗanda suka fi dacewa, wanda, duk da haka, ba koyaushe suna aiki a kan tsofaffin ɗigo na Excel ba.
