01 ye 05
Nezvakavanzika Excel Worksheets
An Excel worksheet ispreadsheet imwe ine masero. Sero rega rega rinogona kubata mutsara, nhamba, kana chirevo, uye rimwe nerimwe rinogona kutarisa sero rakasiyana pane rimwe bhuku rimwe chete, bhuku rimwechete, kana rimwe bhuku rebhuku.
Bhuku rebazi re Excel rine rimwe kana mamwe mapepa ebasa. Nokusingaperi, mabhuku ose ekushanda eExpcel anobudisa mabhizimisi emafashoni pane bhari rebasa pasi pekona, asi unogona kuvanza kana kuvaratidza sezvinodiwa. Bhuku rimwe chete remashandi rinofanira kuonekwa panguva dzose.
Pane nzira imwechete yekuviga uye kubatanidza Excel mapepa. Unogona:
- Shandisa zvinyorwa zvakanyatsotarisa mamiriro ezvinhu.
- Shandisai Zvinyorwa zveMafuta paImba yebhu yebhoni .
Dhiyabhorosi Anoshandisa Mamwe Mafiro Akafukidzwa Akavanzwa
Dhiyabhorosi iri mumashizha ekuvigwa akavanzwa haabviswi, uye inogona kutaridzwa mumashoko uye marati ari pane mamwe maeseji kana mamwe mabhuku ebasa .
Mamwe mazita akavanzwa aiva nesero zvinyorwa anoramba achivandudza kana data iri mumasero akataridzirwa achichinja.
02 of 05
Viga Excel Worksheet uchishandisa Contextual Menu
Zvisarudzo zvinowanika mumamiriro ezvinhu ezvinyorwa-kana kurudyi-diki menu-shandura zvichienderana nechinhu chakasarudzwa kana menyu ichivhurwa.
Kana Chekuvhara chisarudzo chisina kushandiswa kana chakavharwa kunze, kazhinji kacho gwaro rebasa razvino rine pepa rimwe chete pepaji. Excel inosvitsa chisarudzo chekuvhara mabhuku ebasa rimwe chete nokuti pane imwe nguva inofanira kunge ine bhuku rimwe chete rinooneka riri mubhuku rebhuku.
Kuvanza Rimwe Pepa Rokushanda
- Dzvanya pamushandisi webasa rebhupiti kuti uvanzwe kuti uisarudze.
- Kanda-kanda pane tab yebasa rekushandura kuti uzarure mamiriro ezvinhu.
- Mune menyu, chengetedza pane Hide nzira yekuvanza pepa rakasarudzwa.
Kuvanza Mahwhepa Akasiyana Akawanda
- Dzvanya pamabhasi ekutanga pepaji kuti uvanzwe kuti uisarudze.
- Dhinda uye ubatisise kamba Ctrl pane keyboard.
- Dzvanya pamabhasi ezve mamwe mapepa ekusarudza.
- Kungofa-kanda pane imwe tab yebasa rekushandura kuti uzarure mamiriro emamiriro ezvinhu.
- Mune menyu, chengetera pane Hide nzira yekuvanza mapepa ese ese akasarudzwa.
03 of 05
Vigira Mapepa Ekubatsira Kushandisa Ribhoni
Excel haina mitsara yebhokisi yekuvhara mahwendefa ebasa, asi unogona kushandisa ribhoni kuti uite basa.
- Sarudza tepa rebasa riri pasi pe Excel file.
- Dzvanya paImba yebhu paibhoni uye sarudza maCells icon.
- Sarudza Purogiramu mumenu inodonha inooneka.
- Dzvanya kuvanza & unhide .
- Sarudza Kuvanza Sheet .
04 of 05
Unhide Excel Worksheet Uchishandisa Contextual Menu
Zvisarudzo zvinowanika mumamiriro ezvinhu ezvinyorwa-kana kurudyi-diki menu-shandura zvichienderana nechinhu chakasarudzwa kana menyu ichivhurwa.
Kuti Ubatanidze Pepa Rokushanda Rimwe
- Chimbidza-cheka pane tabu rebasa rekushandura kuti uzarure Unhide dialog box , iyo inoratidza zvese zvinovanzwa mapepa.
- Dzvanya pamashizha kuti usakanganiswa.
- Dzvanya OK kuti unhide yakasarudzwa pepa uye kuvhura bhokisi rebhokisi.
05 of 05
Bhengetedza Pepa Rokushanda Uchishandisa Ribhoni
Sezvo nekuvanza mapepa okushanda, Excel haina mutsara wechibhokisi chekuvhara pepa rekushanda, asi iwe unogona kushandisa ribhoni kuti uwane uye unanise mafiro ebasa akavanzwa.
- Sarudza tepa rebasa riri pasi pe Excel file.
- Dzvanya paImba yebhu paibhoni uye sarudza maCells icon.
- Sarudza Purogiramu mumenu inodonha inooneka.
- Dzvanya kuvanza & unhide .
- Sarudza Unhide Sheet .
- Tarisa uwandu hwemafi akavanzwa anowanikwa. Dzvanya pafaira raunoda kusunungura.
- Dzvanya OK .