# How to Insert Sigma Symbol in Excel (8 Easy Ways)

Microsoft Excel is a very effective software. Excel’s tools and functions enable us to perform an infinite number of operations on a dataset. We need to use the sigma sign to express math and statistics in Excel. Sigma is the Greek alphabet’s eighteenth letter. The lowercase letter sigma (Ïƒ) denotes the standard deviation in math and statistics. In math, the capital letter sigma (Î£) represents to sum it up. This article offers eight straightforward approaches for adding the sigma symbol. Therefore, use these 8 easy ways to insert the sigma symbol in Excel.

## How to Insert Sigma Symbol in Excel: 8 Easy Ways

As an example, let’s look at a sample dataset. For example, the following dataset has Sigma and Symbol columns. We will use each of the eight ways to display the sigma signÂ in Excel. Also, I have yet to say I’ve been working with the Microsoft Office 365 version for this post.

### 1. Embed Sigma Symbol from Insert Tab

Using the Insert tab is the most common approach for inserting the sigma symbol. We can go to three sections from the Insert tab to add the sigma sign. These are the Equation Option, Symbol Option, and Ink Equation.

#### 1.1 From Equation Option

Follow the instructions below to accomplish the task effectively from the Equation Option.

STEPS:

• Select the active worksheet andÂ go to the InsertÂ tab.

• After that, choose Symbols, followed by Equation.

• Then, click the More icon from the Symbols group.

• A new window will open up.
• Pick Greek Letters followed by the Î£ sign from the UppercaseÂ section.

• A tiny Text Box containing an Uppercase Sigma (Î£) sign will come up.

• Now, move the Text Box to cell C5.

• Likewise, go to the window to select Greek Letters and the Ïƒ symbol from the LowercaseÂ section.

• As a result, the tiny Text Box containing the Ïƒ sign opens.

• Next, move this box to cell C6 to see the below output.

Read More: How to Insert Degree Symbol in Excel

#### 1.2 From Symbol Option

The steps for using the Symbol Option properly are outlined below.

STEPS:

• Select cell C5.
• Go to the Insert tab, followed by Symbols to open a new bar.
• This time choose the right section labeled SymbolÂ icon.

• The Symbol window will pop up.
• Next, pick Greek and Coptic from the subset.
• Later, click on the Î£ sign followed by Insert.

• It will produce the intended output as below.

• Choose cell C6.
• Navigate to the Insert tab followed by Symbols to open a new bar.
• Choose the section titled Symbol.

• After that, the Symbol window will appear.
• Select Greek and Coptic in theÂ Subset section.
• Next, click the Ïƒ symbol followed by Insert.

• As a result, it will generate the following output.

#### 1.3 Through Ink Equation

With the help of the Ink Equation, we can insert the sigma sign.

STEPS:

• Navigate to the Insert tab and click on Symbols to open a bar.

• Click on the Down Arrow icon from the bar right below the Equation.
• Another bar will open. Then at the bottom, choose Ink Equation.

• The Math Input Control window will pop up.
• Now, draw an uppercase sigma sign using the Mouse or Touch Pad.
• After that, click Insert.

• A tiny Text Box containing Î£ sign pops up.

• Move the Text Box to cell C5 to see the outcome.

• Open the Math Input ControlÂ window.
• After that, click Insert.

• As a result, a Text Box will open having the ÏƒÂ sign.

• Move the box into cell C6 to get the output.

Read More: How to Type Math Symbols in ExcelÂ

### 2. Use Symbol Font to Type Sigma Symbol

The use of Symbol font is another good way to type the sigma symbol.

STEPS:

• To begin, select cell C5.
• Navigate to the HomeÂ tab.
• Choose Symbol as the Font type.
• After that, type an Uppercase S.

• Again, pick cell C6.
• Navigate to the HomeÂ tab.
• Later, select Symbol as the third font type.
• At this time, type a Lowercase S.

Read More: How to Type Diameter Symbol in Excel

### 3. Employ UNICHAR Function to Insert Sigma Symbol

The UNICHAR function in Excel returns the Unicode symbol corresponding to the given Unicode number. We will enter the sigma using the UNICHAR function in this part.

STEPS:

• First, select cell C5.
• After that, input the following formula.
=UNICHAR(931)
• Hit the Enter or TabÂ key.

• Next, select cell C6.
• Then, enter the following formula.
=UNICHAR(963)
• Now, press Enter or Tab.

