Kopa, fambisa uye shandura ruvara rwepepa rekushanda muExcel

Excel inokutendera kuti utore mapepa akagadzirwa kare, fambisa mukati nekunze kwebhuku rebasa razvino, uye shandura ruvara rwematabo kuti zvive nyore kufamba pakati pawo. Muchidzidzo chino, tichaongorora zvese izvi maficha mune zvakadzama sezvinobvira uye kudzidza maitiro ekukopa, kufambisa uye kushandura ruvara rwemashiti muExcel.

Kopa mapepa muExcel

Kana iwe uchida kukopa zvemukati kubva kune rimwe pepa kuenda kune rimwe, Excel inobvumidza iwe kugadzira makopi emapepa aripo.

1. Tinya-kurudyi pane tebhu yebepa raunoda kutevedzera, uye kubva pane yemukati menyu sarudza Fambisa kana kukopa.
2. A dialog box richavhura Fambisa kana kukopa. Pano unogona kutsanangura pamberi pepepa raunoda kuisa iro rakakopwa. Muchiitiko chedu, tichatsanangura Enderera kusvikakuisa pepa kurudyi kwepepa riripo.
3. Sarudza bhokisi rekutarisa Gadzira kopiuye ipapo chengeta OK.
4. Pepa racho richakopwa. Ichange iine zita rakafanana nerepakutanga, pamwe nenhamba yeshanduro. Muchiitiko chedu, takakopa pepa rine zita Ndira, saka pepa idzva richanzi Ndira (2). Zvese zviri mukati mebepa Ndira ichakopiwawo kune pepa Ndira (2).

Unogona kukopa pepa kune chero bhuku rebasa reExcel, chero rakavhurika parizvino. Iwe unogona kusarudza bhuku rinodiwa kubva pakudonha-pasi mubhokisi rebhokisi. Fambisa kana kukopa.

Fambisa pepa muExcel

Dzimwe nguva zvinova zvakakosha kufambisa pepa muExcel kuti uchinje chimiro chebhuku rebasa.

1. Dzvanya pane tab yepepa raunoda kufambisa. Iyo cursor inoshanduka kuita diki shizha icon.
2. Bata pasi mbeva uye dhonza icon yepepa kusvika museve mudiki mutema waonekwa panzvimbo yaunoda.
3. Sunungura bhatani rembeva. Pepa richafambiswa.

Shandura pepa tebhu ruvara muExcel

Iwe unogona kushandura ruvara rwemapepa ebasa kuti uarongedze uye kuita kuti zvive nyore kufamba muExcel bhuku rebasa.

1. Tinya-kurudyi pane tebhu yepepa rebasa raunoda uye sarudza chinhu kubva pane yemukati menyu Label ruvara. Iyo Color Picker ichavhura.
2. Sarudza ruvara rwaunoda. Paunenge uchitenderedza pamusoro peakasiyana sarudzo, preview ichaonekwa. Mumuenzaniso wedu, tichasarudza mutsvuku.
3. Ruvara rwechinyorwa ruchachinja.

Kana pepa rasarudzwa, ruvara rwetabheti unenge usingaoneki. Edza kusarudza chero rimwe pepa muExcel workbook uye iwe unobva waona kuti ruvara runochinja sei.