Excel AutoFormat

Inganta karatu da ajiyar lokaci tare da AutoFormat

Ɗaya daga cikin hanyoyin da za a sauƙaƙe aikin tsara tsarin aiki a Excel shine don amfani da zaɓi na AutoFormat.

Tsarin ba a yi kawai don yin takardar aikin aiki mai kyau ba. Zaɓin launi na bayanan, lakabin layi, nau'in launi, da sauran zaɓuɓɓukan tsarawa na iya sa sauƙaƙe don karantawa, kuma mafi muhimmanci bayanai a cikin shafukan yanar gizo ya fi sauƙi a gani, duk yayin da kake ba da rubutu a matsayin mai sana'a.

Babban Yanayin Yanki

Akwai hanyoyi 17 na AutoFormat a Excel. Wadannan styles suna da tasiri guda shida masu tsarawa:

• Tsarin lambar
• Borders
• Fonts
• Dabbobi da launin launi
• Daidaitawa
• Girman layi da jere

Yadda za a Ƙara AutoFormat zuwa Toolbar Access Quick

Ko da yake ta hanyar zaɓuɓɓukan menu a cikin fasalin farko, AutoFormat bai samuwa a kan kowane shafuka na rubutun tun daga Excel 2007 ba.

Don amfani da AutoFormat, ƙara icon AutoFormat zuwa Toolbar Quick Access don haka za'a iya samun dama idan an buƙata.

Wannan aiki ne guda daya. Bayan an kara da cewa, icon yana tsaya a kan Toolbar Quick Access.

1. Danna kan maɓallin ƙasa a ƙarshen Toolbar Toolbar don buɗe menu mai saukewa.
2. Zabi Ƙarin Umurnai daga jerin don bude Siffar da akwatin maganganu na Quick Access Toolbar .
3. Danna maɓallin ƙasa a ƙarshen Zabi umarni daga layi don buɗe menu mai saukewa.
4. Zabi Duk Dokoki daga lissafi don ganin dukan umarnin da ke cikin Excel a cikin hagu na hagu.
5. Gungura cikin wannan jerin haruffan don neman umarnin AutoFormat .
6. Danna maɓallin Ƙara tsakanin umarnin umarni don ƙara maɓallin AutoFormat zuwa Toolbar Quick Access.
7. Danna Ya yi don kammala bugu.

Neman Tsarin AutoFormat

Don amfani da tsarin AutoFormat:

1. Nuna bayanai a cikin takardun aikin da kake so ka tsara.
2. Danna maɓallin AutoFormat a kan Toolbar na Quick Access don tayar da akwatin maganganun.
3. Danna kan ɗaya daga cikin hanyoyin da ake samuwa.
4. Danna Ya yi don amfani da style kuma rufe akwatin maganganu.

Gyara wani AutoFormat Style kafin Aikata

Idan babu wani salon da aka samo don ƙaunarka, za a iya gyaggyara su kafin ko kuma bayan an yi amfani da su zuwa wata takarda.

Gyara Ɗauki na AutoFormat Kafin Aikata shi

1. Danna maballin Zaɓuɓɓukan a kasa na akwatin maganganun AutoFormat .
2. Deselect wani daga cikin yankuna shida masu tsarawa kamar layi, iyakoki, ko daidaitawa don cire wadannan zaɓuɓɓukan tsarawa daga dukkan nau'ukan da aka samo.
3. Misalai a cikin maganganun maganganun maganganun don sabunta canje-canje.
4. Danna Ya yi don amfani da tsarin da aka gyara.

Gyara wani Style AutoFormat Bayan Aikata shi

Da zarar an yi amfani da shi, za a iya inganta hanyar da za a iya inganta ta hanyar amfani da tsarin tsara na yau da kullum na Excel-domin mafi yawan-a kan shafin shafin shafin rubutun.

Za'a iya adana tsarin AutoFormat da aka canza shi a matsayin tsarin al'ada, wanda zai sa ya fi sauƙi don sake amfani dashi tare da ƙarin takardun aiki.