In this article:

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

January 13, 2025

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 article on how to import XLSB to Google Sheets.

Turn PDFs into spreadsheet tables with AI

Use Lido to extract data from contracts, invoices, financials, and more in seconds. Save time, reduce errors.
  • No credit card required
  • 20 free pages