How to create a star rating? Currently, some friends who have just come into contact with Excel software say they still don’t understand it. Today, I will give you a detailed introduction to the steps of creating a star rating in Excel. Come and follow the editor to take a look!

Prepare a star rating sheet.

Enter the function rept in the star rating.

Enter the complete formula =reap(“☆”, D3) as shown in the figure:

D3 represents the rating, just drop down and fill it in.

The same formula is used to create [★] scores. =reap(“★”,D3).

Just drop down and fill in. As shown in the picture:

Above, I have shared with you the steps to create a star rating in Excel. Friends in need should hurry up and read this article.