How to Apply Retrospect Theme in Excel

Get FREE Advanced Excel Exercises with Solutions!

Everyone is a fan of beauty. We admire the beautiful things. We even try to beautify our workbook. There are so many themes built-in Microsoft Excel to decorate the Work Sheet. One of the built-in themes is Retrospect theme. We can apply the Retrospect Theme for the decoration of our Work Sheet. In this article, we are going to discuss as simply as possible for the learners on how to apply the Retrospect Theme in Excel.

Basics of Retrospect Theme

Retrospect Theme is actually a template that provides a general design with coordinating Fonts, effects and Colors. We can apply a specified pattern instead of applying it separately. But it is not in restricted mode. We can modify the theme colors, fonts and effects even after applying the theme.  For further use in the future, we can even keep the modified theme saved.

Process to Apply Retrospect Theme in Excel

We can apply the Retrospect Theme maintaining the following procedure:

  • First of all, select all the cells where the Retrospect Theme will be applied. Here, I selected cells from B2 to D10.
  • Go to Page Layout.
  • Now, click on Themes from the Ribbon.

How to Apply Retrospect Theme in Excel

  • Pick the Retrospect Theme from the available option.

Now, we have the applied theme dataset.

How to Apply Retrospect Theme in Excel

Ways to Apply Custom Colors, Fonts for Retrospect Theme

After applying the Retrospect theme we can apply our custom colors or fonts. To make further edits after the theme choice we can adjust it from the ribbon.

We can change colors by clicking on Colors and selecting a pattern. You can further customize your colors. For this, click on Customize Colors.

How to Apply Retrospect Theme in Excel

You can also change the font similarly from the Fonts option.

After customizing with your choices. You can save the customized theme. For this, go to Theme and then click on Save Current Theme. Now, if you open the file later you will still find the theme.

How to Apply Retrospect Theme in Excel

Read More: How to Apply a Theme to a Workbook in Excel

Download Practice Workbook


In this article, we have tried to explain in simple words on how to apply the Retrospect Theme in Excel. I hope it will be helpful for all. For any further questions, comment below.

Related Articles

<< Go Back to Excel Theme | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.


Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF