Kuvandudza kuverenga uye kuchengetedza nguva neAustFormat
Imwe nzira yekuita nyore basa rokugadzira pepa rekushanda mu Excel ndoshandisa AutoFormat sarudzo.
Kugadzirisa hazviitwi kungoita kuti pepa rekuita riite zvakanaka. Kusarudzwa kwemuvara wemuvara, mavara, mavara, uye mamwe maitiro ekufambisa anogona kuita kuti data ive nyore kuverenga, uye iyo inonyanya kukosha muparapariti iri nyore kuona, zvose pavanopa pepanheti kutarisa kwehutano ..
Main Formatting Areas
Pane 17 AutoFormat mitambo inowanikwa muExcel. Iyi mitambo inokanganisa zvitanhatu zvakakosha maitiro:
- Nhamba yemaitiro
- Borders
- Fonts
- Mienzaniso uye ruvara rwemukati
- Kugadzirisa
- Column uye musara wekukura
Nzira yekuwedzera AutoFormat kune Quick Access Toolbar
Kunyange zvazvo inoshandiswa kuburikidza nekusarudza kwemenu mune zvinyorwa zvekare, AutoFormat haina kuwanikwa pane chero tema tibhoni kubvira paExcel 2007.
Kuti uwane AutoFormat, wedzera AutoFormat icon ku Quick Access Toolbar kuitira kuti inogona kuwanikwa kana ichidiwa.
Iyi ibasa rimwe chete. Mushure mokunge yawedzerwa, chiratidzo chinoramba chiri pa Quick Access Toolbar.
- Dzvanya pamusana weveve museve pamugumo we Quick Access Toolbar kuti uzarure mhinduro inodonha.
- Sarudza Mitemo Yakawanda kubva pakurongwa kuti uzarure Chengetedza Quick Access Toolbar dialog box .
- Dzvanya pasi pasi pemiseve pakuguma kweSarudza mirairo kubva kune mutsara kuti uzarure mhando inodonha.
- Sarudza Mitemo Yese kubva pakurongwa kuti uone mirairo yose inowanika muExcel muboshwe pane.
- Dhura nepfungwa iyi yerabhaibheri kuti uwane AutoFormat murairo.
- Dzvanya paIndaneti kowanikidza pakati pemirairo yepaneti kuti uwedzere AutoFormat bhokisi ku Quick Access Toolbar.
- Dzvanya OK kuti upedze kuwedzera.
Kushandisa AutoFormat Style
Kushandisa AutoFormat style:
- Simbisai dhesi iri mubasa raunoda kuisa.
- Dzvanya paBotFormat bhatani pa Quick Access Toolbar kuti ubudise hurukuro yebhokisi yebhokisi.
- Dzvanya pane imwe yemaitiro anowanikwa.
- Dzvanya OK kuti ushandise chimiro uye usunge bhokisi rebhokisi.
Shandura AutoFormat Style isati yasarudza
Kana hapana yepeji iripo inofanirwa nekuda kwako, inogona kuchinjwa kana isati yakwana kana ishure yakashandiswa pane pepa.
Shandura AutoFormat Style Usati Washandisa Izvo
- Dzvanya pakusarudza Options pane pasi pe AutoFormat dialog box.
- Sarudza chero ipi zvayo mitanhatu yakatarisa nzvimbo dzakadai semhando, miganhu, kana kurongedza kubvisa izvi zvingasarudzwa zvekufambisa kubva pane zvose zviripo.
- Mienzaniso iri muhwindo rebhokisi rebhokisi rekufunga kuratidza kuchinja.
- Dzvanya OK kuti ushandise shanduro yakashandurwa.
Shandura AutoFormat Style Pashure Kokushandisa Izvo
Kamwe yakashandiswa, chimiro chinogona kuchinjwa zvakare uchishandisa maExcel ekufambisa maitiro ekugadzirisa-panzvimbo yakawanda- paImba yebhu yebhoni.
The modified AutoFormat style inogona kuchengetwa semafambiro echimiro, izvo zvinoita kuti zvive nyore zvakare kushandisa zvakare mamwe mabhesi.