How to create a five-pointed star in Excel_A function can help you

How to draw a five-pointed star in Excel easily? PHP editor Youzi will introduce you to a simple and easy-to-use function to solve this problem. With this function, you only need to enter a few parameters to draw a five-pointed star with customizable size and color. Read on for our detailed guide to learn how to create a flawless pentagram in this spreadsheet program.

First of all, if you want to quickly enter the star rating, you must have a rating column. The number of stars depends on the rating. Let's take the following table as an example.

Here is how to input a five-pointed star. Use your Chinese input method. Press and enter V1 to enter the special symbol input mode, then turn the page to find the five-pointed star. Just click on the star, or you can select the symbol in the insert tab above and find the five-pointed star there.

Then we enter the function =REPT in the cell to be rated. The meaning of this function is that the text can be displayed repeatedly according to the defined number of times, which is equivalent to copying the text.

The function is =REPT("★",B2), which indicates how many five-pointed stars are displayed based on the rating in cell B2.

Finally confirm, double-click to fill in, and the quick star rating will come out. Isn’t it very simple?

The above is the detailed content of How to create a five-pointed star in Excel_A function can help you. For more information, please follow other related articles on the PHP Chinese website!