Ɓoye da Bayyana ginshiƙai, Layuka, da salula a Excel

Kuna son koyon yadda za a ɓoye ko ɓoye ginshiƙai a Microsoft Excel? Wannan taƙaitaccen taƙaitaccen bayani yana bayyana duk matakan da kake buƙatar bi don wannan aiki, musamman:

1. Ɓoye ginshiƙai
2. Nuna ko Ƙunƙidar ginshiƙai
3. Yadda za a boye Hoto
4. Nuna ko Rigar Layuka

01 na 04

Ɓoye ginshiƙai a cikin Excel

Kwayoyin mutum guda baza a boye a cikin Excel ba. Don ɓoye bayanai da ke cikin sel guda ɗaya, ko dai kowane shafi ko jeri da tantanin halitta ya kasance a ɓoye.

Bayanai na ɓoyewa da ɓoyewa da layuka suna samuwa akan shafuka masu biyowa:

1. Ɓoye ginshikan - duba a kasa;
2. Ƙungiyoyin Unhide - ciki har da Column A;
3. Ɓoye Hoto;
4. Rukunin Unhide - ciki har da Row 1.

Hanyar da aka rufe

Kamar yadda a cikin dukkan shirye-shiryen Microsoft, akwai hanyoyin da za a iya aiwatar da ɗawainiya fiye da ɗaya. Umurni a cikin wannan koyaswar ya rufe hanyoyi uku don boye da kuma ɓoye ginshiƙai da layuka a cikin takardar aikin Excel :

• ta amfani da gajeren hanya na keyboard,
• ta amfani da madaidaicin menu na mahallin
• ta amfani da zaɓuɓɓukan tsari a kan shafin shafin shafin rubutun

Amfani da Bayanai a ginshiƙai da Rukunai

Lokacin da ginshiƙai da layukan da ke dauke da bayanan sun ɓoye, ba a share bayanan ba kuma ana iya rubuta shi a cikin matakan da sigogi.

Abubuwan da aka ɓoye da ke dauke da bayanan salula zasu sake sabunta idan bayanai a cikin Kwayoyin da aka ambata.

1. Ɓoye ginshiƙai Amfani da maɓallin Ƙunƙwasa

Maɓallin maɓallin keyboard na haɗin ginshiƙai shine:

Ctrl + 0 (zero)

Don Boye Ƙungiya mai Sauƙi Yin Amfani da Maɓallin Maɓalli Keyboard

1. Danna kan tantanin halitta a cikin shafi da za a boye don sa shi tantanin halitta mai aiki.
2. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
3. Latsa kuma saki "0" ba tare da yada maɓallin Ctrl ba .
4. Gurbin da ke ƙunshe da tantanin halitta tare da duk bayanan da ya ƙunshi ya kamata a ɓoye daga gani.

• Don ɓoye ginshiƙai da yawa ta yin amfani da gajeren hanya na keyboard, haskaka akalla salula ɗaya a cikin kowane shafi da za a boye, sannan kuma maimaita matakai 2 da 3 a sama.

2. Ɓoye ginshiƙai Amfani da Menu Abubuwa

Zaɓuɓɓukan da aka samo a cikin mahallin mahallin - ko menu na dama-click - canza dangane da abin da aka zaba lokacin da aka bude menu.

Idan zabin Hide , kamar yadda aka nuna a cikin hoton da ke sama, ba a samuwa a cikin mahallin mahallin yana iya yiwuwa ba a zabi kowane shafi ba lokacin da aka buɗe menu.

Don Boye Kwancen Yanayi

1. Danna kan rubutun shafi na shafi da za a boye don zaɓar dukan shafi.
2. Dama dama a kan mahallin da aka zaba don buɗe menu mahallin.
3. Zaɓi Huna daga menu.
4. Shafin da aka zaba, da wasika, kuma duk bayanan da ke cikin shafi za a ɓoye daga gani.

