How to Insert Star Symbol in Excel
Adding special symbols, like a star, in Excel can give your data more context or make your worksheets more visually engaging. Here are two easy ways to insert a star symbol:
Method 1: Insert Symbol Feature
- Select the cell where you want to insert the star symbol.
- Click on the
Insert
tab in the ribbon, then click onSymbol
. - In the
Symbol
dialog box, setFont
toWingdings
. - Scroll down until you see the star symbols, select the one you want, and click
Insert
.
Method 2: Using a Keyboard Shortcut
- Select the cell where you want to insert the star symbol.
- Press
Alt
on your keyboard and keep it held down. - Type
042
on the numeric keypad while still holding down theAlt
key. - Release the
Alt
key, and a star symbol (*) should appear in your selected cell.