How to Insert Cross Text Symbol in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on April 17, 2023

This tutorial demonstrates how to insert a cross text symbol into Excel and Google Sheets.


CrossText intro


Insert Cross Text Symbol

Excel has a few options for inserting a cross symbol. The first is to use Insert Symbol.

  1. In the Ribbon, go to Insert > Symbols > Symbol.


symbols ribbon


  1. This brings up the Symbol window. You can resize the box to see more symbols by dragging the bottom-right corner of the box.
  2. In the Font drop down, set the font to Wingdings.


InsertTick Wingdings


  1. Scroll down until you find the cross symbol and click Insert.


CrossText Symbol Insert


  1. Click Close to return to Excel.

Note: You can also change the font to Wingdings 2 and find the cross symbol in that character set.


CrossText Symbol Wingdings2


Cross Symbol – Wingdings Font and Alt Code

You can also insert a cross symbol into Excel by changing the font to Wingdings in the Excel screen and typing the character û directly into the cell.

  1. In the Ribbon, go to Home > Font and then choose Wingdings from the Font drop down.
  1. Hold down the ALT key, and then type 0251 on the numeric keypad (Alt codes don’t work with the numbers at the top of the keyboard).


Cross Text Wingdings U


  1. This inserts the character û. Wingdings displays this character as a cross mark.

Cross Mark – Wingdings 2

  1. In the Ribbon, go to Home > Font and choose Wingdings 2 from the Font drop down.


InsertTick Wingdings2


  1. In the selected cell, hold down the SHIFT key and press the letter O (uppercase O).


CrossText Wingdings2-ShiftO


Insert Cross Text Symbol in Google Sheets

Insert cross symbols into Google Sheets by using the CHAR Function.

Select the cell you wish to insert your cross text symbol into and type in the CHAR Function with the relevant number (for example: 10007).


CrossText GoogleSheets Char


Using the numbers 10005, 10006, 1008, and 128502 with the CHAR Function shows slightly different cross marks.


CrossText GoogleSheets Chars


Note: See How to Insert a Checkmark/Tick for inserting checkmarks and Special Characters in Google Docs for copy-pasting symbols from Google Docs.

AI Formula Generator

Try for Free

See all How-To Articles