Ɓoye da Sauke Wurin Shafi a Excel

01 na 05

Game da Ayyuka na Excel Hidden

Kayan aiki na Excel shine lakabin rubutu guda ɗaya wanda ya ƙunshi sel. Kowane tantanin halitta zai iya riƙe rubutu, lamba, ko wata ƙira, kuma kowace tantanin halitta zai iya ɗauka tantanin tantanin halitta a kan takardun aiki ɗaya, ɗayan littafi ɗaya, ko wani littafi na daban.

Littafin littafin Excel ya ƙunshi ɗaya ko fiye da ɗawainiya. Ta hanyar tsoho, duk takardun aikin Excel na budewa sun nuna shafuka masu aiki a kan tashar aiki a kasan allon, amma zaka iya boye ko nuna su kamar yadda ake bukata. Akalla guda ɗaya aikin aiki dole ne a bayyane a kowane lokaci.

Akwai hanyoyi fiye da ɗaya don ɓoye da kuma ɓoye takardun aiki na Excel. Za ka iya:

• Yi amfani da maɓallin dama na dannawa-dama.
• Yi amfani da Zaɓuɓɓukan Fayil a kan shafin shafin shafin rubutun .

Amfani da Bayanai a Abubuwan Hidimar Hidden

Ba'a share bayanan da ke cikin shafukan da aka ɓoye ba, kuma za'a iya rubuta shi a cikin matakan da shafukan da aka samo a kan sauran takardun aiki ko wasu littattafan aiki .

Hannun da aka ɓoye da ke dauke da bayanan salula ya sake sabuntawa idan bayanan da ke cikin ƙwayoyin da aka ambata.

02 na 05

Ɓoye Ɗaukar Hanya na Excel Yin Amfani da Menu Abubuwa

Zaɓuɓɓukan da aka samo a cikin menu na al'ada-ko sauƙi dama-menu-canji dangane da abin da aka zaba lokacin da aka bude menu.

Idan Ɓoye Sakamakon yana aiki ko ƙurewa, mai yiwuwa littafi na yanzu yana da takarda ɗaya kawai. Excel ta share Aikin Kulle don takardun littattafai guda ɗaya saboda dole ne a kasance a kalla ɗaya takarda aiki a bayyane a cikin takarda.

Don boye samfurin rubutu guda ɗaya

1. Danna kan takardun aiki shafin na takardar da za a boye don zaɓar shi.
2. Danna-dama a shafin shafukan yanar gizo don buɗe menu na al'ada.
3. A cikin menu, danna kan Zaɓin Hide don ɓoye aikin ɗawainiya da aka zaɓa.

Don boye Kayan Shafi

1. Danna maɓallin shafin aikin farko da za a boye don zaɓar shi.
2. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
3. Danna kan shafuka na ƙarin ɗawainiya don zaɓar su.
4. Danna-dama a kan shafin ɗawainiya don bude menu na al'ada.
5. A cikin menu, danna kan Abun Zabuna don ɓoye duk ɗawainiya da aka zaɓa.

03 na 05

Ɓoye Saitunan Taimako Amfani da Ribbon

Excel ba shi da gajerar hanyar keyboard don ɓoye takardun aiki, amma zaka iya amfani da rubutun don yin aikin.

1. Zaɓi shafin ɗawainiya a kasan fayil na Excel.
2. Danna shafin shafin a kan rubutun kuma zaɓi gunkin salula.
3. Zaɓi Yaɗa a cikin menu mai saukarwa wanda ya bayyana.
4. Danna kan Hide & Unhide .
5. Zaɓi Ɗoye Takarda .

04 na 05

Haɗa takardar aikin Excel ta amfani da Menu Abubuwa

Zaɓuɓɓukan da aka samo a cikin menu na al'ada-ko sauƙi dama-menu-canji dangane da abin da aka zaba lokacin da aka bude menu.

Don Ƙaddamar da Ƙamus ɗin Ɗaya

1. Danna-dama a kan shafin yanar gizon aiki don buɗe akwatin maganganun Unhide , wanda ke nuna duk ɓoyayyen zane na yanzu.
2. Danna kan takardar don zama marar kuskure.
3. Danna Ya yi don ya buɗe takardun da aka zaɓa kuma don rufe akwatin maganganu.

05 na 05

Haɗa takardun aiki tare da amfani da Ribbon

Kamar yadda yake a ɓoye takardun aiki, Excel ba shi da wani gajeren hanya na keyboard don buɗe aikin aiki, amma zaka iya amfani da kintinkiri don gano wuri da kuma bayyana fayilolin ɓoyayyen ɓoye.

1. Zaɓi shafin ɗawainiya a kasan fayil na Excel.
2. Danna shafin shafin a kan rubutun kuma zaɓi gunkin salula.
3. Zaɓi Yaɗa a cikin menu mai saukarwa wanda ya bayyana.
4. Danna kan Hide & Unhide .
5. Zaɓi Takardar Saya .
6. Duba jerin fayilolin ɓoyayyen da suka bayyana. Danna kan fayil ɗin da kake so ka aika.
7. Danna Ya yi .