In this article:

How to Add a Star Rating in Google Sheets (Easiest Way in 2024)

May 8, 2024

Can You Insert a Star Rating in Google Sheets?

Google Sheets now offers a built-in rating feature that allows for easy entry of star ratings in cells. To add star ratings in Google Sheets, type @rating in the cell you want to format for a star rating and press Enter. This will allow you to select a rating from 0 to 5 stars for that cell. 

How to Add a Star Rating in Google Sheets

Below we outline the steps on how to add a star rating in Google Sheets:

1. Select a Cell 

Click on the cell where you want the star rating. 

how to add star rating in google sheets

2. Enter Rating Command

Type @rating in the selected cell and press Enter. 

google sheets star rating

3. Choose Your Rating

After pressing Enter, a menu will appear allowing you to choose from 0 to 5 stars. Click on the number of stars you wish to assign.

star rating google sheets
star rating in google sheets

We hope that this article has helped you and given you a better understanding of how to add a star rating in Google Sheets.

If you enjoyed this article, you might also like our articles on how to make an employee schedule in Google Sheets and how to import XLSB to Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->