Don boye ginshiƙai masu kusa

Alal misali, kana so ka ɓoye ginshiƙai C, D, da E.

1. A cikin rubutun shafi, danna kuma ja tare da maɓallin linzamin kwamfuta don nuna alama ga ginshiƙai uku.
2. Dama a kan ginshiƙan da aka zaba.
3. Zaɓi Huna daga menu.
4. Za'a ɓoye ginshiƙai da ginshiƙan da aka zaɓa daga ra'ayi.

Don boye ginshiƙai da aka raba

Alal misali, kana so ka boye ginshiƙai B, D, da F

1. A cikin maɓallin shafi na danna kan shafi na farko da za a boye.
2. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
3. Ci gaba da rike maballin Ctrl kuma danna sau ɗaya akan kowane ƙarin shafi don a ɓoye don zaɓar su.
4. Saki da maɓallin Ctrl .
5. A cikin rubutun shafi, dama danna kan ɗaya daga cikin ginshiƙai da aka zaba.
6. Zaɓi Huna daga menu.
7. Za'a ɓoye ginshiƙai da ginshiƙan da aka zaɓa daga ra'ayi.

Lura : Lokacin da kake ɓoye ginshiƙai dabam-dabam, idan maɓallin linzamin kwamfuta ba a kan maɓallin ginin ba lokacin da aka danna maɓallin linzamin maɓallin dama, ba a samo wani zaɓi ɓoye ba.

02 na 04

Nuna ko Gidan Bayani a Excel

1. Sauka Shafin A Amfani da Akwatin Akwatin

Wannan hanya za a iya amfani dasu don cire wani shafi ɗaya - ba kawai shafi na A.

1. Rubuta tantanin salula ta A1 a cikin akwatin akwatin .
2. Latsa maɓallin shigarwa a kan maɓallin keɓaɓɓen don zaɓar mahaɗin da aka ɓoye.
3. Danna kan shafin shafin shafin rubutun .
4. Danna gunkin Tsarin kan rubutun don buɗe jerin menu na saukewa.
5. A cikin ɓangaren Ganuwa na menu, zaɓi Ɓoye & Unhide> Sanya Shafin.
6. Shafin A Za a bayyane.

2. Sanya Shafin Farko A Amfani da Makullin Hanya

Wannan hanya za a iya amfani dashi don bayyana kowane shafi daya - ba kawai shafi na A.

Babban haɗin haɗin ginshiƙai shine:

Ctrl + Shift + 0 (sifilin)

Don Sanya Shafin Farko A Amfani da Hanyoyin Hanya da Akwatin Akwatin

1. Rubuta tantanin salula ta A1 a cikin akwatin akwatin.
2. Latsa maɓallin shigarwa a kan maɓallin keɓaɓɓen don zaɓar mahaɗin da aka ɓoye.
3. Latsa ka riƙe ƙasa da Ctrl da maɓallin Shift a kan keyboard.
4. Latsa kuma saki maɓallin "0" ba tare da yada maɓallin Ctrl da Shift .
5. Shafin A Za a bayyane.

Don ƙaddamar da ɗaya ko fiye da ginshiƙai ta yin amfani da maɓallin gajerar hanya

Don buɗe ɗaya ko fiye da ginshiƙai, haskaka akalla salula ɗaya a cikin ginshiƙai a kowane gefen ɓangaren boye tare da maɓallin linzamin kwamfuta.

Alal misali, kana so ka cire ginshiƙan B, D, da F:

1. Don cire dukkanin ginshiƙai, danna kuma ja tare da linzamin kwamfuta don haskaka ginshiƙan A zuwa G.
2. Latsa ka riƙe ƙasa da Ctrl da maɓallin Shift a kan keyboard.
3. Latsa kuma saki maɓallin "0" ba tare da yada maɓallin Ctrl da Shift .
4. Shafin (s) boye zai zama bayyane.

3. Bayyana Ginshiƙai Masu Amfani da Menu Abubuwa

