Sarudza Mamwe Masero Asingaoneki muExcel neKibobhodhi neMouse

Nokusarudza masero akawanda muExcel unogona kubvisa data, shandisa maitiro akaita semiganhu kana shading, kana kushandisa zvimwe zvingashandiswa kumativi makuru epepaiti rese panguva imwechete.

Paunenge uchikwevera nemushonga kuti uone nekukurumidza chivharo chemasero akakomberedzwa ndiyo inonyanya kushandisa nzira yekusarudza kupfuura imwe kero, pane dzimwe nguva apo masero aunoda kusimbisa haawani pedyo nemumwe.

Kana izvi zvichiitika, zvinokwanisika kusarudza zvisingasviki masero. Kunyange zvazvo kusarudza masiseri asina kusvibiswa kunogona kuitwa chete nebhobhoyo sezvinoratidzwa pasi apa, zviri nyore kuti uite uchishandisa keyboard uye mouse pamwechete.

Kusarudza Mamwe Masero Asingaoneki muExcel neKibobhodhi neMouse

1. Dzvanya pane sero yekutanga yaunoda kusarudza neyo mouse pointer kuti iite iyo inoshanda sero .
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dzvanya pamamwe masero aunoda kuasarudza pasina kusunungura ctrl.
4. Kana kamwe masero ose aidiwa achisarudzwa, kusunungura Ctrl.
5. Usambofa pane imwe nzvimbo neyo mouse pointer kana ukasunungura ctrl kana iwe uchabvisa zvakasimbiswa kubva kumasero akasarudzwa.
6. Kana ukasunungura ctrl pfupi nokukurumidza uye uchida kusimbisa mamwe masero, tsvaga pfugama uye ubatisise Ctrl kechi zvakare uye tora pane imwe sero (s)

Sarudza Mamwe Masero Asingaoneki muE Excel Kushandisa Icho Cheki Cherobhodi

Matanho ari pasi apa anosarudza masero achishandisa chete keyboard.

Kushandisa Keyboard in Extended Mode

Kusarudza zvisiri pamasero masero ane keyboard chete inoda iwe kushandisa khibhodi mu Extended Mode.

Yakawedzerwa mode inoshandiswa nekufambisa F8 key pane keyboard. Iwe unogona kuvhara mode yakawedzerwa nekudhinda Shift neF8 makii pa keyboard pamwe chete.

Sarudza Mamwe Mamwe Masero Asingaoneki muExcel Kushandisa Keyboard

1. Shandisa se cell cursor kune imwe sero yaunoda kusarudza.
2. Dhinda uye usunungurire F8 key pabhobhoyo kuti utange Extended Mode uye kuisa seni yekutanga.
3. Pasina kutenderera se cell cursor, shandisa uye osunungura Shift + F8 makii pabhokisi pamwe chete kuti muvhare mhepo yakawedzerwa.
4. Shandisai mitsara yemiseve pakibhodi kuti uite se cell cursor kune rimwe rinotevera raunoda kuisa pachena.
5. Sero yekutanga inofanira kuramba yakasimbiswa.
6. Nees cell cursor pane imwe sero inotevera kuti iiswe pachena, dzokorora matanho 2 ne3 pamusoro.
7. Ramba uchiwedzera masero kumabhedhi akaiswa pachena uchishandisa F8 uye Shift + F8 zvigadzirira kutanga uye kumira yakawedzerwa mode.

Kusarudza Majeri Ekare uye Asingaiti Mairi muExpcel Kushandisa Keyboard

Tevera matanho ari pasi apa kana mararamiro aunoda kusarudza ane musanganiswa wemasero anenge ari oga uye ari oga sekuratidzwa mumufananidzo uri pamusoro.

1. Shandisa se cell cursor kune imwe sero muboka remasero waunoda kuisa.
2. Dhinda uye usunungure F8 key pa keyboard kuti utange Extended Mode.
3. Shandisai miseve yemiseve pabhobhoyo kuti uwedzere ruzivo rwakasimbiswa kuti uise masero ose muboka.
4. Nevose masero ari muboka akasarudzwa uye anosunungura Shift + F8 kiyi pakibhokisi pamwe chete kuti muvhare maitiro akawedzerwa.
5. Shandisai miseve yemiseve pabhobhoyo kuti uite se cell cursor kure neboka rakasarudzwa remasero.
6. Boka rokutanga remasero rinofanira kuramba rakasimbiswa.
7. Kana pane mamwe masero akabatana aunoda kuisa pachena, enda kune imwe sero iri muboka uye dzokorora matanho 2 kusvika 4 pamusoro.
8. Kana paine masero ega ayo waunoda kuwedzera kune yakarongedzwa, shandisa sekutanga yekuraira pamusoro apa kujekesa masero masere.