Excel Chizadza Pasi Command

Chengeta nguva uye uwedzere kunyatsoona nekukopa dhenda kune mamwe masero

Mutemo wokuzadza weMicrosoft Excel unokubatsira kuti uzadze masero nokukurumidza uye nyore. Ichi chidzidzo chepfupi chinosanganisira zvishoma zvishoma zve keyboard kuitira kuti basa rako rive nyore.

Kunyora nhamba, zvinyorwa, uye mazano mu Excel spreadsheets zvinogona kuva zvinotyisa uye zvinowanzoita kukanganisa kana iwe uchipinda sendima imwe neimwe yega kana kukoshesa zvakasiyana. Kana iwe uchida kuisa data yakafanana mune imwe nhatu dzemasero ari pedyo nemutsetse , Fill Down command inogona kukurumidza kuita izvi iwe uchishandisa keyboard.

Iko kusanganiswa kukuru kunoshandiswa kuzadza pasi murairo ndeye Ctrl + D (Windows) kana kuti Command + D (macOS).

Kushandisa Kuzadza Pasi neKitboard Shortcut uye Hapana Mouse

Nzira yakanakisisa yekuenzanisira Idzadza pasi murairo ndeye muenzaniso. Tevera matanho aya kuti uone kuti ungashandisa sei Kuzadza mune rako rega Excel spreadsheets.

1. Tora imwe nhamba, yakadai se395.54 , kupinda muchikamu D1 mune imwe Excel spreadsheet.
2. Dhinda uye ubatisise key Shift pane keyboard.
3. Dhinda uye ubatisise Key Down Arrow pabhobhoyo kuti uwedzere kujekesa kwesero kubva pane imwe D1 kusvika D7.
4. Bvisa zvose zvigetsi.
5. Dhinda uye ubatisise kamba Ctrl pane keyboard.
6. Dhinda nekusunungura dhi D pane keyboard.

Mitsara D2 kusvika D7 inofanira kunge ichizadzwa nemamwe mashoko akafanana seyero D1.

Zadza Muenzaniso Unoshandisa Mushonga

Newe shanduro dzakawanda dzeExpcel, unogona kushandisa mouse yako kuti uise muchitokisi nenhamba yaunoda kudzokorora mumasekasi pasi payo uye zvinyorani mumagetsi ekupedzisira ehutano kuti usarudze masero ekupedzisira uye ekupedzisira nemasero ose pakati pavo. Shandisa krisheni yekodhi Ctrl + D (Windows) kana kuti Command + D (macOS) kukopa nhamba iri muchitokisi chekutanga kumasero ese akasarudzwa.

Nhengo yeAustFill Solution

Heino nzira yekuita nayo zvimwechetezvo neAppFill feature:

1. Tora imwe nhamba muchikamu mune imwe Excel spreadsheet.
2. Dzvanya uye ubatisise mubati wechiratidzo muzasi kwekona rekona yesero rine nhamba.
3. Dragza gadzikisa pasi pasi kuti usarudze masero aunoda kuva nenhamba imwe chete.
4. Bvisa mutsara uye nhamba yacho inonyorwa mune imwe neimwe yemasero akasarudzwa.

IAustFill inoshandiswawo inoshandawo zvakananga kuti ikopike nhamba kusvika kune masero ari pedyo nemuganhu mumwe chete. Ingofa uye tonyora mubati wezadza mukati memasero mairi. Paunosunungura mouse, nhamba yacho inopihwa mumusero mumwe nomumwe wakasarudzwa.

Nzira iyi inoshandawo nemazere pamwe chete nemashoko uye nhamba. Panzvimbo pokutsvaga kubhadhara kana kunyora nekufambisa chirevo, sarudza bhokisi rine rine chirevo. Dzvanya uye ubatisise chigadziro chozadza uye uchisvitse pamusoro pemasero waunoda kuva nawo maitiro akafanana.