Kamar yadda maɓallin hanyar gajeren hanyar da ke sama, dole ne ka zaɓi akalla ɗaya shafi a kowane gefe na ginshiƙan ko ginshiƙai don boye su.

Zuwa Ɗaya Ɗaya daga Ƙungiya ko Ƙari

Alal misali, don buɗe ginshiƙan D, E, da G:

1. Sauke maɓallin linzamin kwamfuta akan shafi na C a cikin rubutun shafi.
2. Latsa kuma ja tare da linzamin kwamfuta don haskaka ginshiƙan C zuwa H don cire dukkan ginshiƙai a lokaci guda.
3. Dama a kan ginshiƙan da aka zaba.
4. Zaɓi Unhide daga menu.
5. Shafin (s) boye zai zama bayyane.

4. Sanya Shafin A a cikin Saurari 97 zuwa 2003

1. Rubuta tantanin salula na A1 a cikin Akwatin Akwati kuma danna maɓallin Shigar da ke keyboard.
2. Danna kan menu Tsarin .
3. Zaɓi Shirin> Sauke cikin menu.
4. Shafin A Za a bayyane.

03 na 04

Yadda za a boye Rukunai a cikin Excel

1. Ɓoye Rukunai ta yin amfani da Hanya Kuskuren

Maɓallin maɓallin kewayawa don ɓoye layuka shine:

Ctrl + 9 (lambar tara)

Don ɓoye Hanya daya ta amfani da Maɓalli Keyboard Shortcut

1. Danna kan tantanin halitta a jere don a ɓoye don sa shi tantanin halitta mai aiki .
2. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
3. Latsa kuma saki "9" ba tare da yada maɓallin Ctrl ba .
4. Jirgin da ke dauke da tantanin halitta mai aiki tare da duk bayanan da ya ƙunshi ya kamata a ɓoye daga gani.

• Don ɓoye layuka da yawa ta amfani da gajeren hanya na keyboard, haskaka akalla salula ɗaya a kowace jere don a boye, sannan kuma maimaita matakai 2 da 3 a sama.

2. Ɓoye Hannuna Amfani da Menu Abubuwa

Zaɓuɓɓukan da aka samo a cikin mahallin mahallin - ko menu na dama-click - canza dangane da abin da aka zaba lokacin da aka bude menu.

Idan zabin Hide , kamar yadda aka nuna a cikin hoton da ke sama, ba a samuwa a cikin mahallin mahallin zai yiwu cewa dukan jere ba a zaba lokacin da aka bude menu ba. Zaɓuɓɓukan Ajiye kawai yana samuwa lokacin da aka zaɓa dukan jere.

Don Kuna Salo ɗaya

1. Danna maɓallin jeri na jere don a ɓoye don zaɓar dukan jeri.
2. Dama dama a kan zaɓin da aka zaɓa don buɗe menu mahallin
3. Zaɓi Huna daga menu.
4. Zaɓin da aka zaɓa, wasika na layi, da duk wani bayanan da ke cikin jere za a ɓoye daga gani.

Don Ɓoye Hakan Kusa

Alal misali, kana so ka boye layuka 3, 4, da 6.

1. A cikin jigo na jere, danna kuma ja tare da maɓallin linzamin kwamfuta don nuna alama ga layuka uku.
2. Dama danna kan layuka da aka zaba.
3. Zaɓi Huna daga menu.
4. Shafuka da aka zaɓa za a ɓoye daga gani.

Don boye Hakan da aka raba

Alal misali, kana so ka ɓoye layuka 2, 4, da 6

1. A cikin jigo na jere, danna kan jere na farko don a boye.
2. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
3. Ci gaba da rike maɓallin Ctrl kuma danna sau ɗaya akan kowane jeri na gaba don a boye don zaɓar su.
4. Dama dama a kan ɗaya daga cikin layuka da aka zaba.
5. Zaɓi Huna daga menu.
6. Shafuka da aka zaɓa za a ɓoye daga gani.

