Here is a quick tip for you to create a star rating template in Excel. To create this star rating template all you need is the REPT function. REPT Function is useful when you want to repeat a given text a number of times.
Steps to Create a Star Rating Template
- Insert two different types of stars(☆★) in your worksheet and place them in two different cells.
- Insert five option buttons (Form Control) from the developer tab. And, create a single-cell link for all the buttons. Place them in five cells in a Vertical direction.
- Merge 5 cells, just one column before, where you have buttons.
- Enter “=REPT(H11,5-K11)&REPT(I11,K11)” in the merged cell.
- Change the text orientation of the cell to vertical text and then text alignment to the center and bottom.
Your template is ready.
How it Works
The first part of the formula will give you outlined stars. For Example, when you click on a 3-star rating it will give the rest of the two stars in the outline.
The 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.
You can also insert symbols within the formula itself or you can also use other types of symbols as you like.