Nzira Dzakareruka dzekutamisa Pivot kubva paDesktop kuenda kuExcel

Mushure mekugadzira tafura yepivot, unogona kuona kuti haisi panzvimbo chaiyo yaunoda kuiendesa kune imwe spreadsheet. Pazasi iwe unowana matanho ekushandisa Pivot Tafura muExcel.

Chinja tafura yepivot kuExcel

Sezvauri kuona pamufananidzo uri pazasi, tafura yepivot inotanga pamutsara wechisere (sero A8) ine mitsara isina chinhu isina kufanira kumusoro. Dambudziko iri rinogona kugadziriswa nekungofambisa tafura yepivot kune cell A8.

Ungangoda kuendesa tafura yepivot kune rimwe pepa rebasa idzva mubhuku rebasa rimwechetero kana kubepa rebasa idzva mune rimwe bhuku rebasa.

Ese mabasa aya anogona kuitwa zviri nyore nekushandisa iyo Transfer PivotTable command inowanikwa muMicrosoft Excel.

1. Shandura tafura yepivot kune inofananidzwa spreadsheet

Tevedza matanho ari pasi apa kuti uendese tafura yepivot kune imwe nzvimbo paspredishiti rimwechete

1.1. Dzvanya chero pairi Spinning plate.

1.2. Wobva wadzvanya bhatani Ongorora iri mune main menu bar uye tinya Chinja Pivot Tafura mukana.

1.3. MuTransfer PivotTable dialog box, tinya bhatani Nzvimbo wobva wadzvanya bhatani Nzvimbo nyowani nzvimbo yaunoda kufambisa chikuva chinotenderera wodzvanya OK.

Mumuenzaniso uri pamusoro, takadzvanya pasero A2 kufambisa tafura yepivot kunzvimbo iyoyo.

2. Chinja tafura yepivot kune itsva kana yakasiyana spreadsheet

Kazhinji yenguva, iwe unozofanirwa kuendesa iyo Pivot Desktop kune nyowani spreadsheet. Nenzira iyi, iyo Pivot Hofisi ingangove yakagarwa mune yayo yega spreadsheet.

2.1. Dzvanya chero pairi Spinning plate.

2.2. Wobva wadzvanya bhatani Ongorora iri pane main menu bar, wobva wadzvanya Dhaunirodha tafura yepivot mukana.

Cherechedza: Iko kugona kuendesa tafura yepivot inowanikwawo paPivot Tafura Sarudzo tab.

2.3. MuTransfer PivotTable dialog box, tinya Tsva yekushandira mukana uye tinya OK.

Excel ichavhura marobhoti spredishiti nyowani uye tafura yepivot ingangoendeswa kune nyowani spreadsheet.

3. Fambisa tafura yepivot kune rimwe bhuku rebasa

Chaizvoizvo, hapana mukana muExcel kufambisa tafura yepivot kune rimwe bhuku rebasa. Nekudaro, zvinokwanisika kudzokorora tafura yepivot woiisa mune rimwe bhuku rebasa.

3.1. Dzvanya chero pairi Pivoting Office.

3.2. Wobva wadzvanya bhatani Ongorora iri mune main menu bar> tinya Sarudza wobva wadzvanya tafura yose ine simba mune yekudonha-pasi menyu.

Cherechedza: Zvinonyanya kuitika kuti iwe uchaona mukana wekurodha PivotTable pazasi Kusarudza matafura epivot Faira.

3.3. Kana iyo Pivoting Desktop yasarudzwa, tinya-kurudyi pairi uye tinya pane iyo sarudzo Copia mukana.

3.4. Zvino, famba uchienda kune rimwe divi Bhuku rebasa > Tinya-kurudyi sero paunoda kuti Pivot Desktop itange, wobva wadzvanya Namira pachivande mune menyu inoonekwa.

3.5. PaPaste Specific screen, ita shuwa kuti "Zvese" zvasarudzwa uye tinya OK.

Iwe unobva waona iyo Live Desktop yakanamirwa muBhuku Idzva Rebasa. Iyo glued Pivot Desk inofanirwa kuchengetedza yakawanda yefomati yayo uye iwe ungangoda kugadzirisa hupamhi hwemakoramu.

• Nzira Dzakareruka dzekuchinja Simba Kusiyanisa uye Pivot Tafura Ruzivo
• Nzira dzakareruka dzekuwedzera kana kubvisa subtotals mune ine simba desktop