04 04

Nuna ko Raɗaffɗa Rukunai a cikin Excel

1. Gyara Jirgin 1 Amfani da Akwatin Akwatin

Wannan hanya za a iya amfani dasu don bayyana kowane jinsi guda - ba kawai jere 1 ba.

1. Rubuta tantanin salula ta A1 a cikin akwatin akwatin.
2. Latsa maɓallin shigarwa a kan maballin don zaɓar jere na ɓoye.
3. Danna kan shafin shafin shafin rubutun.
4. Danna gunkin Tsarin kan rubutun don buɗe jerin menu na saukewa.
5. A cikin ɓangaren Ganuwa na menu, zaɓi Ɓoye & Sauke> Haɗuwa Haɗin.
6. Hada 1 zai zama bayyane.

2. Sanya Jirgin 1 Amfani da Hanya Gajerun hanyoyi

Wannan hanya za a iya amfani dasu don bayyana duk wani jeri guda - ba kawai jere 1 ba.

Babban haɗin haɗakar layuka shine:

Ctrl + Shift 9 (lambar tara)

Zuwa Lissafin Sawu 1 ta yin amfani da Hoto Gajerun hanyoyi da akwatin Akwati

1. Rubuta tantanin salula ta A1 a cikin akwatin akwatin.
2. Latsa maɓallin shigarwa a kan maballin don zaɓar jere na ɓoye.
3. Latsa ka riƙe ƙasa da Ctrl da maɓallin Shift a kan keyboard.
4. Latsa kuma saki maɓallin digiri na 9 wanda ba tare da saki Ctrl da Shift keys ba.
5. Hada 1 zai zama bayyane.

Don Sanya Ɗaya ɗaya ko Ƙari Rukunin Amfani da Hanya Kulle

Don cire ɗaya ko fiye da layuka, haskaka akalla salula ɗaya a cikin layuka a gefe ɗaya na jere (s) ɓoye tare da maɓallin linzamin kwamfuta.

Alal misali, kana so ka buɗe layi 2, 4, da 6:

1. Don buɗe dukkan layuka, danna kuma ja tare da linzamin kwamfuta don nuna haskaka layuka 1 zuwa 7.
2. Latsa ka riƙe ƙasa da Ctrl da maɓallin Shift a kan keyboard.
3. Latsa kuma saki maɓallin digiri na 9 wanda ba tare da saki Ctrl da Shift keys ba.
4. Sakin da aka ɓoye zai zama bayyane.

3. Sakamakon Rukunin Yin Amfani da Menu Abubuwa

Kamar yadda maɓallin hanyar gajeren hanya a sama, dole ne ka zaɓi akalla jere guda ɗaya a gefe ɗaya na jere ko layuka don ya buɗe su.

Don Kashe Ɗaya ko Ƙari Rukunai Amfani da Menu Abubuwa

Alal misali, don ƙin layuka 3, 4, da 6:

1. Sauke mahaɗin linzamin kwamfuta a kan jere 2 a cikin jigo na jere.
2. Danna kuma ja tare da linzamin kwamfuta don nuna haskaka layuka 2 zuwa 7 don bayyana dukkan layuka a lokaci guda.
3. Dama danna kan layuka da aka zaba.
4. Zaɓi Unhide daga menu.
5. Sakin da aka ɓoye zai zama bayyane.

4. Sanya Lissafi 1 a cikin Excel iri 97 zuwa 2003

1. Rubuta tantanin salula na A1 a cikin Akwatin Akwati kuma danna maɓallin Shigar da ke keyboard.
2. Danna kan menu Tsarin .
3. Zaɓi Layi> Sauke cikin menu.
4. Hada 1 zai zama bayyane.

Har ila yau, ya kamata ka bincika tutorial da suka shafi yadda za ka boye da kuma cire ayyukan aiki a Excel .