See all How-To Articles

How to Type a Star Symbol in Excel & Google Sheets

This tutorial demonstrates how to insert a star symbol in Excel and Google Sheets.


star symbol excel


Insert a Star With Wingdings Font

In Excel, you can insert various symbols as text. One of those symbols is a five-pointed star. To insert a star symbol, follow these steps:

  1. First, select the cell where you want to insert a star (e.g., B2), then in the Ribbon, go to the Insert tab, and click Symbol.


insert symbol in excel 1


  1. In the Symbol window, first set the Font to Wingdings. After that, click the star icon, then click Insert.


insert symbol in excel 2


As a result, you get a star symbol in cell B2.


star symbol excel


Insert Star Symbol in Google Sheets

Google Sheets still doesn’t have an option for inserting a star. There is a workaround that includes the help of Google Docs.

  1. Open a Google Docs file.
  2. Then, go to Insert.
  3. Click Special characters.
  4. Choose a star symbol.
  5. Following these steps, you will get a star symbol in Google Docs and you can simply copy it to Google Sheets.

See Special Characters in Google Docs for more detail.

See all How-To Articles