Excel AutoFormat

Limbikitsani kuwerenga ndi kusunga nthawi ndi AutoFormat

Njira imodzi yochepetsera ntchito yokonza pepala la Excel ndi kugwiritsa ntchito njira ya AutoFormat.

Kukonza sikumangopangidwira kuti pulogalamuyi iwoneke bwino. Kusankhidwa kwa mtundu wakale, mawonekedwe apamwamba, mausita, ndi zina zomwe mungasankhe zingapangitse kuti deta ikhale yosavuta kuwerenga, ndipo mfundo zofunika kwambiri mu spreadsheet n'zosavuta kuziwona, ponse pompatsa spreadsheet maonekedwe a akatswiri ..

Maofesi Akuluakulu Okhazikitsa

Pali 17 Mafilimu a AutoFormat omwe alipo mu Excel. Mitambo iyi imakhudza madera asanu ndi awiri oyambirira:

• Kusintha kwa chiwerengero
• Zozungulira
• Zizindikiro
• Zitsanzo ndi mtundu wachikulire
• Kugwirizana
• Mzere ndi kukula kwa mzere

Mmene Mungakwirire AutoFormat ku Quick Access Toolbar

Ngakhale kupezeka pamasewero am'mbuyomu, AutoFormat siinapezeke pazomwe zili pamabatani kuyambira Excel 2007.

Kuti mugwiritse ntchito AutoFormat, onjezerani chizindikiro cha AutoFormat ku Quick Access Toolbar kuti chikhoze kupezeka ngati pakufunika.

Imeneyi ndi ntchito yamodzi. Pambuyo pawonjezeredwa, chizindikirocho chimakhala pa Quick Access Toolbar.

1. Dinani pamsana wotsika kumapeto kwa Quick Access Toolbar kuti mutsegule masewera otsika.
2. Sankhani Malamulo Owonjezera kuchokera pa mndandanda kuti mutsegule Bokosi la bokosi la Quick Toolbar lofulumira .
3. Dinani pansi pavivi pamapeto a Sankhani malemba kuchokera kumzere kuti mutsegule menyu otsika.
4. Sankhani Malamulo Onse kuchokera pa mndandanda kuti muwone malamulo onse omwe alipo mu Excel kumanzere.
5. Tsegula mndandanda wamabukuwa kuti mupeze AutoFormat .
6. Dinani pazowonjezerani Pakati pazondomeko za malamulo kuti muwonjezere batani la AutoFormat ku Quick Access Toolbar.
7. Dinani OK kuti mutsirize kuwonjezera.

Kugwiritsa ntchito AutoFormat Style

Kugwiritsa ntchito ndondomeko ya AutoFormat:

1. Sungani deta mu tsamba limene mukufuna kupanga.
2. Dinani pa batani la AutoFormat pa Quick Access Toolbar kuti mubweretse bokosi la zokambirana.
3. Dinani pa imodzi mwa machitidwe omwe alipo.
4. Dinani OK kuti mugwiritse ntchito kalembedwe ndi kutseka bokosi la bokosi.

Sinthani ndondomeko ya AutoFormat musanagwiritse ntchito

Ngati palibe mafayilo omwe alipo omwe mukuwakonda, angasinthidwe mwina asanakhale atagwiritsidwa ntchito pa tsamba.

Sinthani ndondomeko ya AutoFormat Musanayigwiritse ntchito

1. Dinani pazomwe Mungasankhe pazithunzi pansi pa AutoFormat dialog box.
2. Sankhani malo asanu ndi limodzi omwe amawongolera monga zojambula, malire, kapena kugwirizana kuti muchotse njirazi zochokera ku machitidwe onse omwe alipo.
3. Zitsanzo muzenera lawindo la bokosi la bokosi kuti liwonetse kusintha.
4. Dinani OK kuti mugwiritse ntchito kalembedwe kake.

Sinthani Ndondomeko ya AutoFormat Pambuyo Kuyigwiritsa Ntchito

Akagwiritsidwa ntchito, kalembedwe ikhoza kusinthidwa mosavuta pogwiritsira ntchito njira zowonetsera zokhazikika za Excel zomwe zimapezeka kwambiri pa tsamba la Home la Ribbon.

Ndondomeko yosinthidwa ya AutoFormat ikhoza kupulumutsidwa ngati kalembedwe kachitidwe, zomwe zimapangitsa kuti zikhale zosavuta kugwiritsa ntchito ndi zolemba zina.