See all How-To Articles

How to Type a Star Symbol in Excel & Google Sheets

In this tutorial, you will learn how to insert a star symbol in Excel and Google Sheets.

 

star symbol excel

 

Insert a Star Using the 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, (1) select a cell where you want to insert a star (e.g., B2), then in the Ribbon, (2) go to the Insert tab, and (3) click on Symbol.

 

insert symbol in excel 1

 

2. In the Symbol window, (1) choose the Wingdings Font first. After that, (2) select a star icon, and (3) click on Insert.

 

insert symbol in excel 2

 

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

 

star symbol excel

 

Insert the Star Symbol in Google Sheets

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

First (1) open a Google Docs file, then (2) go to Insert, (3) click on Special characters and (4) choose a star symbol. Following these steps, you will get a star symbol in Google Docs and you can simply copy it to Google Sheets. (See How to Insert Signs and Symbols in Excel & Google Sheets for more detail.)