Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
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 REPT function. REPT Function is useful when you want to repeat a given text for a number of times.
Your template is ready.
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.
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.