Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

Star Rating Template In Excel Using REPT Function [Quick Tip]

    Excel Star Rating Template In Excel Using REPT Function

    Here is a quick tip for you to create a star rating template in excel.

    To create this star rating template all you need, REPT Function.

    REPT Function is useful when you want to repeat a given text for a number of times.

    And, today we will use this formula to create this Star Rating Template in Excel.

    Use REPT Function To Create Star Rating Template

    Steps To Create a Star Rating Template

    • Insert two different types of stars (☆★) in your excel sheet. And, place them in two different cells.
    • Insert five option buttons (Form Control). And, create a single cell link for all the buttons. Place them in five cells in a Vertical direction.

    link option buttons with a single cell to create a star rating template using REPT function

    • Merge 5 cells just one column before your inserted buttons.
    • Enter below formula in the merged cell.

    Use this rept function to create a star rating template

    • Change the text orientation of formulated cell to the Vertical Text.

    Change cell orentation of the cell formulated with REPT Function

    • Change text alignment of formulated cell to the center & bottom.
    • Finally, you have a Star Rating Template.

    a star rating template by using rept function

    How it works?

    • The first part of the formula will give you outlined stars. For Example, when you click on 3-star rating it will give rest of the two stars in outline.
    • Second Part of the formula will give you filled stars. For example, when you click on the 4-star rating you will get 4 filled stars.

    More Information

    • You can also insert symbols within the formula itself.
    • You can also use another type of symbols as you like.
    • Change the style of the template as per your requirement.

    Download this sample file to learn more.

    Last Words

    Creating a star rating template in excel simple and easy.

    Star Rating Template is the first part of our series to create In-Cell charts using Rept Function.

    Check out rest of the parts.

    In-Cell Column Chart

    In-Cell Gantt Chart

    So, do you know any other way to create a star rating template in excel/

    I would like to hear from you.