In Excel , Mawduuca^(Theme) waa ururinta Midabada^(Colors) caadiga ah , Fonts , iyo Saamaynta^(Effect) kuwaas oo lagu dari karo buug-shaqeedka ama walxaha ku jira buug-shaqeedka, tusaale ahaan, Shaxannada^(Charts) iyo Jaantusyada^(Tables) . Mawduuc^(Theme) kastaa wuxuu bixiyaa Midab gaar ah, Font^{(Color, Font)} , iyo Saamaynta^(Effects) , kaas oo siinaya dukumentiga muuqaal xirfad leh oo joogto ah. Marka Mawduuc^(Theme) cusub la doorto, qaabka cusub waxa uu bedeli doonaa qaab kasta oo ka mid ah buuga shaqada.

Qalabka lagu abuurayo Mawduucyada^(Themes) waxaa laga heli karaa bogga Layout^{(Page Layout)} tab ee Kooxda Theme^{(Theme Group)} . Qalabkani waa Mawduucyada^(Themes) , Midabada^(Colors) , Farta^(Font) , iyo Saamaynta^(Effect) .

• Mawduucyada^(Themes) : Mawduucyada waxay ku siinayaan buuggaaga shaqo qaab joogto ah, soo jiidasho leh
• Midabka^(Color) : beddel midabka dukumeentigaaga adigoo gujinaya palette midab leh
• Font : Wuxuu beddelaa qoraalka ku jira buug-yarahaaga shaqo adiga oo dooranaya xarfo. Waxay beddelaysaa qoraalka dukumeentiga isku mar.
• Saamaynta^(Effects) : Waxay bedeshaa muuqaalka walxaha ku jira buugga shaqada. Waxay isticmaashaa Saamaynta Aragga

Dul-wareegidda Qalabka Mawduuca ee^{(Theme’s Tools)} Kooxda Mawduucyada waxay^{(Themes Group)} ku siin doontaa horudhac ku saabsan sida ay u eegi doonaan xaashida shaqada.

Tababarkan, waxaan ku sharixi doonaa sida loo doorto oo loo habeeyo buuggaaga shaqada ee Excel .

Sida mawduucyada^(Themes) loogu daro Buugaaga Shaqada ee Excel^{(Excel Workbook)}

Si aad mawduucyada ugu darto buuggaaga^{(Themes) (Themes )} shaqada, hubi in xogtu ay ku jirto miis, qaabkuna uu yahay mid caadi ah sababtoo ah ma arki doontid palette theme^{(Theme Palette)} s marka la doorto lagu dabaqo xaashida shaqada.

Marka hore, aad tabka Layout^{(Page Layout)} bogga dhanka bidix ee sare ee Daaqadda Layout ee bogga^{(Page Layout Window)} dooro Mawduucyada^(Themes) . Kooxda Theme ,^(Group) liiska hoos-u-hoosaadka ayaa muujin doona dooro mawduuca^(Theme) aad rabto . Marka Mawduuca^(Theme) la doorto, waxaad ogaan doontaa sida qaabka iyo midabka isku beddelaan miiska warqadda shaqada.

Waxaad sidoo kale ka raadin kartaa mawduuc. Dooro Baadi Mawduucyada^{(Browse for Themes)} , Daaqaddaada ^(window)Faylka Explorer^{(File Explorer)} ayaa soo bixi doonta. Dooro mawduuc aad^(Theme) soo dejisay oo ku dar miiskaaga. Markaa OK . Waxa kale oo aad kaydin kartaa mawduucaaga^(Theme) adiga oo dooranaya  Keydi Mawduuca Hadda^{( Save Current Theme)} . Mawduuca waxa lagu kaydin doonaa File Explorer , Magacaaga mawduuca^(Theme) , dooro Folderka^(Theme) aad rabto in mawduucaagu ^(Folder)ku^(Theme) jiro, ka dibna Keydi^(Save) .

Ku dar midabada mawduuca Buugaaga Shaqada

Tag Kooxda Mawduucyada ee^{(Themes Group)} ku yaal bogga Layout^{(Page Layout)} -ka bogga oo dooro Colors , liiska midabada midabada^{(Color Palettes)} ayaa soo bixi doona, ka dibna dooro palette midabka^{(Color Palette)} aad rabto; u fiirso kaliya midabada miiska ku jira xaashida shaqada ayaa isbedelaya.

Waxa kale oo aad habayn kartaa midabadaada adiga oo dooranaya Midabbada gaarka ah^{(Customized Colors)} . Sanduuqa wada hadalka ee loo yaqaan Abuur Mawduuca Cusub^{(Create New Theme Colors)} ayaa soo bixi doona; dooro Midabadaada^(Colors) ama Text/ Background Colors , ka dib O K. Mawduuca^(Theme) ku dhex jira shaxanka ka muuqda sawirada waa isbedeli doona.