### 4. Insert Sigma Through Keyboard Shortcuts

The use of the keyboard shortcut to enter the sigma is the most efficient method.

STEPS:

• To start, pick cell C5.
• Hold down the Alt key and type 228.
• Release the Alt key to see the outcome below.

• Next, choose cell C5.
• While holding the Alt key, type 229.
• Release the AltÂ key.

### 5. From Custom AutoCorrect Shortcut to Add Sigma

STEPS:

• First, navigate to File.

• Choose More, followed by Options.

• The Excel Options window will open up.
• Click Proofing, then pick AutoCorrect Options.

• Due to this, the AutoCorrect window will pop up.
• At this time, type \sigma in the ReplaceÂ box.
• Copy the lowercase sigma from the below section and paste it into the WithÂ box.
Ïƒ

• After that, in the Replace box, write \capsigma.
• Later, copy the uppercase sigma from the area below and paste it into the section titled With.
Î£
• Next, click the Add button followed by OK.

• Again choose OK from the Excel OptionsÂ window.

• At this point, pick cell C5 and type \capsigma.

• After that, press Space followed by the Enter key to see the outcome below.

• Likewise, choose cell C6 and write \sigma.

• Press the Space key, then hit Enter.
• As a result, we can see the output below.

### 6. Input Sigma Sign from Windows 10 Emoji Panel

This method is applicable only to Windows 10 or above version of Windows. To finish this task, go through the steps below.

STEPS:

• To begin, choose cell C5.
• Hold the Windows key down and press the Period (.)Â key.
• The Emoji window will pop up.
• Now, click the SymbolÂ icon.

• Later, find the Î£ sign and tap.

• Thus, it will provide the outcome as follows.

• At this point, choose cell C6.
• Likewise, select the Ïƒ sign from the EmojiÂ window.

• As a result, we will get the desired output as below.

### 7. Copy Sigma Sign from Character Map

In this article section, we will use the Character Map application to embed the sigma symbol in Excel.

STEPS:

• First, go to the Start bar and type Character Map.
• After that, click Character Map from the Best match.

• The Character Map window will display.
• Write Sigma in the Search Box, then choose Search.

• Next, pick the Î£ sign and click the SelectÂ button.

• After that, choose Copy.

• Next, select cell C5 and press Ctrl+V to find the outcome below.

• Open the Character Map and pick the Ïƒ sign followed by the Select.

• At this time, click Copy.

• Choose cell C6 and press Ctrl+V.
• We will find the expected output.

### 8. Insert Sigma Symbol Through Excel VBA

Using VBA, we can import the sigma symbol into Excel. Please follow the instructions below to finish the task quickly.

STEPS:

• Choose the active sheet of the worksheet.
• Navigate to Developer.
• Next, select Visual Basic.

• Click Insert, followed by Module.

• Now, paste the code below into the Module.
Sub inputCapsSigma()
Dim sigma As String
sigma = ChrW(931)
Cells(5, 3).Value = sigma
End Sub
Sub inputSigma()
Dim sigma As String
sigma = ChrW(963)
Cells(6, 3).Value = sigma
End Sub
• Later, click the SaveÂ icon.

• Pick cell C5, then go to Macros.

• The Macros window will pop up.
• Select inputCapsSigma and then click Run.

• Thus, it will produce the intended outcome.

• Choose cell C6 followed by MacroÂ to open the window.
• At this time, pick inputSigma and later tap Run.

• We will get our desired output.

Obtain a free copy of the sample workbook utilized during the session.

## Conclusion

You can insert the sigma symbol into Excel by following the methods we just covered. On our website, there are other articles similar to this one. Continue using them, and let us know if you have additional methods or fresh ideas for completing the task. Please leave any questions, remarks, or recommendations in the space below.

## Related Articles

<< Go Back to Mathematical Symbols in Excel | Insert Symbol in ExcelÂ |Â Excel SymbolsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Lutfor Rahman Shimanto

Lutfor Rahman Shimanto, BSc, Information Technology, Jahangirnagar University, Bangladesh, has worked with the ExcelDemy project for over a year. He has written 50+ articles and provided solutions of 100+ comments for ExcelDemy. Currently, he works as an Excel & VBA Developer and provides support and solutions in the ExcelDemy Forum. He has solved 100+ ExcelDemy Forum problems. His work and learning interests are in developing various Excel & VBA and Desktop applications. Outside of work, he enjoys Chess... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF