Insert Sigma Symbol in Excel (Σ or σ)

Sumit Bansal
Written by

Sumit Bansal is the founder of TrumpExcel.com and a 13-time Microsoft Excel MVP. He started this site in 2013 to share his passion for Excel through easy tutorials, tips, and training videos, helping you master Excel, boost productivity, and maybe even enjoy spreadsheets!

Last updated

In various fields like statistics, mathematics, and engineering, the sigma symbol (Σ or σ) is frequently used, often representing the sum of a set of terms or as a symbol for standard deviation in statistics.

There are two types of sigma symbols:

  • Σ – Greek Capital Letter Sigma
  • σ – Greek Small Letter Sigma

In this article, I’ll guide you through several straightforward methods to insert the Sigma symbol into your Excel documents.

Insert Sigma Symbol in Excel (Σ or σ)

Below are some details about the sigma symbol. The methods to insert the symbol in Excel are covered after the table:

Details / MethodsDescription
Symbol NameSigma
SymbolΣ (capital sigma)
σ (small sigma)
Keyboard ShortcutALT + 228 for Σ
ALT + 229 for σ
Formula=UNICHAR(931) to get Σ
=UNICHAR(963) to get σ
Character Code (Symbol Dialog Box)03A3 for Σ
03C3 for σ
Equation Text\Sigma for Σ
\sigma for σ

Standard Deviation Symbol (σ) and Summation Symbol (Σ) in Excel

Before you insert anything, it helps to know which sigma you need, because the two mean different things.

If you’re after the standard deviation symbol, you want the small sigma (σ). If you’re after the summation symbol, the one that means “add these up”, you want the capital sigma (Σ).

The symbol is only a character in a cell, so it doesn’t calculate anything. To get the actual number, see how to calculate standard deviation in Excel.

Also, the Σ button on the Home tab won’t insert the symbol. That button is AutoSum, which adds up your numbers.

You may also come across a lookalike, the N-ary summation sign (∑). It isn’t the Greek letter, even though it looks almost the same.

Excel sees them as different characters, so the COUNTIF or XMATCH function looking for Σ won’t match a cell holding ∑. If you’re not sure which one you have, =UNICODE(A1) returns 931 for Σ and 8721 for ∑ (with the symbol in cell A1).

If you do want the ∑ sign, you can get it with =UNICHAR(8721) or by entering the code 2211 in the Symbol dialog box.

Copy and Paste the Sigma Symbol into Excel

The easiest way to get the sigma symbol in Excel is by copying it from a source and pasting it into your spreadsheet.

Below are the sigma symbols for you to copy.

Greek Capital Letter Sigma

Σ

Greek Small Letter Sigma

σ

Use Control + C to copy this symbol, then go to the desired cell in Excel where you want this symbol, and use Control + V to paste it.

Also read: Insert X-Bar (Average / Mean) Symbol in Excel

Keyboard Shortcut to Insert the Sigma Symbol in Excel

Below are the keyboard shortcuts to get the Sigma symbols in Excel:

Greek Capital Letter Sigma (Σ)

ALT + 228

Greek Small Letter Sigma (σ)

ALT + 229

Follow these steps to use this shortcut:

  1. Select the cell where you want the sigma symbol.
  2. Hold down the ALT key.
  3. While holding the ALT key, type 2, 2, and 8 on the numeric keypad (for inserting the capital letter sigma symbol). For the small sigma symbol, type 2, 2, and 9.
  4. Release the ALT key.

Once you release the ALT key, the sigma symbol will appear in the selected cell.

To use this shortcut, you need to use the Numeric keypad on your keyboard (it doesn’t work with a regular keyboard without a numeric keypad). Also, the Num Lock must be enabled.

If your laptop doesn’t have a numeric keypad, the copy and paste method above or the formula method below will get you the symbol.

Type 228 without a leading zero. With the zero (ALT + 0228), Windows looks the number up in a different code table, and you get ä instead of Σ.

On US English Windows setups, ALT + 228 gives Σ. On some other language setups (many Western European ones, for example), the same code gives õ instead, so use one of the other methods in this article.

If you’re on a Mac, press Control + Command + Space to open the Character Viewer. Search for “sigma” and click the symbol to insert it (double-click it if the viewer is expanded).

Pro Tip: In MS Word, you can insert the sigma symbol by typing 03A3 and then pressing ALT + X to get the capital sigma symbol (Σ), or typing 03C3 and then pressing ALT + X to get the small sigma symbol (σ).

Formula to Insert the Sigma Symbol

The sigma symbol can also be inserted using an Excel formula.

Formula to get the Greek Capital Letter Sigma (Σ)

=UNICHAR(931)
UNICHAR formula in cell A2 returning the capital sigma symbol

Formula to get the Greek Small Letter Sigma (σ)

=UNICHAR(963)
UNICHAR formula in cell A2 returning the small sigma symbol

931 and 963 are the Unicode numbers for Σ and σ, which is what the UNICHAR function reads. It works in Excel 2013 and later versions.

Since the ALT code is 228, you might try =CHAR(228) as the formula version. That returns ä, not Σ, because the CHAR function reads a different code table, so stick with UNICHAR.

After the sigma symbol appears in the cell, you can remove the formula to leave only the static symbol.

Also read: Insert Alpha Symbol in Excel

Insert Sigma Symbol Using the Symbol Dialog Box

Another method is using the built-in Symbol dialog box in Excel:

  1. Select the cell where you want the sigma symbol.
  1. Click on the ‘Insert’ tab in the ribbon.
Insert tab in the Excel ribbon
  1. Click on the ‘Symbol’ icon to open the Symbol dialog box. If the Symbols group is collapsed, click Symbols first.
Symbol option in the Symbols group on the Insert tab
  1. In the Subset dropdown, select ‘Greek and Coptic’.
Symbol dialog box with Greek and Coptic selected in the Subset drop-down
  1. Locate the sigma symbol (Σ or σ) and double-click on it (or select it and click on the Insert button).
Capital sigma symbol selected in the Symbol dialog box

This will insert the sigma symbol into the cell. The dialog box stays open after that, so click Close when you’re done.

The cell is still in edit mode at this point, so press Enter to confirm the entry.

Shortcut: ALT + N + U can be used to open the Symbol dialog box quickly. Press the keys one after the other.

Pro Tip: To find the sigma symbol easily in the Symbol dialog box, enter 03A3 (for Σ) or 03C3 (for σ) in the Character code field, with ‘from’ set to Unicode (hex).

Using the Character Map

Windows Character Map is a useful tool for inserting the sigma symbol:

  1. Search for ‘Character Map’ in the Windows search bar.
  1. Click on the Character Map App option.
Character Map app open on Windows
  1. Check the ‘Advanced view’ option, which would make more options visible.
Advanced view option checked in the Character Map dialog box
  1. In the ‘Search for’ field, type ‘sigma’ and hit enter.
Search results for sigma in the Character Map dialog box

The search shows a few lookalike characters, so click one and check its name at the bottom of the dialog box. You want Greek Capital Letter Sigma (Σ) or Greek Small Letter Sigma (σ).

  1. Locate the sigma symbol, double-click it, then click ‘Copy’. This copies the sigma symbol to the clipboard.
Capital sigma symbol in the Characters to copy box with the Copy button in Character Map
  1. Paste the symbol in Excel or any other application.

This method is not limited to Excel only and can be used across applications on Windows.

Also read: Insert Pi Symbol (π) in Excel

Using the Equation Feature in Excel

When working with Greek symbols, you can also use this nifty Equation feature trick to get the symbol quickly.

Let me show you how it works:

  1. Click the Insert tab in the ribbon.
Insert tab in the Excel ribbon
  1. Click on the top part of the Equation icon (the bottom part opens a gallery of ready-made equations). If the Symbols group is collapsed, click Symbols first.
Top part of the Equation icon in the Symbols group on the Insert tab

If the Equation icon is greyed out, you’re still editing a cell. Press Esc to leave the cell, and the icon becomes available again.

  1. In the Equation box that is inserted in the worksheet, type the following text. It replaces the ‘Type equation here’ prompt.

For capital sigma symbol (Σ):

\Sigma

For small sigma symbol (σ):

\sigma

Make sure you use a backslash here. With a forward slash (/), Excel starts building a fraction, and you never get the symbol.

  1. After typing the text, press the space bar key.
Capital sigma symbol in the Equation box after typing \Sigma and pressing the space bar

When you hit the space bar key, the text would automatically (or should I say automagically) be converted into the sigma symbol.

You can now copy and use this symbol in any cell in Excel.

  1. Select the symbol in the Equation box and press Control + C to copy it.
Capital sigma symbol selected in the Equation box
  1. Double-click the cell where you want the symbol (or select it and press F2), press Control + V, and then press Enter.
Capital sigma symbol pasted into cell A2 in edit mode

Pasting while you’re editing the cell matters here. If you paste with the cell just selected, Excel also brings over the equation’s Cambria Math font and makes the row much taller.

The small sigma comes across as a slanted math character (𝜎), not the regular σ, and Excel treats the two as different characters. So if you need the regular σ, for example to match it in a formula, use another method in this article.

Once you’re done, click the Equation box, press Esc, and then press Delete to remove it.

If you need the sigma symbol often, you can also set up an AutoCorrect entry so Excel types it for you. I’ve covered that in How to Insert Symbols in Excel.

This article covered various methods that should help you effortlessly insert the sigma symbol in Excel. If you know of any other methods, please share them in the comments section below.

I hope you found this Excel article helpful.

Other Excel articles you may also like:

Sumit Bansal

Sumit Bansal

13x Microsoft Excel MVP

Hey! I'm Sumit Bansal, founder of trumpexcel.com and a Microsoft Excel MVP. I started this site in 2013 because I genuinely love Microsoft Excel (yes, really!) and wanted to share that passion through easy Excel tutorials, tips, and Excel training videos. My goal is straightforward: help you master Excel skills so you can work smarter, boost productivity, and maybe even enjoy spreadsheets along the way!

Get the FREE 51 Excel Tips Ebook

Enter your details and the free PDF is on its way to your inbox.

Hmm, that didn't go through. Please check your email and try again.

No spam. You'll also get my weekly Excel newsletter. Unsubscribe anytime.

Check your inbox!

The ebook is on its way to your email. It usually lands within a couple of minutes.