PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO change WORKBOOK THEME IN EXCEL?

INTRODUCTION

Wisely created workbooks or sheets using appropriate colors, fonts and effects are always attractive to see and easy to use.

Fonts , effects , styles etc. are very important factors of any perfect report.

Although we perform a number of mathematical calculations in Excel but text has its own importance.

“THEME” MEANS A PARTICULAR SET OF COLORS, FONTS, EFFECTS AND STYLE TO PROVIDE A SPECIAL LOOK AND FEEL TO OUR SHEETS. THEMES GIVES A DIRECT ACCESS TO CHANGE ALL THE VARIABLES ALTOGETHER IN A SINGLE CLICK .

Themes are handy if we doesn’t like the look and feel of our report. It is a timetaking process if we change the font, effect and style of each text separately. Here is , when THEMES come handy. Just one click and the complete look and feel is changed within a second.

 LOOK AND FEEL WILL MAINLY AFFECT THE COLORED PORTIONS OF THE SHEETS SUCH AS TABLES, CHARTS, ORGANIZATION TABLES ETC.

In this article we’ll learn to change the theme of a sheet in the Excel Sheet.

 

 

 

 

WHY DO WE NEED TO CHANGE THE THEME OF THE EXCEL SHEET

Till now, you must have understood the meaning of a THEME and what we mean by changing the theme.

Now let us spend a minute thinking about the needs of changing a theme. Why this simple functionality is important and how it can save us a lot of time.

 

It happens a lot when we have finalized the font faces, colors, effects etc. of different components and suddenly we start feeling that we need to change them.

IN THE TUTORIALS WE TAKE VERY VERY SIMPLE EXAMPLES FOR THE EASY UNDERSTANDING.BUT IN REAL, THE REPORTS ARE VERY BIG WHICH CAN TAKE HOURS IF WE TRY TO JUST CHANGE THE FONT, COLORS , EFFECTS ETC. OF THE REPORT.

 

In such a situation, the themes options comes in handy.

We can choose from a large set of options.

We can click the option and have the result within a set.

If we don’t like the option, we can create one for us too.

HOW TO CHANGE WORKBOOK THEME IN EXCEL ?
BUTTON LOCATION OF THEMES IN EXCEL

BUTTON LOCATION FOR CHANGING THEME IN EXCEL

The button for changing the themes in Microsoft Excel is under the PAGE LAYOUT TAB under the  THEMES section. THEME BUTTON IS THE FIRST BUTTON IN THE LEFT PORTION OF PAGE LAYOUT TAB.

HOW TO CHANGE WORKBOOK THEME IN EXCEL ?
BUTTON LOCATION OF THEMES IN EXCEL

STEPS TO CHANGE THE THEME

Its really easy to change the theme of the sheet.

FOLLOW THE STEPS TO CHANGE THE THEME  OF THE EXCEL SHEET

  • Go to the PAGE LAYOUT TAB.
  • Click on the THEMES BUTTON and a drop down will open.
  • Select the theme of your choice.

 

ANIMATED EXAMPLE OF CHANGING THE THEME IN EXCEL

The following animated picture shows the steps to change the themes.

The example is showing the EXCEL 2007 but is equally valid for advanced versions i.e. EXCEL 2010, EXCEL 2013, EXCEL 2016 , EXCEL 2019 and EXCEL 365.

 

The example shows a text which has been created using a text box and the effect on the same is being shown by changing the theme of the sheet.

We can see how the color and font changes with the change in the theme.

HOW TO CHANGE WORKBOOK THEME IN EXCEL ?
ANIMATED EXAMPLE SHOWING THE STEPS TO CHANGE THE THEME

CHANGING THE THEME WITH INDIVIDUAL COMPONENTS

In addition to the theme option , Excel provides the option of changing the individual components of the theme i.e. Colors, Fonts and Effects separately.
COLORS: It’ll change only the colors as per the theme. i.e. the color of the components will be changed to the set of colors chosen.

 

FONTS: The font face of the selected cells can be changed using this option.

Effects: The effects will work on the text inserted through the TEXT BOX as Word Art.

The EFFECTS will work on the background of the text box when used as style.

The animated picture in the previous section provides a demonstration of all the options.

 

LEARN

  • EXCEL
  • HTML
  • JAVASCRIPT
  • MORE TO COME…

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Leave a Reply