Ku dar xarfaha Buugaaga Shaqada ee Excel

Tag bogga Layout^{(Page Layout)} tab ee Kooxda Theme^{(Theme Group)} . Dooro xarfaha , dooro ^(Fonts)xarfaha^(Font) aad rabto . U fiirso in qaabka xarfaha^{(Font Style)} ee shaxda^(Table) uu isbedelayo.

Waxa kale oo aad habayn kartaa fartaada^(Font) adiga oo gujinaya farta^{(Customized Fonts)} la habeeyey . Sanduuqa wada hadalka ayaa soo bixi doona oo loo yaqaan Abuur Farta Mawduuca Cusub^{(Create New Theme Fonts)} . Guji falaarta hoos-u-dhaca ee Ciwaanka iyo Farta Jidhka^{(Heading and Body Font)} . Waxaad arki doontaa Hababka Fonts^{(Fonts Styles)} oo aad ka soo dejisan karto Bakhaarka Microsoft^{(Microsoft Store)} . Dooro qaabka aad rabto, ka dibna magacaaga magacaaga, ka dibna OK.

Ku dar Saamaynta Shayga Buugaaga Shaqada

Kooxda Themes^{(Themes Group)} , dooro Saamaynta^(Effect) bogga Layout^{(Page Layout)} tab, liiska Saamaynta^(Effects) ayaa soo bixi doona. Dooro  Saamaynta^(Effect) aad rabto, ka dibna OK . Ogaysii in shaygaagu isbedeli doono .^(Notice)

Waxaan rajeyneynaa in qoraalkani uu kaa caawiyo inaad bedesho muuqaalka buuggaaga shaqada.

How to apply Themes and change the appearance on an Excel Workbook

In Excel, a Theme is a collection of default Colors, Fonts, and Effects that can be added to a workbook or items in a workbook, for instance, Tables and Charts. Each Theme gives a unique Color, Font, and Effects, which provides the document with a consistent professional look. When a new Theme is selected, the new style will replace any styles from the workbook.

The tools for creating Themes are available in the Page Layout tab in the Theme Group.  These tools are Themes, Colors, Font, and Effect.

• Themes: Themes give your workbook a consistent, attractive style
• Color: change the color in your document by clicking a color palette
• Font: Changes the text in your workbook by choosing a font set. It changes your document text at the same time.
• Effects: It changes the look of objects in the workbook. It uses Visual Effects.

Hovering over the Theme’s Tools in the Themes Group will give you a preview of how they will look on your worksheet.

In this tutorial, we will explain how to choose and customize your workbook in Excel.

How to Add Themes to your Excel Workbook

To add Themes to your workbook, ensure that the data is in a table and the style is normal because you will not see the Theme Palettes when selected applied to our worksheet.

First, go to the Page Layout tab on the top left of the Page Layout Window select Themes. In the Theme Group, a drop-down list will show select your desired Theme. When the Theme is selected, you will notice how the style and color change within the worksheet table.

You can also browse for a theme. Select Browse for Themes, your File Explorer window will pop up. Choose a Theme that you downloaded and add it to your table. Then OK. You can also save your Theme by selecting  Save Current Theme. The Theme will be saved to the File Explorer, name your Theme, choose the Folder you want your Theme to be in, then Save.

Add Theme Colors to your Workbook

Go to the Themes Group on the Page Layout tab and select Colors, a list of Color Palettes will appear, then select the Color Palette you want; notice only the colors within the table in the worksheet changes.

You can also customize your colors by selecting Customized Colors. A dialog box called Create New Theme Colors will appear; choose your Colors or Text/ Background Colors, then OK. The Theme within the table shown in the pictures will change.

Add Fonts to your Excel Workbook

Go to the Page Layout tab in the Theme Group. Select Fonts, Select your desired Font. Notice that the Font Style in the Table changes.

You can also customize your Font by clicking Customized Fonts. A dialog box will appear called Create New Theme Fonts. Click the drop-down arrow of the Heading and Body Font. You will see Fonts Styles you can download from the Microsoft Store. Select your desired style, then name your style, then OK.

Add Effects to your Workbook Object

In the Themes Group, select Effect on the Page Layout tab, a list of Effects will appear. Choose the  Effect you want, then OK. Notice that your object will change.

We hope this post helps you change the appearance of your workbook.

Related posts

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Casharka Microsoft Excel, ee Bilowga ah

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel