For a multiplication-style x (×), hold Alt and type 0215 on the numeric keypad, then release Alt; Excel has no dedicated X-mark shortcut of its own. If you mean a different cross, such as ✗, or you do not have a numeric keypad, use Insert > Symbol in Excel and select the character you need.
The Windows shortcut and what it enters
In Excel for Microsoft 365 on Windows, Alt+0215 is the standard Windows numeric-keypad code for the multiplication sign, ×. Hold down the Alt key, enter 0, 2, 1, 5 using the separate numeric keypad, and release Alt. The character should appear in the active cell or in the formula bar if you are editing there. This is a Windows text-entry method, not a shortcut unique to Excel.
The leading zero matters: enter 0215 rather than just 215. Use the keypad digits, not the number row above the letters. On a laptop with no separate keypad, an embedded keypad may work if your keyboard provides one, but the key combination varies by model. If Alt+0215 does not enter the symbol, use Excel’s Symbol dialog or copy and paste the character instead.
The shortcut inserts a character into a cell; it does not perform multiplication. The cell will generally contain text if it contains only the symbol. You can put the symbol beside a result, use it in a label such as “units × price,” or include it in explanatory worksheet text. A formula that calculates a product uses the asterisk operator, not the printed multiplication sign.
Which kind of X mark do you mean?
People use “x mark” for several visually similar characters, and choosing the right one avoids confusion in reports, checklists, and data. The Alt+0215 code gives you ×, the mathematical multiplication sign. It is designed for arithmetic notation and is usually more balanced than a lowercase letter x.
- × Multiplication sign: Use it in prose or headings to show multiplication, dimensions, or a size such as 8 × 10. The Alt+0215 method enters this character on Windows.
- x Lowercase letter: Press the ordinary X key while Caps Lock is off. This is a letter, not the multiplication symbol, even though it is often used informally in dimensions or product names.
- ✗ Cross mark: This is a ballot-style cross often used to indicate an incorrect or rejected item. It is a different Unicode character from ×.
- ✘ Heavy ballot X or ❌ emoji: These are heavier or more pictorial marks. Their appearance depends on the font and application, and an emoji may display in color.
For a worksheet that will be printed or shared, choose the character that conveys the intended meaning rather than relying only on how it looks on your screen. A reader may mistake an arithmetic symbol for a check-off mark, or a decorative cross for an operator.
Insert the symbol through Excel’s Symbol dialog
The Symbol dialog is the dependable built-in route when you need a particular character, have no numeric keypad, or want to choose a mark other than ×. In Excel for Microsoft 365 on Windows, click the destination cell, select the Insert tab, and choose Symbol. Find the character in the dialog, select it, and choose Insert. Close the dialog when you are done. The exact selection controls can vary slightly with the font and Office interface.
- Click the cell where the mark should go. To add a character within existing cell text, press F2 or click in the formula bar and place the insertion point first.
- Open Insert > Symbol. Choose a font that supports the symbol; a standard text font is a sensible starting point.
- Select the character you want, such as the multiplication sign or a cross mark, and click Insert.
- Close the dialog and check how the character displays in the cell and in any exported or printed version.
For the multiplication sign, the Unicode value is U+00D7. In the Windows Symbol dialog, if the character-code field is available and set to Unicode (hex), entering 00D7 can help locate it directly. A code is a useful way to distinguish symbols that look alike, but check the character preview before inserting it. Font support affects whether a mark appears as intended.
Entering the mark on Mac and in Excel for the web
The Windows Alt+0215 code is not the Mac equivalent. In Excel for Mac, open the macOS Character Viewer with Control+Command+Space, search for “multiplication sign,” and insert ×. You can also use Excel’s Insert menu and its symbol option when available. The Character Viewer is particularly helpful for finding less common marks such as ✗, since searching by the character’s name is easier than memorizing a code.
Excel for the web runs in a browser and does not offer every desktop insertion control in every interface. If you cannot find a Symbol command, copy the desired character from a trusted source or use the operating system’s character picker, then paste it into the cell. Copying the actual character is different from copying a picture of it: a text character can be edited, searched, and included in cell text.
When collaborating across Windows, Mac, and web versions, test the workbook in the environment where it will be used. Unicode characters are widely supported, but a particular font or device may substitute a different glyph or show a missing-character box. For an ordinary multiplication sign this is uncommon with standard fonts, but it is more plausible with decorative or emoji-style marks.
Use a formula when the symbol should be generated
If you need Excel to return the same mark in many cells, a formula can generate it from its Unicode number. With cell A1 empty and intended to hold the result, enter =UNICHAR(215) in A1; the displayed result is ×. UNICHAR is available in modern Excel, including Microsoft 365. This can be useful in a template or a column where a symbol is produced alongside other formula-driven content.
That formula returns a text character; it does not multiply values. For example, if A2 contains 4 and B2 contains 6, enter =A2*B2 in C2 to calculate 24. If you want to show the operation as text, you could type “4 × 6” in a label cell, but that text will not calculate. Keeping the displayed notation separate from the calculation makes the worksheet easier to audit.
A formula-generated symbol remains formula-driven until you replace it. If you need a fixed text character, copy the result and use Paste Special > Values, or simply insert the symbol directly. Do not use UNICHAR as a shortcut for every cross without checking its code: 215 is specifically the multiplication sign, not the ballot cross.
Display, formatting, and practical uses
Excel treats an inserted mark according to the way it is used. A cell containing only × is text, so it is not a number that Excel can add or multiply. In a longer text label, it is simply one character among the others. You can change its font, size, color, alignment, or number of visible characters using ordinary cell formatting, just as you would for other text.
To make a label such as “Width × height,” enter the text directly or insert the symbol at the desired point while editing the cell. For arithmetic, keep numbers in their own cells and use the asterisk in the formula. For instance, a worksheet could show 8 in A2 and 10 in B2, calculate their product in C2 with =A2*B2, and use a separate heading reading “8 × 10.” The heading communicates notation; the formula supplies the numeric result.
For a checklist, a cross mark can be a visual status indicator, but it is not automatically a checkbox or a logical TRUE/FALSE value. If you need values that can be filtered, counted, or used in formulas, store a consistent status such as “Complete” or “Not complete” in the data and use the symbol only as a display choice. That distinction helps prevent a worksheet that looks clear from becoming difficult to analyze.
Common problems and quick fixes
- Nothing appears after Alt+0215: Make sure you held Alt until after entering all four digits, used the numeric keypad, and included the leading zero. On a laptop, use the Symbol dialog or character picker if there is no usable keypad.
- You get the wrong character: Check whether you entered 0215 rather than a different code, and confirm that the selected symbol is × rather than a letter x or a ballot cross.
- The symbol looks like a letter: Change the font or insert the multiplication sign from the Symbol dialog. The lowercase x and × can look similar at small sizes, but they are different characters.
- A mark becomes a blank box elsewhere: The receiving system may not have a font with that glyph. Try a widely supported font and verify the workbook in the target application before distributing it.
- A formula does not calculate: Use * between numeric references, not ×. The × character is for displayed text; Excel formulas require the multiplication operator.
Frequently Asked Questions
What is the keyboard shortcut for the multiplication sign in Excel?
On Windows, hold Alt, type 0215 on the numeric keypad, and release Alt to enter ×. Excel does not have a separate built-in shortcut dedicated to this symbol.
Can I use Alt+0215 on a laptop without a number pad?
Only if the laptop provides an embedded numeric keypad that supports the code. The layout differs by model, so Insert > Symbol or the operating system’s character picker is usually the simpler alternative.
How do I type a cross mark such as ✗ instead of ×?
Use Insert > Symbol in desktop Excel, or search for the cross mark in the Mac Character Viewer. Alt+0215 inserts ×, not ✗.
How do I multiply numbers in an Excel formula?
Use the asterisk operator between values or cell references, for example =A2*B2. Typing the visible symbol × into a formula does not replace the asterisk operator.
Does Alt+0215 work in Excel for Mac?
No; it is a Windows numeric-keypad method. On Mac, open Character Viewer with Control+Command+Space and search for the multiplication sign, or use Excel’s symbol insertion option.
Related
- Excel Text to Columns Using Enter: Split Line Breaks
- Excel Text to Columns: Choosing a Number Delimiter
- Excel Text to Columns Shortcut: Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Set Print Area in Excel: Steps, Pages, and FixesIn Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page Layout…
- Excel Find and Replace Preview: How to Check ChangesExcel for Microsoft 365 on Windows does not provide a separate preview screen for Replace All. To review…
- COUNTIF Duplicate Formula in Google SheetsTo flag every nonblank value that appears more than once in Google Sheets, put this formula beside the…
- Excel Cell Text Limit: Characters, Display, and FixesIn Microsoft Excel for Microsoft 365 on Windows, a cell can contain up to 32,767 characters, including spaces…
- Inventory Spreadsheet: Simple Setup and Useful TipsYes—an inventory spreadsheet can be simple: list each item once, record its quantity and reorder point, and update…
- How to Group Dates by Year in Excel with a PivotTableTo group dates into years in Excel, place the date field in a PivotTable, right-click any date in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.